2 ms·
Maybe it would be interesting to replace Sqlite with DuckDB, since both of them are in-process databases, but Sqlite is OLTP and DuckDB is OLAP. I wager most in
by giovannibonetti 5y ago
Maybe it would be interesting to replace Sqlite with DuckDB, since both of them are in-process databases, but Sqlite is OLTP and DuckDB is OLAP. I wager most interesting queries will be better served by an OLAP database, like facets: https://simonwillison.net/2018/May/20/datasette-facets/ https://simonwillison.net/2018/May/20/datasette-facets/