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)


dev.to > webmatrixlab > database-indexing-mistakes-that-are-quietly-killing-your-apps-performance-2l74

Database Indexing Mistakes That Are Quietly Killing Your App's Performance

23+ hour, 34+ min ago   (459+ words) Indexing is one of those topics every developer has heard of, most have used, and surprisingly few have actually reasoned through carefully. It's easy to add an index and move on — it's much harder to know whether that index is…...


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

NO idea where to start learning SQL?

1+ day, 2+ 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+ day, 2+ 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 …...


dev.to > mehradsadeghi > mysql-overselling-why-select-isnt-enough-and-how-select-for-update-solves-it-m0p

MySQL Overselling: Why SELECT Isn't Enough and How SELECT... FOR UPDATE Solves It

1+ day, 7+ hour ago   (431+ words) Imagine you’re running an online store, there’s exactly one item left in stock. Two customers click... Tagged with database, mysql, backend, softwareengineering....


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+ day, 18+ hour 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

2+ day, 13+ hour 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....


dev.to > sandman_sh > i-replaced-sqlites-c-driver-with-800-lines-of-pure-python-stdlib-what-the-docs-dont-tell-you-1a9a

I Replaced SQLite's C Driver with 800 Lines of Pure Python Stdlib: What the Docs Don't Tell You About Raw B-Trees, 9-Byte Varints, and 48-Bit Integers

4+ day, 3+ hour ago   (1380+ words) The rules were brutal: Zero third-party runtime dependencies. No pip. No C-extensions. No... Tagged with python, sql....


dev.to > franckpachot > postgresql-mvcc-why-bloat-doesnt-automatically-mean-expensive-reads-2pn7

PostgreSQL MVCC: Why Bloat Doesn't Automatically Mean Expensive Reads

4+ day, 4+ hour ago   (1407+ words) One of the most persistent misconceptions about PostgreSQL MVCC is that old row versions accumulate... Tagged with postgres, sql, database, mvcc....


blogs.oracle.com > mysql > introducing-mysql-workbench-26

Introducing MySQL Workbench 26

4+ day, 11+ hour ago   (738+ words) The MySQL team at Oracle is excited to announce MySQL Workbench 26.7, the first of a new generation of the GUI administration and development tool for MySQL. MySQL Workbench 8 has served the community well, but it’s now old and has reached…...


dev.to > alexgeorgiev17 > sqlite-353s-self-healing-index-only-repairs-the-rows-you-write-to-ni

SQLite 3.53's self-healing index only repairs the rows you write to

4+ day, 12+ hour ago   (894+ words) I asked a database for the row where a computed bucket equalled 500. It gave me row 309. The correct row, using the same formula, was 308. No error, no warning, just a wrong answer served from an index that no longer matched…...