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
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
CREATE TABLE| www.sqlite.org
ALTER TABLE| www.sqlite.org
Small. Fast. Reliable.| www.sqlite.org
SQLite Foreign Key Support| www.sqlite.org
STRICT Tables| www.sqlite.org
Compile-time Options| www.sqlite.org
Small. Fast. Reliable.| www.sqlite.org