-
💭 Database Remote-Copy Tool For SQLite (draft)
Simon shared a really cool new utility tool for sqlite ispired by rsync. It checks hashes of each sqlite page and syncs
-
💭 Sqlite-jiff
Sqlite is getting rust extensions now, and datetimes make it totally worth if if they work well and and fast, two things
-
💭 sql - How can I list the tables in a SQLite data...
I learned about the sqlitemaster table from this stack overflow answer. This helps make a lot of sense to how sqlite w
-
💭 sql - SQLite: COUNT slow on big tables - Stack O...
Another interesting option for slow count queries in sqlite. > If you haven't DELETEd any records, doing: sql SELE
-
💭 Optimizing SQLite for servers
Very interesting article by Sylvain, suggested by Simon Willison. Definitely some things that I want to come back and t
-
💭 searching my thoughts locally
First I need to fetch my thoughts from the api, and put it in a local sqlite database using sqlite-utils. bash ft
-
💭 Open source, not open contribution with Ben John...
Ben Johnson was on the Changelog a few years back covering his work on litestream, and talks about why he chose to go op
-
💭 DjangoCon Europe 2023 | Use SQLite in production...
Very inspiring talk, TLDR, you probably don't need a database server. sqlite will probably be faster, simpler to mainta
-
💭 benbjohnson/litestream: Streaming replication fo...
litestream is a sick cli tool for steaming replicas of sqlite. It automatically does daily snapshots, and str
-
💭 Why I Built Litestream - Litestream
As applications scale to the edge, to put compute as close to the user as possible, database queries back to the master
-
💭 I'm All-In on Server-Side SQLite · The Fly Blog
SQLite is the next big database trend. with more horizontal scaling, close to user read heavy applications, having your
-
💭 LiteFS Cloud: Distributed SQLite with Managed Ba...
Fly.io's solution to sqlite managed backups.I definitely want to look into this a bit, but moreso the tech under the hoo
-
💭 SQLite FTS5 Extension
sqlite has 3 different tokenizers, porter, ascii, trigram. These can be used with sqlite-utils. bash sqlite-ut
-
💭 sqlite_utils Python library - sqlite-utils
sqlite-utils is primarily a cli tool for sqlite operations such as enabling full text search, and executing searches, bu
-
💭 simonw/datasette-render-markdown: Datasette plug...
datasette really does everything doesn't it!
-
💭 Full-text search - Datasette documentation
Enable full-text search in sqlite using sqlite-utils. bash $ sqlite-utils enable-fts mydatabase.db items name descr
-
💭 sqlite-utils command-line tool - sqlite-utils
I want to like jq, but I think Simon is selling me on sqlite, maybe its just me but this looks readable, hackable, edita
-
💭 sqlite-utils command-line tool - sqlite-utils
insert a json array directly into into sqlite with sqlite-utils. bash echo '{"name": "Cleo", "age": 4}' | sqlite-ut