#sqlite

jpoesen | 🇪🇺 | 🏳️‍🌈 @jpoesen@social.jpoesen.com

· 1mo ago

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!

1

2

0

Larry Garfield @Crell@phpc.social

· 1mo ago

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

joecode.com

SQLite for Everything | JoeCode

Code with distinct characteristics traceable to its author.

6

4

3

0

0xC0DEC0DE07EA @c0dec0dec0de@hachyderm.io

· 2mo ago

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

2

7

1

0

David Reed @aoristdual@floss.social

· 2mo ago

"Your executable is a SQLite database" This is wild and cool. #SQLite as a Linux executable format, and container of a #NixOS system closure.

fzakaria.com

Your executable is a SQLite database

I have been probably obsessed with two things in the last few years: Nix as a tool to explore innovative ideas that require the capability to rebuild the world and replacing ELF with SQLite as an executable format. You might have noticed that these two ideas are well suited to each other.

44

12

30

2

graste @graste@social.vivaldi.net

· 3mo ago

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

Reliability Lessons From SQLite - Richard Hipp | SSW 2026

3

0

Hacker News @h4ckernews@mastodon.social

· 3mo ago

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

research.jfrog.com

SQLite Critical CVEs or LLM Slop? - JFrog Security Research

The JFrog security research team recently identified a supply chain attack targeting the `xinference` package on PyPI. Versions 2.6.0, 2.6.1, and 2.6.2 were compromised and yanked by maintainers after users reported suspicious behavior. If you installed or imported these versions, you must assume your environment is compromised.

1

0

2

0

Upscene Productions @upscene@mstdn.business

· 3mo ago

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

upscene.com

Database Workbench 7.0.5 released @ Upscene Productions

Upscene: database tools for Oracle, PostgreSQL, InterBase, Firebird, SQL Server, MySQL, MariaDB, NexusDB, SQLite. Home of Database Workbench, Advanced Data Generator and Hopper.

0

Yanick Witschi @toflar@phpc.social

· 3mo ago

🎉 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

github.com

Release Loupe 1.0 🎉🎉🎉 · loupe-php/loupe

Today, I am very excited to announce Loupe 1.0! 🎉 This is more than a version number. It is an acknowledgement of what Loupe has become. Loupe started more than three years ago with a deliberately ...

4

0

Upscene Productions @upscene@mstdn.business

· 3mo ago

"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

upscene.com

Using AI to Update Audit Triggers After Schema Changes @ Upscene Productions

Upscene: database tools for Oracle, PostgreSQL, InterBase, Firebird, SQL Server, MySQL, MariaDB, NexusDB, SQLite. Home of Database Workbench, Advanced Data Generator and Hopper.

0

1

0

Thomas @thbley@phpc.social

· 3mo ago

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

tracewayapp.com

SQLite vs DuckDB on the same $16 box: every cliff moved 100x · Traceway

Same $16.49/month server, same Traceway binary, two embedded databases. DuckDB writes 4x to 15x faster than SQLite, serves dashboards at 100x the row count, and stores a billion metric points in 10.8 GB. Full numbers and methodology inside.

0

Lobsters @lobsters@robot.villas

· 3mo ago

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

hynek.me

SQLite WAL Mode Can Lock Short-Lived Readers

Locked SQLite database errors aren’t just for writers.

0

Simon Willison @simon_willison@robot.villas

· 3mo ago

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

simonwillison.net

Tool: SQLite Query Explainer

View Mozilla Bugzilla bug reports and run SQL queries against a SQLite database to see exactly how SQLite executes them. The tool annotates every line of `EXPLAIN QUERY PLAN` and …

0

Lobsters @lobsters@robot.villas

· 3mo ago

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

jvns.ca

Learning a few things about running SQLite

0

Hacker News @hackernews@robot.villas

· 3mo ago

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

jvns.ca

Learning a few things about running SQLite

0

Julia Evans @julia_evans@robot.villas

· 3mo ago

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

jvns.ca

Learning a few things about running SQLite

0

Curated Hacker News @CuratedHackerNews@mastodon.social

· 3mo ago

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

dbpro.app

SQLite Is All You Need - DB Pro Blog

We built a social network on SQLite, put it behind a Node API, and hit it until something broke. One file, one process, 315 million requests a day on the heaviest endpoint. Here are the numbers, the config, and the honest limits.

49

1

35

0

Hacker News @hackernews@robot.villas

· 3mo ago

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

dbpro.app

SQLite Is All You Need - DB Pro Blog

We built a social network on SQLite, put it behind a Node API, and hit it until something broke. One file, one process, 315 million requests a day on the heaviest endpoint. Here are the numbers, the config, and the honest limits.

0

mort @mort@floss.social

· 3mo ago

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

mort.coffee

SQLite should have (Rust-style) editions - Mort's Ramblings

11

3

9

1

Lobsters @lobsters@robot.villas

· 3mo ago

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

tenderlovemaking.com

Detecting Full Table Scans With SQLite

I’m at RubyConf this week, and it’s great! I recently read that lobste.rs is now running on SQLite. One part from the post caught my attention: I wish we could say in a test, “Fail if you encounter any full table scans”. Which would have caught the perf issues we experienced during the first deploy. SQLite collects information about prepared statements and exposes those statistics though an API. The upshot of this is that we can tell whether a statement did a full table scan after executing the

0

Hacker News @hackernews@robot.villas

· 3mo ago

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

sqlite.org

NUL Characters In Strings

0