-
💭 Proper handling of None in WHERE condition · Iss...
SQLModel models ship with an is, and isnot that you can use to compare to None without pesky linters complaining.
-
💭 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
-
💭 Creating One-To-Many Relationships in Flask-SQLA...
Great example from Anthony showing how easy it is to practice building database orm models and playing with them in a re
-
💭 python - Concepts of backref and back_populate i...
Today I came across some sqlalchemy models that created some relationships, some used backref some used backpopula
-
💭 Read a Range of Data - LIMIT and OFFSET - SQLMod...
Today I was running some sqlmodel queries through the sqlalchemy orm. Admittedly I've not done enough orm queries befor
-
💭 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!
-
💭 python - SQLAlchemy ORDER BY DESCENDING? - Stack...
How to sort results from a sqlalchemy based orm. python .orderby(model.Entry.amount.desc()) I needed this to
-
💭 sqlite-utils now supports plugins
As the title states sqlite-utils now supports plugins. I dug in just a bit and Simon implemented this completely with e
-
💭 Column INSERT/UPDATE Defaults — SQLAlchemy 1.4 D...
sqlalchemy serverdefaults end up as defaults in the database when new values are inserted. python t = Table( "
-
💭 Filter Data - WHERE - SQLModel
When fetching pydantic models from the database with sqlmodel, and you cannot select your item by id, you probably need
-
💭 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