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.
A guide to setting up isolated Core Data unit tests using a SQLite persistent store for reliable, production-like testing.
How to use SQLite with Litestream for serverless data replication, eliminating database servers and reducing costs to $0.03/month.
A technical guide on managing and cleaning up custom search engines in Google Chrome by directly manipulating its SQLite database.
Learn how Django uses models and migrations to store and manage data in a relational database.
Explains how to programmatically query Alfred's clipboard history, stored as a SQLite database, using SQL commands.
Extending a custom SQL database in Go to implement the database/sql driver interface, enabling standard interaction.
A technical guide on manually migrating Alfred's clipboard history database between Macs using symbolic links and Dropbox.
A tutorial on building a live image feed system using a Raspberry Pi and Python, with a Flask server and SQLite for image storage.
Guide on querying SQLite databases hosted on Azure File shares from multiple containers in AKS for scalable data processing.
GoScan v2 is an interactive network scanner built in Go, automating and abstracting nmap for penetration testing and CTFs.
Explores whether Core Data entities need explicit primary key properties, using SQLite debug insights.
Explores whether Core Data entities need explicit primary keys, using SQLite debug info to show Core Data handles them automatically.
Guide on configuring NSPersistentContainer to use an existing SQLite store in Core Data, with code examples.
Guide on configuring NSPersistentContainer to use an existing SQLite store in Core Data.
An online tool for converting Microsoft Access databases to JSON, MySQL, and SQLite formats, built with Java.
