SQLite in the browser with WASM/JS

sqlite.org

WebAssembly, a.k.a. WASM, is a standard defining a low-level programming language suitable (A) as a target for cross-compilation from many other languages and (B) for running via a virtual machine in a browser. Designed with scriptability via JavaScript in mind, … Read more

SQLite: QEMU All over Again?

glaubercosta-11125.medium.com
sqlite:-qemu-all-over-again?

In a trip down memory lane, I recall my experience with QEMU, and how the project changed completely to accommodate a new industry trend. Is SQLite history rhyming all over again? I first heard of QEMU in the early 2000s. … Read more

SQLite Code of Ethics (2020)

sqlite.org

Code Of Ethics This document was originally called a “Code of Conduct” and was created for the purpose of filling in a box on “supplier registration” forms submitted to the SQLite developers by some clients. However, we subsequently learned that … Read more

SQLite: Past, Present, and Future

muratbuffalo.blogspot.com
sqlite:-past,-present,-and-future

SQLite is the most widely deployed database engine (or likely even software of any type) in existence. It is found in nearly every smartphone (iOS and Android), computer, web browser, television, and automobile. There are likely over one trillion SQLite … Read more

SQLite Doesn’t Use Git

matt-rickard.com

Instead, it uses Fossil as a version control system. Some thoughts. Fossil is also developed by the same primary author as SQLite (D. Richard Hipp). Like SQLite, they share some similar design philosophies (at a very high level): All-in-one product … Read more

How the SQLite Virtual Machine Works

fly.io
how-the-sqlite-virtual-machine-works

Fly.io runs apps close to users around the world, by taking containers and upgrading them to full-fledged virtual machines running on our own hardware around the world. Sometimes those containers run SQLite and we make that easy too. Give us … Read more

SQLite Internals: Pages and B-trees

fly.io
sqlite-internals:-pages-and-b-trees

Fly.io runs apps close to users around the world, by taking containers and upgrading them to full-fledged virtual machines running on our own hardware around the world. Sometimes those containers run SQLite and we make that easy too. Give us … Read more

The SQLite Index Suggester

sqlite.org

Command Line Shell For SQLite The SQLite project provides a simple command-line program named sqlite3 (or sqlite3.exe on Windows) that allows the user to manually enter and execute SQL statements against an SQLite database or against a ZIP archive. This … Read more