News for hackers. Stuff that matters.

A comment on D1: Our SQL database. Parent comment

Re:D1: Our SQL database by chrisshroba on Wednesday May 11, 2022 @10:39AM (#31340604)
DuckDB comes to mind, but I can't speak to its differences from SQLite.

https://duckdb.org/

[ Parent | on HN ]
Re:D1: Our SQL database by anyfactor on Wednesday May 11, 2022 @10:56AM (#31340885)
I 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

Duckdb on HN: https://news.ycombinator.com/item?id=23287278

[ Parent | on HN ]
Re:D1: Our SQL database by 1egg0myegg0 on Wednesday May 11, 2022 @07:39PM (#31347430)
Close! DuckDB has very fast bulk insert speeds, but slower individual row insertion/update speeds. (Disclaimer: I write docs for DuckDB)
[ Parent | on HN ]
Re:D1: Our SQL database by gigatexal on Wednesday May 11, 2022 @11:29AM (#31341431)
DuckDB is Olap SQLite. The vector engine is dope. But most of the innovation is in the OLAP stuff.
[ Parent | on HN ]