-
💭 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
-
💭 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
-
💭 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
-
💭 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
-
💭 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
-
💭 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!
-
💭 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 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
-
💭 Filter Data - Where - Sqlmodel
When fetching pydantic models from the database with sqlmodel, and you cannot select your item by id, you probably need
-
💭 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( "
-
💭 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
-
Stepping Up My Sql Game
none