3 ms·
Has anyone tried to write a new modern SQLite?
by vaughan 4y ago
Has anyone tried to write a new modern SQLite?
- chrisshroba 4y agoDuckDB comes to mind, but I can't speak to its differences from SQLite. https://duckdb.org/ https://duckdb.org/
- anyfactor 4y agoI haven't tried duckdb but I have been googling about it. I think I saw a discussion where it was mentioned that duckdb isn't a replacement for SQLite. It is an OLAP database [0] which makes its ingestion time slower than SQLite, I think. So it is meant for analytics but not as fullfledge replacement for SQLite. [0]: https://en.wikipedia.org/wiki/Online_analytical_processing https://en.wikipedia.org/wiki/Online_analytical_processing Duckdb on HN: https://news.ycombinator.com/item?id=23287278 https://news.ycombinator.com/item?id=23287278
- 1egg0myegg0 4y agoClose! DuckDB has very fast bulk insert speeds, but slower individual row insertion/update speeds. (Disclaimer: I write docs for DuckDB)
- deleted 4y ago[deleted]
- gigatexal 4y agoDuckDB is Olap SQLite. The vector engine is dope. But most of the innovation is in the OLAP stuff.
- sophacles 4y agoWhy? Yes sqlite doesn't have all the features postgres has. Postgres doesn't have all the features the sqlite has either. What's wrong with having different tools with different sets tradeoffs. It's a different shape of Lego and that's fine - some things call for a 1/3height 2x2 and others call for a full height 1x8.
- jpcapdevila 4y agoI think the most successful attempt would be Realm. https://realm.io/ https://realm.io/
- steaminghams 4y agowhy do you consider sqlite to not be modern? all the hip service providers seem to be all over it which would indicate pretty good modernity to me at least.
- deleted 4y ago[deleted]