The article details the process of converting a Postgres database to SQLite as part of a cloud migration strategy for a SaaS project.
Exploring Go middleware, request context, and database usage with the standard library, continuing a series on building web apps.
A technical guide on extracting 2FA secrets from the abandoned Authenticator Plus iOS app using SQLCipher and Ruby.
A tutorial on setting up a Next.js application with Prisma ORM and SQLite database, covering initial setup and migrations.
A technical guide on extracting and exporting book highlights from Kobo eReaders by accessing the hidden SQLite database and using Python.
Explores Django 5.0's new GeneratedField feature for database-calculated columns, with a focus on implementation using SQLite.
Explores the necessity of disposing .NET database connections, commands, and readers, examining the internal behavior of Microsoft.Data.Sqlite types.
Benchmarking Go database drivers for SQLite and PostgreSQL on insert-heavy workloads, showing performance differences between popular and alternative drivers.
A guide to creating an XUnit fixture in JetBrains Rider that counts test runs until failure, helping diagnose intermittent unit test issues.
A developer details their journey to diagnose and fix a persistent memory leak in their production Node.js application after a database migration.
The author details their migration from a Postgres cluster to a distributed SQLite setup using LiteFS for their personal website.
Article discusses SQLite's limited built-in functions, compares it to other databases, and introduces a Go-based standard library extension.
A developer details debugging and fixing memory exhaustion bugs in their Golang file-sharing web app, PicoShare, using profiling tools.
A developer shares their experience successfully deploying a personal Elixir/Phoenix project called Galley using Fly.io, including configuration challenges.
A developer shares his one-year journey building open-source data tools without funding, including stats, challenges, and future plans.
A beginner-friendly 2022 introduction to SQL, covering its basics, use cases, and hands-on practice with SQLite3.
Benchmark comparison of SQLite in Go using the cgo-based mattn/go-sqlite3 package versus the pure-Go modernc.org/sqlite translation.
A technical guide on creating and registering custom auxiliary functions for SQLite's FTS5 full-text search extension using C.
A developer details the tech stack and architectural decisions behind the 2021 rewrite of their complex, feature-rich personal website.
A guide to attaching a Core Data SQLite database file to a failing unit test in Xcode for debugging purposes.
