News for hackers. Stuff that matters.
Re:Rearchitecting: Redis to SQLite by akira2501 on Wednesday September 25, 2024 @07:25PM (#41652937)
Seriously?

https://www.sqlite.org/optoverview.html

Chapter 2. Chapter 7. Chapter 8.

It should be _zero_ surprise to you that SQLite is not as powerful as other full database query engines.

Re:Rearchitecting: Redis to SQLite by simonw on Wednesday September 25, 2024 @10:54PM (#41654077)
I don’t understand how reading that documentation page makes it clear that other relational engines have better performance for joins.
Re:Rearchitecting: Redis to SQLite by anacrolix on Thursday September 26, 2024 @01:03AM (#41654689)
I'm with you. I've encountered numerous situations where the query planner caused issues. I don't know if the alternatives are better, but it's definitely an issue. I've written multiple databases wrapping SQLite, and multiple bindings to SQLite. There are dragons.
Re:Rearchitecting: Redis to SQLite by vrighter on Thursday September 26, 2024 @07:17AM (#41657028)
I had to use sqlite once for something that would do a ton of read queries on a particular table. Sometimes just swapping the order of operands to an and operation generated a completely different query plan. Had to scour their optimizer document and painstakingly check the query plans of, and then manually tune, each sql statement.

But then it was quite fast.