Tootfinder

Opt-in global Mastodon full text search. Join the index!

@fanf@mendeddrum.org
2026-02-11 21:42:03

from my link log —
cysqlite: a new SQLite driver for Python.
charlesleifer.com/blog/cysqlit
saved 2026-02-11

@dawid@social.craftknight.com
2026-02-15 22:55:00
@… Selfhostuje to od lat - https://github.com/dani-garcia/vaultwarden

Zwykły kontener z bazą sqlite. Działa wszystko z bitwardenem, tylko zużywa astronomicznie mniej zasobów.
@kubikpixel@chaos.social
2026-02-12 11:05:02

«Stoolap - High-performance embedded SQL database in Rust»
Have any of you tried it before and what is your experience with it? Can it be used in the same way as SQLite? I ask because the open source project is relatively new, i.e. are there certain arguments to (not) use it productively?
🦀 stoolap.io…

Stoolap - High-performance embedded SQL database in Rust
High-performance embedded SQL database written in pure Rust

@thoralf@soc.umrath.net
2026-02-12 07:31:49

Ich habe gestern Abend den #Homeassistant doch wieder auf PostgreSQL als recorder-Backend umgestellt, weil die SQLite-Datei geradezu explodiert ist (23 GB nach anderthalb Monaten) und das System immer langsamer wurde.
Außerdem habe ich ltss hinzugefügt, damit die reguläre PostgreSQL-Datenbank schnell und einigermaßen klein bleibt.

@michabbb@social.vivaldi.net
2026-01-13 00:45:00

⚙️ Automatic model selection: haiku for trivial, sonnet for standard, opus for critical planning
🐳 Flexible isolation: #Docker containers, #git worktrees, or direct execution
💾 Built-in crash recovery via #SQLite

@nobodyinperson@fosstodon.org
2026-02-07 13:55:47

If you have an #sqlite-backed #paperless consume your email attachments, you'll frequently run into "database locked" errors. It'll retry next time, so you'll get there eventually, but still annoying. Might need to migrate to a

@fanf@mendeddrum.org
2026-01-29 21:42:02

from my link log —
Hosting SQLite databases on Github Pages (or any static file hoster).
phiresky.github.io/blog/2021/h
saved 2021-05-02

Hosting SQLite databases on Github Pages - (or IPFS or any static file hoster) - phiresky's blog
I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. But if you want to use a

@whitequark@mastodon.social
2025-12-06 00:18:48

psst! you! do you write Go?
check this out: github.com/ncruces/go-sqlite3/

go-sqlite3/ext/seq/push_coro.go at aad2224095c5a956d0d46334699c489e37412d7a · ncruces/go-sqlite3
Go bindings to SQLite using wazero. Contribute to ncruces/go-sqlite3 development by creating an account on GitHub.

@michabbb@social.vivaldi.net
2026-02-08 15:43:24

📊 EXPLAIN-based index analysis detects full table scans, missing indexes, filesort & temporary tables on #MySQL, #MariaDB & #SQLite
🔄 Duplicate query detection finds identical queries…

@mot@chaos.social
2026-01-07 13:09:00

Von allen Notiz-Apps, die ich bisher gesehen und teilw. getestet habe, hat es mir Trilium am meisten angetan:
- komplett Open Source
- verschlüsselte Notizen
- kann selbst gehostete Synchronisierung
- viele Features (Zeichnungen, Diagramme, Karten, Reveal.js Präsentationen, Publishing, usw.)
- SQLite unter der Haube
Leider ist es eine Web-App – nativ wäre mir am liebsten. Es gibt auch KI-Kram, aber der ist per default aus, kann Ollama und wird nicht aggressiv …

Trilium Notes
Trilium is an open-source solution for note-taking and personal knowledge bases. Use it locally or sync with your own server to access notes anywhere.

@lil5@social.linux.pizza
2025-11-18 22:30:31

#sqlite key value in 3 lines of sql

-- Run at startup CREATE TABLE IF NOT EXISTS kv (key TEXT UNIQUE, value TEXT); -- Create or set INSERT INTO kv(key, value) VALUES (?, ?) ON CONFLICT(key) DO UPDATE SET value=?; -- Get SELECT value FROM kv WHERE key = ? LIMIT 1
@philip@mastodon.mallegolhansen.com
2026-01-27 18:39:07

@… SQLite called. They want their idea back 😅