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.
GoScan v2 is an interactive network scanner built in Go, automating and abstracting nmap for penetration testing and CTFs.
An online tool for converting Microsoft Access databases to JSON, MySQL, and SQLite formats, built with Java.
A tutorial on implementing audit trails in Entity Framework Core using shadow properties, without modifying domain entities.
A step-by-step tutorial on creating a .NET Core console application using Entity Framework Core with SQLite.
Explains how to correctly store and retrieve UTC dates in SQLite using the ADO.NET provider by setting DateTimeKind=Utc in the connection string.
A blogger clarifies that Skype's unencrypted local database is not a security vulnerability, as it's protected by system-level access controls.
A security analysis revealing that Skype stores user data in an unencrypted, password-less local database, making it vulnerable to data extraction.
A technical guide on using SQLite and Python's sqlite3 module to efficiently manage and query large datasets, replacing slow text file processing.
A guide to using SQLite and Python's sqlite3 module to efficiently manage and query large datasets from text files.
A tutorial on building an offline-capable ASP.NET MVC notebook application using Google Gears for local data storage and synchronization.
Guide to manually installing the missing php5-pdo-sqlite package on Ubuntu Dapper via compilation and configuration.
