March 2025
February 2025
-
🔗SQLite or PostgreSQL? It's Complicated!
-
🐥Updating the enum values of a database column definition
-
🔗SQLite in Vue: Complete Guide to Building Offline-First Web Apps | alexop.dev
-
🐥Finding the latest version of each record using SQL
-
🔗Articles - High Performance SQLite
January 2025
December 2024
-
🔗Safe Ecto Migrations
-
🔗Optimizing SQLite for servers
-
🔗Historized Attributes: Systematic Table Design
November 2024
-
🔗SQL style guide
-
🔗How to do a preload good using Ecto
-
🔗Accessing Databases in PhpStorm
September 2024
June 2024
-
🔗Why does SQLite (in production) have such a bad rep?
-
🔗Litestream - Streaming SQLite Replication
-
🔗Modern SQLite
-
🐥Importing CSV files into SQLite
March 2024
February 2024
October 2023
-
🔗dsq: Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more
-
🔗Go database driver overhead on insert-heavy workloads
-
🐥Loading database query results into a Pandas DataFrame in Python
-
🔗Things I've learned about building CLI tools in Python