Small. Fast. Reliable.| www.sqlite.org
SkyPilot uses the venerable SQLite for state management. SQLite can handle millions of QPS, and terabytes of data. However, our efforts to scale our Managed Jobs feature ran up against the one downfall of SQLite: many concurrent writers. Since SkyPilot typically runs as a CLI on your laptop, we wanted to stick with SQLite, so we decided to figure out how we can make it work. We were very surprised with some of our findings.| SkyPilot Blog
Application-Defined SQL Functions| www.sqlite.org
SQLite claims to be one of the most popular pieces of software in the world, being integrated into every major operating system and browser. It...| tenthousandmeters.com
So I’m a huge SQLite fanboy and I use it for almost everything these days. Recently, the project added sqlite3_rsync which allows you to swiftly replicate your database to other servers (or to the same server if you want), and this really was the cherry on top for me. Last week however, I ran into one of my projects unexpectedly getting SQLITE_BUSY errors. And then someone urged me to run ‘a real database’ (PostgreSQL), and that hurt.| Bert Hubert's writings
I love simplicity. Complexity is our eternal enemy and Simplicity is beautiful; rarely something is as simple as SQLite: a single-file, in-process database. It runs inside our application, there is no need for a separate database server.| binaryigor.com
Small. Fast. Reliable.| www.sqlite.org
Result and Error Codes| www.sqlite.org
CREATE TRIGGER| www.sqlite.org
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.| fractaledmind.github.io
1. Introduction| www.sqlite.org
Small. Fast. Reliable.| www.sqlite.org
Write-Ahead Logging| www.sqlite.org
The SQLite Bytecode Engine| www.sqlite.org
The SQLite OS Interface or "VFS"| www.sqlite.org
SQLite Autoincrement| www.sqlite.org
Compile-time Options| www.sqlite.org
Small. Fast. Reliable.| www.sqlite.org
1. Using the SQLite Online Backup API| www.sqlite.org
This document describes and defines the on-disk database file| www.sqlite.org
1. Overview of FTS5| www.sqlite.org
1. Introduction| www.sqlite.org