4 ms·
Sqlite is not a toy, but it's so sloppy that it's not really a tool either. Like a saw with a loose blade, it can help you cut but it can also hurt you. My pet
by eleog 6y ago
Sqlite is not a toy, but it's so sloppy that it's not really a tool either. Like a saw with a loose blade, it can help you cut but it can also hurt you. My pet peave is the way sqlite accepts non-aggregated columns in a GROUP BY query. You'll get a result in the column, but it's not clear what it means.
More of sqlite's sloppyness is detailed here https://sqlite.org/src/wiki?name=StrictMode https://sqlite.org/src/wiki?name=StrictMode
- outworlder 6y agoMySQL is also very "sloppy". People have learned to work around its quirks. Honestly, SQLite is a wonderful tool if properly used. Calling it "sloppy" is a disservice.
- leijurv 6y ago> My pet peave is the way sqlite accepts non-aggregated columns in a GROUP BY query. Funnily enough, this is my favorite feature of sqlite that I wish other RDBMSs had :)) There is no easy equivalent to `SELECT order_id, status AS latest_status, MAX(updated_at) AS updated_at FROM orders GROUP BY order_id`. Well, it's possible, but for example in Postgres you need some silliness with nested queries, `PARTITION BY`, and `ROW_NUMBER()`.