News for hackers. Stuff that matters.
Re:SQLite is not a toy database by pdimitar on Thursday March 25, 2021 @06:29PM (#26586421)
Not sure why you were downvoted because that is a legitimate concern and it's my only beef with sqlite3. I will kill for an embedded PostgreSQL. If sqlite3 becomes that I'll absolutely pay for a license if they require it.
Re:SQLite is not a toy database by legg0myegg0 on Thursday March 25, 2021 @09:56PM (#26588029)
Check out DuckDB! It is designed for OLAP instead of OLTP, but it uses Postgres syntax and types! It's columnar and lightning fast for big queries.
Re:SQLite is not a toy database by pdimitar on Friday March 26, 2021 @09:47AM (#26592083)
Been looking for an excuse to use it, this might just be the one. :)