#sqlite

I'm looking to understand more about the practical, operational limits of running #sqlite in #production environments. If I were to build a web app with sqlite backend, what would make it fall over in terms of database size, connections, lack of certain features, ...? All thoughts, experiences, and pointers to recent write-ups welcome!

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.) #programming #sql #sqlite

If I want to support both SQLite and Postgres, do I have to resort to having two parallel sets of scripts basically? Is there a way, inside a .sql script, to determine which database backend I’m running and branch to at least keep the parts that differ in the same file? #LazyWeb #SQL #SQLite #Postgres

"Your executable is a SQLite database" This is wild and cool. #SQLite as a Linux executable format, and container of a #NixOS system closure. https://fzakaria.com/2026/08/23/your-executable-is-a-sqlite-database

"Reliability Lessons From SQLite - Richard Hipp | SSW 2026" https://youtu.be/V_qzqY1bb7I #sqlite #testing #lessonslearned #ssw2026

Critical CVE issued for hallucinated SQLite vulnerability https://research.jfrog.com/post/sqlite-critical-cves-or-llm-slops/ Comments: https://news.ycombinator.com/item?id=49154332 #HackerNews #CVE #SQLite #vulnerability #security #tech #news #cybersecurity

Database Workbench 7.0.5 released ✅ #AI Assistant improvements ✅ Improved XML data export ✅ Much faster ODS and XLS data import ✅ Improved Welcome Window Read more ➡️ https://www.upscene.com/news/item/20260722 #Firebird #MySQL #MariaDB #Oracle #PostgreSQL #SQLServer #InterBase #SQLite #NexusDB #databasedevelopment #DatabaseWorkbench #AIDevelopment

🎉 Loupe 1.0 is here! Production-proven full-text search for PHP, powered by SQLite - no containers, daemons or external services. Now with compound-word search and better result excerpts! https://github.com/loupe-php/loupe/releases/tag/1.0.0 #php #sqlite #loupe #search

"Using #AI to Update Audit Triggers After Schema Changes" Generating an audit trigger is only the beginning. As a database evolves, tables change, new columns are added, and existing audit triggers need to evolve with them. This is another area where AI can save developers valuable time. https://www.upscene.com/articles/article/8/ai-to-update-triggers-after-database-schema-changes #databasedevelopment #DatabaseWorkbench #sql #AIDevelopment #sqlite #sqlserver #PostgreSQL #FirebirdSQL #mysql #MariaDB #sqlserver #oracle #InterBase

SQLite vs DuckDB https://tracewayapp.com/blog/sqlite-vs-duckdb #duckdb #sqlite

SQLite WAL Mode Can Lock Short-Lived Readers https://hynek.me/til/sqlite-read-only-wal-locked/ #Databases #SQLite #Programming

SQLite Query Explainer https://simonwillison.net/2026/Jul/18/sqlite-query-explainer/#atom-everything #SQLite #Database #DevTools

Learning a few things about running SQLite https://jvns.ca/blog/2026/07/17/learning-about-running-sqlite/ #Databases #SQLite #Tech

Learning a few things about running SQLite https://jvns.ca/blog/2026/07/17/learning-about-running-sqlite/ #HackerNews #Tech #SQLite

Learning a few things about running SQLite https://jvns.ca/blog/2026/07/17/learning-about-running-sqlite/ #SQLite #Databases #Tech

SQLite Is All You Need https://www.dbpro.app/blog/sqlite-is-all-you-need #sqlite

SQLite Is All You Need https://www.dbpro.app/blog/sqlite-is-all-you-need #HackerNews #Tech #SQLite

I wrote a blog post about various annoyances I have with SQLite's defaults, and a suggestion about how it could be fixed: https://mort.coffee/home/sqlite-editions/ TL;DR: SQLite should have a Rust-style edition system which lets us set a whole suite of more sensible defaults with a single 'PRAGMA edition = 2026'. #sqlite #databases #rdbms #embedded

Detecting Full Table Scans With SQLite https://tenderlovemaking.com/2026/07/15/detecting-full-table-scans-with-sqlite/ #SQLite #Databases #Programming

Nul Characters in Strings in SQLite https://sqlite.org/nulinstr.html #HackerNews #Tech #SQLite