4 ms·
I'm exactly at a point where I'm considering SQLite for its single file db advantage, but I'm struggling to find solutions for my use case. I need to import so
by alin23 5y ago
I'm exactly at a point where I'm considering SQLite for its single file db advantage, but I'm struggling to find solutions for my use case.
I need to import some 30k JSONs of external monitor data from Lunar (https://lunar.fyi https://lunar.fyi) into a normalized form so that everyone can query it.
I'd love to get this into a single SQLite file that can be served and cached through CDN and local browser cache.
But is there something akin to Metabase that could be used to query the db file after it was downloaded?
I know I could have a Metabase server that could query the SQLite DB on my server, but I'd like the db and the queries to run locally for faster iteration and less load on my server.
Besides, I'm reluctant to run a public Metabase instance given the log4j vulnerabilities that keep coming.
- zbentley 5y agoCheck out datasette: https://datasette.io/ https://datasette.io/
- dkjaudyeqooe 5y agoYou could do incremental updates of the local databases using the session extension: https://sqlite.org/sessionintro.html https://sqlite.org/sessionintro.html