#sqlite

SQLite for Everything | JoeCode

Code with distinct characteristics traceable to its author.

Farid Zakaria’s Blog

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.

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.

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.

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

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.

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.

SQLite WAL Mode Can Lock Short-Lived Readers

Locked SQLite database errors aren’t just for writers.

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 …

Learning a few things about running SQLite

Learning a few things about running SQLite

Learning a few things about running SQLite

Learning a few things about running SQLite

Learning a few things about running SQLite

Learning a few things about running SQLite

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.

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.

mort.coffee

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

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

NUL Characters In Strings