SQLite Query Baselines for a Flask Blog: SQLAlchemy Logs, EXPLAIN, and Indexes That Matter
A practical checklist for measuring SQLite query paths in a Flask blog, validating plans with EXPLAIN, and adding only the indexes that protect public pages.
Tags: SQLite
Migrating a Flask Blog from SQLite to MySQL: A Low-Risk Production Checklist
A practical, low-risk path for moving a Flask blog from SQLite to MySQL with backups, schema creation, data import, cutover, and rollback.
Hardening Flask Blog Admin Access: Split Roles, View Decorators, and an Nginx Safety Net
A practical access-control blueprint for a Flask blog: separate admin and author responsibilities, enforce permissions with decorators and query filters, and put Nginx in front as a second line of defense.
Reliable SQLite Backups for Blogs: Copying, Verification, and Restore Drills
SQLite is fine for small blogs, but backups must include the database, uploads, configuration, verification checks, and regular restore drills.