3 ms·
I have a CLI tool (written in Python) called twitter-to-sqlite which imports Tweets into a SQLite database - it's a really fun source of data to play with: http
by simonw 6y ago
I have a CLI tool (written in Python) called twitter-to-sqlite which imports Tweets into a SQLite database - it's a really fun source of data to play with: https://datasette.io/tools/twitter-to-sqlite https://datasette.io/tools/twitter-to-sqlite
- fiddlerwoaroof 6y agoI've been using your Datasette tools a bunch, they're really great for quick data analysis. Recently I've been play with doing an `sqlite foo.db dump` and then loading the dump into sql.js as the "DB" for statically-hosted websites. It's probably impractical because the sqlite.wasm file is a couple megs, but it's a fun proof of concept.
- simonw 6y agoThat sounds like a really useful trick.
- fiddlerwoaroof 6y agoI came up with it because I was trying to figure out how to host data from datasette on GitHub Pages.
- divyenduz 6y agoAha, amazing, I have played with datasette in past, great work. I will link this tool back in the blog post today if you don’t mind :)