3 ms·
If you're using sqlite, but for a static website, you might consider using duckdb. It's still evolving, but it has huge potential. It's also an embedded single
by snidane 6y ago
If you're using sqlite, but for a static website, you might consider using duckdb. It's still evolving, but it has huge potential.
It's also an embedded single file database like sqlite, but stores data in columns. Duckdb to sqlite is like redshift to postgres.
Hopefully they will add compression for string columns, so that host your entire static site from a single file in a very efficient way.
https://duckdb.org/ https://duckdb.org/
https://youtu.be/PFUZlNQIndo https://youtu.be/PFUZlNQIndo
- scary-size 6y agoIt literally says OLAP on their website. Why would I use this for a static website?
- snidane 6y agoIf you have a static website with a lot of data behind it, eg. a map visualizing some larger dataset, then OLAP database will be actually a very good backing storage.
- setr 6y agoThat seems like an oddly specific thing to assume when suggesting it for use by static websites generally — afaict most static sites would see no distinct benefit from columnar storage. That said, SQLite for OLAP is very neat.