Tootfinder

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

«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?
🦀 https://stoolap.io…

Eight years of wanting, three months of building with #AI
https://lalitm.com/post/building-syntaqlite-ai/

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.

🌙 Dreamer agent runs overnight: consolidates & verifies memories against the real codebase, archives outdated facts & improves stored knowledge. Works fine with local slow models too.
📦 #TypeScript, #SQLite for local storage,

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

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

For all the praises for AI for programming:
```
Q: When to use CLOB data type in SQLite?
Claude: […] XML or JSON documents (though SQLite has a dedicated JSON type now) […]
Q: Give me the link to the SQLIte JSON type
Claude: You're right to push back on that — I misspoke. SQLite does not have a JSON data type. JSON data in SQLite is stored as plain TEXT.
```
I do understand companies do not care.
I fail to see how developers would NOT care.

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

Вопрос к гуру #Python и #SQLite: что вы передаете в функции, Cursor или Connection? Какие плюсы и минусы, или нет никакой разницы?
Если нужно коммитить, то насколько странно делать это через cur.connection.commit()?

Moim głównym projektem na teraz jest ecommerce serwer - ma być zamiennikiem wordpress woocommerce tylko w "minimalnym" podejściu.

Rust, frontstore na SSR z szablonami w liquid, pluginy w WASM, baza sqlite, mały admin panel na htmx z prostym loginem po session token. Wszystko w jednej binarce. Setup - ściągnij tę binarkę i uruchom.

Jest to bardzo ciekawe wyzwanie - jak wymaksować wykorzystanie zasobów, wycisnąć ile się da z sqlite wal, cachowaniem czego się da, aby każdy …

Are there any downsides to SQLite for small personal coding projects?

@… SQLite called. They want their idea back 😅

I think this is a good pressure test of #LLM / #AI agentic coding, and depending on where you are, it's either an indictment or a great success story:
if you have $3k, one of the best test suites in existence and a week of time, you can swap a storage implementation in a database

A little work done on my web browser. I'm working on bookmarks, and instead of storing them in a text file like I originally planned I'm going to try out storing them in an sqlite database. Some of that infrastructure is in place. Bookmarks are going to be tag based rather than in folders, so you can tag a bookmark with multiple categories and it will show up in all of them. I think that's a better way of organizing them than the traditional folder view.
Downloads are worki…

@… 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.

📊 Built on #Prometheus metrics, #AlertManager notifications & #OpenTelemetry tracing for complete observability
🗄️ Uses