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.
Oracle AI Database 26ai — Automatic SQL Transpiler Feature

Oracle AI Database 26ai — Automatic SQL Transpiler Feature

Comments
1 min read
The Mechanics of SELECT FOR UPDATE in SQL

The Mechanics of SELECT FOR UPDATE in SQL

6
Comments
4 min read
Solving the OLTP-OLAP Divide: PostgreSQL B-tree and Hash Indexes for Columnar Data

Solving the OLTP-OLAP Divide: PostgreSQL B-tree and Hash Indexes for Columnar Data

Comments
9 min read
Bytebase vs. StrongDM: a side-by-side comparison ⛓️ for Just-in-time (JIT) ⏳🛢️ database access control

Bytebase vs. StrongDM: a side-by-side comparison ⛓️ for Just-in-time (JIT) ⏳🛢️ database access control

5
Comments
4 min read
What Makes Data AI-Ready?

What Makes Data AI-Ready?

11
Comments
1 min read
Find your celebrity soulmate with the magic of vector search

Find your celebrity soulmate with the magic of vector search

10
Comments
8 min read
14 Rules for Designing MySQL Tables

14 Rules for Designing MySQL Tables

8
Comments
7 min read
Designing Time-Series Data In DynamoDB

Designing Time-Series Data In DynamoDB

1
Comments
3 min read
The effect of frequent values on histogram_bounds in PostgreSQL

The effect of frequent values on histogram_bounds in PostgreSQL

Comments 1
4 min read
Smooth Database Migrations in a Fast-Moving World

Smooth Database Migrations in a Fast-Moving World

12
Comments
4 min read
🚀 Introducing PSQLab – Your In-Browser PostgreSQL Playground

🚀 Introducing PSQLab – Your In-Browser PostgreSQL Playground

8
Comments
3 min read
Mastering Redis : The In-Memory Data Structure Store You Need to Know 🚀

Mastering Redis : The In-Memory Data Structure Store You Need to Know 🚀

4
Comments 2
9 min read
SQL Composite Indexes: When to Use?

SQL Composite Indexes: When to Use?

5
Comments
3 min read
Stop Using Your Database as a Message Queue: Why It's a Bad Idea

Stop Using Your Database as a Message Queue: Why It's a Bad Idea

Comments
5 min read
The World Is Too Messy for SQL to Work

The World Is Too Messy for SQL to Work

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