Posts tagged with "database"

April 2025

• 🐥

  Laravel: casting arrays of enums
  15 Apr 2025
• 🔗

  Life altering PostgreSQL patterns
  5 Apr 2025

March 2025

• 🔗

  How PostgreSQL's Aggregate FILTER Will Spoil You
  13 Mar 2025
• 🔗

  Siren Call of SQLite on the Server
  9 Mar 2025

February 2025

• 🔗

  SQLite or PostgreSQL? It's Complicated!
  28 Feb 2025
• 🔗

  Scalar and binary quantization for pgvector vector search and storage
  25 Feb 2025
• 🔗

  HNSW Indexes with Postgres and pgvector | Crunchy Data Blog
  25 Feb 2025
• 🐥

  Updating the enum values of a database column definition
  23 Feb 2025
• 🔗

  Ecto Datetime With Time Zone
  20 Feb 2025
• 🔗

  Multi tenancy Example for Phoenix
  19 Feb 2025
• 🐥

  Finding the latest version of each record using SQL
  14 Feb 2025
• 🔗

  Don't use NOT IN in PostgreSQL
  9 Feb 2025
• 🔗

  Things You Can Do With Ecto
  7 Feb 2025
• 🔗

  Faster similarity search performance with pgvector indexes
  5 Feb 2025
• 🐥

  Getting the size of all postgres databases on a server
  4 Feb 2025
• 🔗

  TIL Ecto Constraints and Validations
  4 Feb 2025

January 2025

• 🔗

  MySQL can do more than you think
  28 Jan 2025
• 🔗

  Avoiding the soft delete anti-pattern
  27 Jan 2025
• 🐥

  Updating pgvector to the latest version
  24 Jan 2025
• 🔗

  SQL NULLs are Weird!
  23 Jan 2025
• 🔗

  Eliminate Slow Queries with Ecto Telemetry
  22 Jan 2025
• 🔗

  You Don't Need Ecto.Multi
  19 Jan 2025
• 🔗

  Collection of Insane and Fun Facts About SQLite
  10 Jan 2025
• 🔗

  Databases in 2024: A Year in Review
  10 Jan 2025
• 🐥

  Troubleshooting blocked queries in PostgreSQL
  6 Jan 2025