Posts tagged with "sqlite"

February 2025

• 🔗 SQLite or PostgreSQL? It's Complicated! 28 Feb 2025
• 🐥 Updating the enum values of a database column definition 23 Feb 2025
• 🔗 SQLite in Vue: Complete Guide to Building Offline-First Web Apps | alexop.dev 16 Feb 2025
• 🐥 Finding the latest version of each record using SQL 14 Feb 2025
• 🔗 Articles - High Performance SQLite 6 Feb 2025

January 2025

• 🔗 SQL NULLs are Weird! 23 Jan 2025
• 🔗 Collection of Insane and Fun Facts About SQLite 10 Jan 2025

December 2024

• 🔗 Safe Ecto Migrations 27 Dec 2024
• 🔗 Optimizing SQLite for servers 17 Dec 2024
• 🔗 Historized Attributes: Systematic Table Design 3 Dec 2024

November 2024

• 🔗 SQL style guide 30 Nov 2024
• 🔗 How to do a preload good using Ecto 23 Nov 2024
• 🔗 Accessing Databases in PhpStorm 21 Nov 2024

September 2024

• 🔗 SQLite is not a toy database 19 Sep 2024

June 2024

• 🔗 Why does SQLite (in production) have such a bad rep? 28 Jun 2024
• 🔗 Litestream - Streaming SQLite Replication 27 Jun 2024
• 🔗 Modern SQLite 25 Jun 2024
• 🐥 Importing CSV files into SQLite 21 Jun 2024

March 2024

• 🔗 goqite - persistent message queue 8 Mar 2024

February 2024

• 🔗 gemini-cli: Access Gemini models from the command-line 23 Feb 2024

October 2023

• 🔗 dsq: Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more 19 Oct 2023
• 🔗 Go database driver overhead on insert-heavy workloads 19 Oct 2023
• 🐥 Loading database query results into a Pandas DataFrame in Python 10 Oct 2023
• 🔗 Things I've learned about building CLI tools in Python 2 Oct 2023

September 2023

• 🔗 Skip the API, Ship Your Database 21 Sep 2023