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.
One database, four dialects: MySQL, MariaDB, SQL Server and PostgreSQL clients on one server

One database, four dialects: MySQL, MariaDB, SQL Server and PostgreSQL clients on one server

Comments
3 min read
Five Fields Every Stored Exchange Rate Needs (or Your Auditor Will Ask)

Five Fields Every Stored Exchange Rate Needs (or Your Auditor Will Ask)

Comments
2 min read
PocketBase for Beginners: A Whole Backend in One Small File

PocketBase for Beginners: A Whole Backend in One Small File

Comments
2 min read
Why Is COUNT(*) So Slow on Large Tables?

Why Is COUNT(*) So Slow on Large Tables?

Comments
4 min read
Django 6.1 Fetch Modes: The N+1 Fix With a Catch

Django 6.1 Fetch Modes: The N+1 Fix With a Catch

Comments
7 min read
How BM25 Ranks Search Results, and What k1 and b Actually Do

How BM25 Ranks Search Results, and What k1 and b Actually Do

Comments
3 min read
Before Upgrading to MySQL 9.7, Check Authentication Plugins and TLS Configuration

Before Upgrading to MySQL 9.7, Check Authentication Plugins and TLS Configuration

Comments
16 min read
Modelado orientado a consultas en Apache Cassandra: series de tiempo con particiones, TTL y contadores en Astra DB

Modelado orientado a consultas en Apache Cassandra: series de tiempo con particiones, TTL y contadores en Astra DB

Comments
6 min read
Cache Repeated Answers to Cut LLM Calls in a Small-Business FAQ Bot (Python + SQLite)

Cache Repeated Answers to Cut LLM Calls in a Small-Business FAQ Bot (Python + SQLite)

Comments
2 min read
Fixing a Concurrency Bug an Architect Caught in My Flink-Qdrant Connector

Fixing a Concurrency Bug an Architect Caught in My Flink-Qdrant Connector

Comments
2 min read
Prisma Migrations When AI Features Touch Your Database

Prisma Migrations When AI Features Touch Your Database

Comments
4 min read
The MongoDB GUI problems I stopped putting up with

The MongoDB GUI problems I stopped putting up with

Comments
8 min read
I built a business-memory AI that watches your shop's database and tells you what's wrong

I built a business-memory AI that watches your shop's database and tells you what's wrong

Comments
2 min read
A JSON column is a schema decision: measuring 50,000 orders in SQLite and D1

A JSON column is a schema decision: measuring 50,000 orders in SQLite and D1

Comments 1
14 min read
What Is a Bounding Box (BBOX) in GIS? A Practical Guide to Faster Geospatial Queries

What Is a Bounding Box (BBOX) in GIS? A Practical Guide to Faster Geospatial Queries

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