-
💠Using Litestream to Restore My Database for Easy...
Here's my thought on 💠Using Litestream to Restore My Database for Easy Development I really like how well the local dev is setup to run off of production…
-
💠Meet Gor on X: "SQLite added generated columns i...
Here's my thought on 💠Meet Gor on X: "SQLite added generated columns in 3.31 (around... I've never tried generated columns, but it is something that I'm…
-
💠Database Remote-Copy Tool For SQLite (draft)
Here's my thought on 💠Database Remote-Copy Tool For SQLite (draft) Simon shared a really cool new utility tool for sqlite ispired by rsync. It checks…
-
💠Sqlite-jiff
Here's my thought on 💠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...
Here's my thought on 💠sql - How can I list the tables in a SQLite database file that... I learned about the sqlite_master table from this stack overflow…
-
💠sql - SQLite: COUNT slow on big tables - Stack O...
Here's my thought on 💠sql - SQLite: COUNT slow on big tables - Stack Overflow Another interesting option for slow count queries in sqlite. If you haven't…
-
💠Optimizing SQLite for servers
Here's my thought on 💠Optimizing SQLite for servers Very interesting article by Sylvain, suggested by Simon Willison. Definitely some things that I want to…
-
💠searching my thoughts locally
Here's my thought on 💠searching my thoughts locally First I need to fetch my thoughts from the api, and put it in a local sqlite database using . Now that…
-
💠Open source, not open contribution with Ben John...
Here's my thought on 💠Open source, not open contribution with Ben Johnson (Changelog... Ben Johnson was on the Changelog a few years back covering his work…
-
💠DjangoCon Europe 2023 | Use SQLite in production...
Here's my thought on 💠DjangoCon Europe 2023 | Use SQLite in production - YouTube Very inspiring talk, TLDR, you probably don't need a database server.…
-
💠benbjohnson/litestream: Streaming replication fo...
Here's my thought on 💠benbjohnson/litestream: Streaming replication for SQLite. install Install is fast using installer, no compilation, just copy the…
-
💠Why I Built Litestream - Litestream
Here's my thought on 💠Why I Built Litestream - Litestream As applications scale to the edge, to put compute as close to the user as possible, database…
-
💠I'm All-In on Server-Side SQLite · The Fly Blog
Here's my thought on 💠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…
-
💠LiteFS Cloud: Distributed SQLite with Managed Ba...
Here's my thought on 💠LiteFS Cloud: Distributed SQLite with Managed Backups · The Fl... Fly.io's solution to sqlite managed backups.I definitely want to…
-
💠SQLite FTS5 Extension
Here's my thought on 💠SQLite FTS5 Extension sqlite has 3 different tokenizers, . These can be used with sqlite-utils. And with the python api. !!! note…
-
💠sqlite_utils Python library - sqlite-utils
Here's my thought on 💠sqlite_utils Python library - sqlite-utils sqlite-utils is primarily a cli tool for sqlite operations such as enabling full text…
-
💠simonw/datasette-render-markdown: Datasette plug...
Here's my thought on 💠simonw/datasette-render-markdown: Datasette plugin for renderi... datasette really does everything doesn't it! !!! note This post is…
-
💠Full-text search - Datasette documentation
Here's my thought on 💠Full-text search - Datasette documentation Enable full-text search in sqlite using sqlite-utils. !!! note This post is a thought .…
-
💠sqlite-utils command-line tool - sqlite-utils
Here's my thought on 💠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…
-
💠sqlite-utils command-line tool - sqlite-utils
Here's my thought on 💠sqlite-utils command-line tool - sqlite-utils insert a json array directly into into sqlite with sqlite-utils. !!! note This post is…