-
💠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…
-
💠Proper handling of None in WHERE condition · Iss...
Here's my thought on 💠Proper handling of None in WHERE condition · Issue #109 · fast... SQLModel models ship with an , and that you can use to compare to…
-
💠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…
-
💠Creating One-To-Many Relationships in Flask-SQLA...
Here's my thought on 💠Creating One-To-Many Relationships in Flask-SQLAlchemy - YouTube Great example from Anthony showing how easy it is to practice…
-
💠python - Concepts of backref and back_populate i...
Here's my thought on 💠python - Concepts of backref and back_populate in SQLalchemy? ... Today I came across some sqlalchemy models that created some…
-
💠Read a Range of Data - LIMIT and OFFSET - SQLMod...
Here's my thought on 💠Read a Range of Data - LIMIT and OFFSET - SQLModel Today I was running some sqlmodel queries through the sqlalchemy orm. Admittedly…
-
💠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…
-
💠python - SQLAlchemy ORDER BY DESCENDING? - Stack...
Here's my thought on 💠python - SQLAlchemy ORDER BY DESCENDING? - Stack Overflow How to sort results from a sqlalchemy based orm. I needed this to enable…
-
💠sqlite-utils now supports plugins
Here's my thought on 💠sqlite-utils now supports plugins As the title states sqlite-utils now supports plugins. I dug in just a bit and Simon implemented…
-
💠Column INSERT/UPDATE Defaults — SQLAlchemy 1.4 D...
Here's my thought on 💠Column INSERT/UPDATE Defaults — SQLAlchemy 1.4 Documentation sqlalchemy server_defaults end up as defaults in the database when new…
-
💠Filter Data - WHERE - SQLModel
Here's my thought on 💠Filter Data - WHERE - SQLModel When fetching pydantic models from the database with sqlmodel, and you cannot select your item by id,…
-
💠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…