Relational (SQL)

Postgres/MySQL/SQLite tuning, HA/DR, indexing, and query planning.

  • 6 Tracked terms
  • Last 30 days Feed window
Search within this topic Ask AI about this topic All topics

What this topic collects on

An article joins this feed when it matches these terms. Each one is also a search of its own.

Latest in Relational (SQL)


medium.com > @kabirbakovic > postgresql-will-let-you-invent-a-type-right-up-until-it-asks-for-a-c-compiler-67593aede3d6

PostgreSQL Will Let You Invent a Type, Right Up Until It Asks for a C Compiler

4+ hour, 10+ min ago   (41+ words) A partner feed lands a million order rows a day, and the order date arrives as 03/15/2021. Someone stores it in a text …...


dev.to > milkyway008 > your-agents-sqlite-state-db-keeps-corrupting-what-actually-causes-it-and-how-to-recover-the-data-55hd

Your agent's SQLite state DB keeps corrupting: what actually causes it, and how to recover the data

10+ hour, 55+ min ago   (974+ words) I run an agent that keeps its entire brain in one local SQLite file. Three weeks ago it came back with database disk image is malformed, and I did the first thing most of us do: deleted the -shm sidecar,…...


dev.to > maayanlevy > why-i-built-a-mysql-plugin-that-understands-natural-language-46c1

Jev was the tipping point - I built the last MySQL search statement

17+ hour, 2+ min ago   (70+ words) The problem that kept finding me was mapping unstructured data into an existing corpus. Supplier... Tagged with showdev, mysql, jev....


hackernoon.com > four-ways-to-seed-a-postgres-database-and-what-each-does-when-the-schema-moves

Four Ways to Seed a Postgres Database, and What Each Does When the Schema Moves | HackerNoon

3+ day, 22+ hour ago   (1095+ words) Add a mandatory column to a table that already holds rows, give it no default, and Postgres declines the migration outright. Failing there is the good outcome, because it lands in the migration rather than in your seed data, with…...


dev.to > franckpachot > learn-postgresql-extensions-through-a-gloriously-bad-idea-mmddyyyy-2pc4

Learn PostgreSQL extensions through a gloriously bad idea: MM/DD/YYYY

4+ day, 8+ hour ago   (1202+ words) This project teaches four of PostgreSQL's most powerful features by building something no sane person... Tagged with postgres, sql, database, extensions....


dev.to > jgwesterfield > why-i-chose-sqlite-over-postgres-fko

Why I Chose SQLite Over Postgres

4+ day, 13+ hour ago   (677+ words) I have been building a little project called Librarian: a local-first assistant for my EPUB collection. The basic idea is that I can point it at a folder of books, have it extract and chunk the text, create embeddings locally,…...


dev.to > rapidlashes > no-idea-where-to-start-learning-sql-4nh6

NO idea where to start learning SQL?

1+ week, 9+ hour ago   (246+ words) This article is a beginner friendly guide that gets you started into learning SQL as a programming... Tagged with programming, productivity, beginners, webdev....


medium.com > @eyeonit > sqldungeon-now-with-duckdb-188633f5f8c5

SQLDungeon: Now with DuckDB

1+ week, 8+ hour ago   (35+ words) SQL Dungeon grew a DuckDB marsh this weekend. Why, well because I wanted to learn it. SQL Dungeon started as a browser dungeon crawler where every room is a SQL puzzle …...


medium.com > @ashrayadhikari > i-replaced-chroma-qdrant-and-pinecone-with-a-sqlite-file-1ae5210c85d4

I Replaced Chroma, Qdrant, and Pinecone With a SQLite File

1+ week, 1+ day ago   (165+ words) I needed a vector DB that didn’t require a daemon. SQLite was already there. Every RAG tutorial starts the same way. Step one: install …...


dev.to > eyochen > a-straightforward-guide-for-mvcc-in-mysql-19ea

A Straightforward Guide for MVCC in MySQL

1+ week, 1+ day ago   (417+ words) In this article, I'll walk through how InnoDB (MySQL's default storage engine) works across different... Tagged with mysql, database, backend, learning....