Posted inPython
A Guide to DiskCache in Python: Safe Multi-Process Disk Caching Without Redis
Boost Python performance on low-RAM servers with DiskCache: safe, high-speed multi-process disk caching without installing or managing Redis.
Posted inDevelopment
How to Back Up SQLite to S3 with Litestream: Real-Time Production Backups
Litestream's Continuous WAL Replication makes SQLite production-ready with real-time backups to S3 and second-accurate Point-in-Time Recovery.
Posted inPython
DuckDB with Python Guide: Query Multi-Gigabyte CSV/Parquet Files at Lightning Speed Without OOM Errors
Need to process multi-gigabyte CSV or Parquet files on low-spec hardware? Learn how to use DuckDB in Python for blazing-fast analytics without memory crashes.
Posted inDatabase
Securing SQLite Data with SQLCipher: A Comprehensive Encryption Guide for Desktop and Mobile
A comparison of 3 local database security approaches and a comprehensive guide to SQLite encryption using SQLCipher (AES-256), with Python code, key storage tips, and WAL optimization.
Posted inDatabase
Bringing SQLite to Production: Optimizing WAL Mode and Synchronous for Real-World Loads
SQLite is far from weak if you know how to configure it. Learn how to optimize WAL Mode, Synchronous, and Cache to handle thousands of transactions per second in production environments.
Posted inLinux
Atuin: A Lifesaver for Terminal History with SQLite and Fuzzy Search
Replace your clunky history manager with Atuin. Leverage the power of SQLite for ultra-fast command searching, E2EE synchronization, and smart command filtering.
Posted inDevelopment
PocketBase: Build an “All-in-one” Backend at Lightning Speed with a Single File
PocketBase is a powerful open-source Backend-as-a-Service solution that integrates Database, Auth, and File Storage into a single executable. It's the perfect tool for building MVPs and small projects at lightning speed.
Posted inDevelopment
Building a Full-Stack App with Nuxt 3: Server Routes, Nitro Engine, and Drizzle ORM
A hands-on guide to building a full-stack application with Nuxt 3, Nitro Engine, and Drizzle ORM — setting up API routes, a type-safe database, and connecting the frontend in a single project. Lessons learned after 6 months in production.
Posted inDatabase
SQLite in Production: Effortless Real-time Backup with Litestream
Stop worrying about data loss with SQLite. Learn how to use Litestream to automatically back up your database to Cloudflare R2/S3 in real time, giving your production application rock-solid data protection.
Posted inDatabase
Guide to Using SQLite with Python: Lightweight Database for Automation Scripts and Small Applications
When you need a lightweight, no-fuss database for Python scripts or small applications, SQLite is an indispensable choice. This article guides you from A-Z on using SQLite with Python, covering basic operations to advanced techniques, helping you deploy quickly and without headaches.