Hacker News Reader

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

View on HN

> 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()`.

MySQL 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.

Reply on news.ycombinator.com