-
💭 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
-
💭 Optimizing Sqlite For Servers
Very interesting article by Sylvain, suggested by Simon Willison. Definitely some things that I want to come back and t
-
💭 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
-
💭 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
-
💭 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
-
💭 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
-
💭 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
-
💭 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!
-
💭 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
-
💭 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
-
💭 Full-Text Search - Datasette Documentation
Enable full-text search in sqlite using sqlite-utils. bash $ sqlite-utils enable-fts mydatabase.db items name descr