Tootfinder

➡️ SQLite
#bookmarks

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?

🗄️ #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

My :forgejo: #forgejo now takes >20s to load the activity page 🤡
This is on cold starts, subsequent refreshes are fast. I think I have reached the limit storing forgejo's data on a WD4TB USB disk, using an sqlite database and having a *ridiculous* amount of commits due to :gitannex: #gitAnnex

💾 All state lives in one #SQLite file on the gateway host — no cloud required. Telemetry off via CLAWPATROL_TELEMETRY=0 or DO_NOT_TRACK=1.
📜 #MIT licensed — gateway, dashboard & plugins all in one repo.
🌐

🐢 #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.

📂 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

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…

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

⚡ 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)