Tootfinder

#sqlite key value in 3 lines of sql

from my link log —
SQLite's durability settings are a mess.
https://www.agwa.name/blog/post/sqlite_durability
saved 2025-08-29 https://

I’ve built quectoCMS, a very small content management system in Python using Flask and SQLite.
It stores pages, blocks, and comments in a single database file and uses plain HTML forms without JavaScript.
Everything fits into a few Python files and templates — easy to read, easy to modify.
Code: https://github.com/mabalew/quectocm…

@… thanks to James, ruby.social now has a :sqlite: sqlite emoji in case you want to put it into your bio or so 😉
Also there's the usual :ruby: and :rails: available

I’ve built quectoCMS, a very small content management system in Python using Flask and SQLite.
It stores pages, blocks, and comments in a single database file and uses plain HTML forms without JavaScript.
Everything fits into a few Python files and templates — easy to read, easy to modify.
Code: https://github.com/mabalew/quectocm…

GitHub - mabalew/quectocms: Ultra small and ultra fast CMS for your personal needs
Ultra small and ultra fast CMS for your personal needs - mabalew/quectocms

from my link log —
Subtleties of SQLite indexes.
https://emschwartz.me/subtleties-of-sqlite-indexes/
saved 2025-09-29 https://

Subtleties of SQLite Indexes
Understanding query planner quirks yielded a ~35% speedup.

What if we treated Postgres like SQLite?
#postgresql

psst! you! do you write Go?
check this out: https://github.com/ncruces/go-sqlite3/blob/aad2224095c5a956d0d46334699c489e37412d7a/ext/seq/push_coro.go

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.

@… please, is this the SQL-related issue?
<https://github.com/freebsd/pkg/issues/2522>
― pkg: sqlite error while executing BEGIN IMMEDIATE TRANSACT…

Geolog-IA: Conversational System for Academic Theses
Micaela Fuel Pozo, Andrea Guatumillo Saltos, Yese\~na Tipan Llumiquinga, Kelly Lascano Aguirre, Marilyn Castillo Jara, Christian Mejia-Escobar
https://arxiv.org/abs/2510.02653

Geolog-IA: Conversational System for Academic Theses
This study presents the development of Geolog-IA, a novel conversational system based on artificial intelligence that responds naturally to questions about geology theses from the Central University of Ecuador. Our proposal uses the Llama 3.1 and Gemini 2.5 language models, which are complemented by a Retrieval Augmented Generation (RAG) architecture and an SQLite database. This strategy allows us to overcome problems such as hallucinations and outdated knowledge. The evaluation of Geolog-IA's …

> Like an unattended turkey deep frying on the patio, truly global distributed consensus promises deliciousness while yielding only immolation.
https://fly.io/blog/corrosion/ 👨‍🍳🤌

Corrosion
Corrosion is distributed service discovery based on Rust, SQLite, and CRDTs.

What if we treated Postgres like SQLite?
#postgresql

Tootfinder has 2572 users, indexes 219485 posts and has 3462551 queries in 3 months which means a query every 2 seconds. But as the creator, after 2 years, I am aware I do not use it often. I am looking for someone to take over the project and to host it. It’s PHP and SQlite, low maintenance.