Valuable SQLite tips for the use on a production servers.

A post on postgres replication feature.

A book on the working of a Query Engine as part of a database.

TIL the SQLite's built-in VACCUM INTO 'db.bak' and .backup db.bak commands.

SQLite journal modes (DELETE and WAL) really clearly explained. Simple and easily to follow procedures on how SQLite achieve ACID.

SQLite replication through a s3-compatible storage. This seems like a good enough solution to many use cases while being a lot simpler.

A short introduction to the idea behind the LSM tree.

The article discusses how transaction is implemented in SQLite using db journals. I also learned how sqlite utilitize pages to map data in files and in memory. Good to dabble in some database internals.

An informative post about how to do Redis clustering. It includes a number of nicely-drawn illustrations.

A neat trick. TIL sqlite3 :memory:. It starts a sqlite3 cli immediately without needing a file.

I just learned that people actually made a software for the idea! Fascinating!

The article enumerates many interesting usages. Including JSON input/output/handling, CTE (with expression), and more.

Very neat tricks on optimizing table and indexes.

<blockquote>The Open Source Alternative to Firebase.</blockquote>

<blockquote>There are multiple types of database systems, such as relational database management system, object databases, graph databases, network databases, and document db. In this article, we discuss the types of Database Management Systems or DBMS.</blockquote>

<blockquote>EuAndreh's website</blockquote>