Tootfinder

SQLite for Everything
https://joecode.com/2026-08-19-sqlite3/
We have so many remarkable tools that we avoid using because something else has a shiner marketing budget. (Though SQLite's type system is pretty mediocre.)

➡️ SQLite
#bookmarks

To clean myself of my writing dry spell, here's a TIL that probably should’ve been a blog post:
TIL: SQLite WAL Mode Can Lock Short-Lived Readers
https://hynek.me/til/sqlite-read-only-wal-locked/

SQLite WAL Mode Can Lock Short-Lived Readers
Locked SQLite database errors aren’t just for writers.

🗄️ #Litestream — streaming replication & disaster recovery for #SQLite
Runs as a background process and continuously replicates database changes to S3 or another file, communicating only through the SQLite API so it never corrupts your DB.

from my link log —
sqldef: idempotent MySQL/PostgreSQL schema management.
https://github.com/k0kubun/sqldef
saved 2019-09-04 https://dotat.at/:/CMJ55.…

GitHub - sqldef/sqldef: Idempotent schema management for MySQL, PostgreSQL, SQLite, and SQL Server
Idempotent schema management for MySQL, PostgreSQL, SQLite, and SQL Server - sqldef/sqldef

There goes my Sunday afternoon
#HomeAssistant #SQLite

🐢 #Atuin is an #opensource shell history tool written in #Rust that replaces your existing shell history with a #SQLite

a new #Jellyfin puzzle: on scanning my shows …
mpp[3766883]: mpp_platform: can not found match soc name: raspberrypi,5-model-b brcm,bcm2712
what is an mpp when you get one home?
related to this, my Movies are barred from scans again, and it was going so well:
[ERR] Failed executing DbCommand ("11"ms) [Parameters=["@__date_1='?' (DbType = DateTime), @__p_0='?' (Size = 3004)"], CommandType='Text', CommandTimeout='30']"
[ERR] An exception occurred while executing an 'ExecuteUpdate' operation for context type '"Jellyfin.Database.Implementations.JellyfinDbContext"'."
""Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 19: 'UNIQUE constraint failed
something sends a null SQL UPDATE, and the scan process aborts 😞
also https://forum.jellyfin.org/t-database-sqlite-error-19 and https://forum.jellyfin.org/t-database-issue-exception-occurred (first suggests it's unrelated to renamed files?)
This pre-release issue reports upgrade creating duplicate users and provides and SQL fix:
https://github.com/jellyfin/jellyfin/issues/14423
which leads to this useful rabbit hole: https://jellywatch.app/blog/jellyfin-database-maintenance-optimization-guide-2026

🐢 #Atuin replaces your shell history with a #SQLite database & records rich context for every command — exit code, duration, working directory, hostname & session.
Hit ctrl-r for a full-screen, fuzzy-searchable history UI.

The knowledge graph is stored in a sqlite database, nothing is updated or deleted, and all entitles and links are all time scoped, so you can ask questions like what gearbox was in my lemons racecar in 2022. It's also designed to be fully cached so it will work when there's no network connection, and sync later. I’m going to build a mobile front end when iOS27 ships. It's very easy to use, take photos with your phone and talk into it and the transcriptions and images are processed into updates.

Trying out #Vikunja as a todo / project manager. It's super easy for #selfhosting with #nixos, and just has some media files and an sqlite database to store and backup.
It provides some nice visua…

🔍 Scans Hermes-relevant files for plaintext secrets, duplicate credentials and insecure file permissions
🔐 Encrypts credentials in a local SQLite-backed vault. The master key is derived at runtime from a passphrase, with a separate local salt file stored beside the database

I want like a pastebin but for static sites.
You point a CLI at a directory and you get random.example.com afterwards.
Should support wildcard certs from LE
Ideally self hosted - and S3 backed so the service can run ephemeraly with just a SQLite index to site maybe
This seems like a thing they should exist yet can’t find it?

📂 Your past agent sessions are stored in local provider history files. ctx indexes them into a #SQLite database on your machine, so current & future agents can find the prior discussion, command, or failed attempt before repeating it

⚡ Incremental replication: watches the SQLite WAL and streams changes in real time to object storage, so your backup is always seconds behind live data.
☁️ Works with Amazon S3 and many S3-compatible backends: MinIO, Backblaze B2, DigitalOcean Spaces, GCS, Azure Blob, Tigris, Supabase, SFTP, WebDAV & more.

A little appalled at how the Jules agent is editing my code. Instead of editing the file, it is writing Python programs to rewrite the file with a silly little state machine. Honestly it sort of makes sense given LLM's limitations, but it's still awful.

for line in lines:
    if line == "    # Connect to SQLite database":
        new_lines.append(line)
    elif line == "    conn = sqlite3.connect(db_path)":
        new_lines.append("    with contextlib.closing(sqlite3.connect(db_path)) as conn:")
        in_with = True
    elif line == "    conn.close()":
        in_with = False
        continue
    elif in_with:
        if line == "":
            new_lines.append("")
        elif line.startswith("    "):
            new_lines.append("    "   line)
        else:
            new_lines.append(line)
    else:
        new_lines.append(line)

📊 Request logging lets you inspect authenticated traffic to monitor and diagnose agent behavior
⚙️ Single #Go binary acting as server and CLI: API on port 14321, proxy on 14322, #SQLite by default, #PostgreSQL

🚀 Programmatic access via REST APIs and the NocoDB SDK. Requests are authorized with JWT or social auth tokens.
🐳 Runs from a single #Docker command with SQLite or #PostgreSQL. An auto-upstall script installs Docker Compose, Redis and Traefik, and sets up plus renews SSL automatically.…

🔐 Provider keys are AES-256-GCM encrypted in #SQLite and decrypted in memory per request — your apps only ever see one unified bearer token.
🔄 The catalog self-updates from a signed feed twice a day, verified against a pinned Ed25519 key, so new models and quota changes land without a git pull.

🚀 Artisan queue-sql:status and queue-sql:cancel monitor and stop batches, with --watch and --json output, plus Horizon tags on every job
📊 Delete/update by PK range are idempotent and retry-safe, insert is not. Laravel 10–13, PHP 8.1 , tested on SQLite, MySQL and Postgres. MIT licensed, v1.4.0
https://github.com/kamranata/queue-sql…

📋 #NocoDB turns any #MySQL, #PostgreSQL or #SQLite database into a collaborative spreadsheet …

📊 Requires #PHP 8.2 and Laravel 12 or 13, works on #MySQL, #PostgreSQL & #SQLite. State liv…