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.
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 guide to using SQLite and Python's sqlite3 module to efficiently manage and query large datasets from text files.
A technical guide on using SQLite and Python's sqlite3 module to efficiently manage and query large datasets, replacing slow text file processing.
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.
