Posts tagged with "sqlite"

September 2026

• 🔗

  SQLite vs DuckDB on the same $16 box: every cliff moved 100X
  5 Sep 2026

August 2026

• 🔗

  Learning a few things about running SQLite
  19 Aug 2026
• 🔗

  Detecting full table scans with SQLite
  16 Aug 2026
• 🔗

  SQLite should have (Rust-style) editions
  15 Aug 2026
• 🔗

  Lobste.rs is now running on SQLite
  9 Aug 2026
• 🔗

  Prefer strict tables in SQLite
  4 Aug 2026

June 2026

• 🔗

  What if the browser was the server?
  6 Jun 2026

May 2026

• 🔗

  SQLite features you didn’t know it had: JSON, text search, CTE, STRICT, generated columns, WAL
  13 May 2026

March 2026

• 🔗

  Use SQL triggers to prevent overwriting a value
  24 Mar 2026

February 2026

• 🔗

  Deep dive into Turso, the "SQLite rewrite in Rust"
  26 Feb 2026

January 2026

• 🔗

  From dev to production for a small Phoenix project
  23 Jan 2026
• 🔗

  How SQLite is tested
  17 Jan 2026
• 🔗

  SQLite as an application file format
  10 Jan 2026
• 🐥

  Sorting case insensitive in SQLite with COLLATE NOCASE
  6 Jan 2026

November 2025

• 🔗

  Tips for efficient data queries in ASP.NET Core
  21 Nov 2025
• 🔗

  Strategic pagination patterns for .NET APIs
  18 Nov 2025

October 2025

• 🔗

  Full text search with Django and SQLite
  30 Oct 2025
• 🔗

  Subtleties of SQLite indexes
  23 Oct 2025

September 2025

• 🐥

  Adding an average column to SQL query results with window functions
  18 Sep 2025

June 2025

• 🔗

  sqlite_vec: A wrapper to use sqlite-vec in Elixir
  28 Jun 2025

March 2025

• 🔗

  Siren Call of SQLite on the Server
  9 Mar 2025

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