Join me as we take a look at common application data patterns, and how they relate to the inner-workings of databases. In this post, we discuss data caching, indexing, optimistic mutations, and recursive cache invalidation. We will see how life might be easier if we could just use a frontend optimized database like SQLSync instead.| sqlsync.dev
abs(X)| www.sqlite.org
As we saw in the opening post, SQLite stores metadata about tables in a special "schema table" starting on page 1. We've been reading records from this table to list the tables in the current database, but before we can start evaluating SQL queries a...| Geoffrey Copin's Blog
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
Result and Error Codes| www.sqlite.org
SQL Language Expressions| www.sqlite.org
Clustered Indexes and the WITHOUT ROWID Optimization| www.sqlite.org
CREATE TABLE| www.sqlite.org
ALTER TABLE| www.sqlite.org
1. Introduction| www.sqlite.org
Small. Fast. Reliable.| www.sqlite.org
SQLite Foreign Key Support| www.sqlite.org
STRICT Tables| www.sqlite.org
type| www.sqlite.org
SQLite Autoincrement| www.sqlite.org
Compile-time Options| www.sqlite.org
Small. Fast. Reliable.| www.sqlite.org
This document describes and defines the on-disk database file| www.sqlite.org
Datatypes In SQLite| www.sqlite.org
VACUUM| www.sqlite.org
Generated Columns| www.sqlite.org
This document describes and defines the on-disk database file| www.sqlite.org
1. Overview of FTS5| www.sqlite.org
