DEV Community

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
HNSW vs IVF-PQ: You Are Paying for Recall in RAM

HNSW vs IVF-PQ: You Are Paying for Recall in RAM

Comments
4 min read
MySQL ALTER TABLE: Which Changes Lock the Table, and How to Make One Fail Instead of Copying

MySQL ALTER TABLE: Which Changes Lock the Table, and How to Make One Fail Instead of Copying

Comments
11 min read
I built a Windows SQL client where an LLM drafts the query and you stay in control

I built a Windows SQL client where an LLM drafts the query and you stay in control

Comments
2 min read
Moving from MySQL to PostgreSQL: Building Flexible Search for the Next Phase of AI

Moving from MySQL to PostgreSQL: Building Flexible Search for the Next Phase of AI

Comments
6 min read
Storing email bodies without building a data swamp

Storing email bodies without building a data swamp

Comments
1 min read
Before You Point AI at Your Oracle Schema

Before You Point AI at Your Oracle Schema

1
Comments
7 min read
Hi, I’m Jose: Lessons from Building PHP Applications and Data Platforms

Hi, I’m Jose: Lessons from Building PHP Applications and Data Platforms

Comments
2 min read
Suppression is a compliance surface, not a checkbox

Suppression is a compliance surface, not a checkbox

Comments
2 min read
Stop Updating Stock Quantities: Build an Inventory Ledger in Laravel

Stop Updating Stock Quantities: Build an Inventory Ledger in Laravel

Comments
7 min read
CREATE UNIQUE INDEX terminated because a duplicate key was found

CREATE UNIQUE INDEX terminated because a duplicate key was found

Comments
4 min read
Managed Postgres with 10 GB: what it really costs on 7 hosts

Managed Postgres with 10 GB: what it really costs on 7 hosts

1
Comments
2 min read
How to Mask Sensitive Data in SQL: Make a Safe Database Copy

How to Mask Sensitive Data in SQL: Make a Safe Database Copy

2
Comments
7 min read
SQL CASE WHEN: How to Categorize Employee Salaries into Low, Medium, and High

SQL CASE WHEN: How to Categorize Employee Salaries into Low, Medium, and High

Comments
2 min read
Goravel models and migrations with Postgres

Goravel models and migrations with Postgres

Comments
7 min read
Connection Strings for MySQL, PostgreSQL and Redis: A Practical Reference

Connection Strings for MySQL, PostgreSQL and Redis: A Practical Reference

Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.