sqlite Archives

PocketBase Tutorial: Build a Real-Time Database and Backend with a Single Executable File

August 19, 2026

PocketBase bundles a SQLite database, REST API, authentication, file storage, and real-time subscriptions into a single executable file. This tutorial walks you through getting it running in minutes, building collections, handling auth, and deploying to production.

Database

Building Fast Serverless Apps with Cloudflare D1: SQL at the Edge

July 30, 2026

Tired of slow database queries in your serverless apps? Cloudflare D1 brings SQL to the edge. Learn how to set up, query, and deploy a global SQLite database in minutes.

Database

Offline-First is a Philosophy, Not a Feature: A 6-Month SQLite Sync Review

June 8, 2026

A deep dive into building resilient offline-first apps. Based on six months in production, we analyze sync strategies, ULID implementation, and conflict resolution using SQLite and PostgreSQL.

Database

Turso and libSQL: Scaling Distributed Databases to the Edge

May 31, 2026

Reduce latency in Edge and Serverless apps by deploying Turso and libSQL. Learn about distributed database architecture, global replication, and native vector search.

Database

SQLite in Production: How Litestream Makes the ‘Unthinkable’ Safe

April 22, 2026

Learn how to run SQLite in production without the fear of data loss. This guide shows you how to use Litestream for real-time S3 replication and instant disaster recovery.

Database

SQLite — The Lightweight Database That Handles More Than You Think

March 16, 2026

SQLite is a file-based, serverless database that comes built into Python and dozens of other platforms. This guide covers when to use SQLite over MySQL or PostgreSQL, its real trade-offs, and how to get started with practical Python examples.