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.
The Dark Side Of Using UUID as a Primary Key in MySQL

The Dark Side Of Using UUID as a Primary Key in MySQL

10
Comments
4 min read
Is '__tablename__' Compulsory in SQLAlchemy? Can We Change It?

Is '__tablename__' Compulsory in SQLAlchemy? Can We Change It?

5
Comments
2 min read
The Ugly Truth - Upscaling Your Databases Doesn't Always Help

The Ugly Truth - Upscaling Your Databases Doesn't Always Help

1
Comments
5 min read
PostgreSQL Indexes for Columnstore: 1,185x Faster Lookup Queries, 224x Faster Inserts in TimescaleDB

PostgreSQL Indexes for Columnstore: 1,185x Faster Lookup Queries, 224x Faster Inserts in TimescaleDB

Comments
12 min read
Redis Headless Service vs. Cluster IP Service: Which one should you use?

Redis Headless Service vs. Cluster IP Service: Which one should you use?

1
Comments
4 min read
PSQL COMMAND DAY 2

PSQL COMMAND DAY 2

Comments
1 min read
ServiceNow and GitHub Integration 🔌 for Database Change Automation 🔧⚙️

ServiceNow and GitHub Integration 🔌 for Database Change Automation 🔧⚙️

5
Comments
5 min read
Day 38 - Primary key, Foreign key in Database, Types of SQL Languages

Day 38 - Primary key, Foreign key in Database, Types of SQL Languages

Comments
6 min read
Read-Only Oracle Home: Disabled by Default in Oracle 23ai

Read-Only Oracle Home: Disabled by Default in Oracle 23ai

Comments
2 min read
You Need to Validate Your Databases

You Need to Validate Your Databases

Comments
4 min read
Normalization and Relational Division in SQL and MongoDB

Normalization and Relational Division in SQL and MongoDB

4
Comments
7 min read
Bringing Convex Dashboard into my dev environment

Bringing Convex Dashboard into my dev environment

1
Comments
5 min read
DiceDB Deep Dive: Unpacking the In-Memory Beast That Outmuscles Redis and KeyDB

DiceDB Deep Dive: Unpacking the In-Memory Beast That Outmuscles Redis and KeyDB

Comments
4 min read
MySQL Performance Tuning Techniques

MySQL Performance Tuning Techniques

4
Comments
7 min read
Supercharge Read Performance: 397x Faster Database Queries Through Denormalization

Supercharge Read Performance: 397x Faster Database Queries Through Denormalization

1
Comments 1
2 min read
Beginning our benchmarking journey

Beginning our benchmarking journey

10
Comments
11 min read
SurrealDB 2.2: Benchmarking, graph path algorithms and foreign key constraints

SurrealDB 2.2: Benchmarking, graph path algorithms and foreign key constraints

10
Comments
5 min read
Timescale 2025: Scaling Real-Time Analytics in Postgres

Timescale 2025: Scaling Real-Time Analytics in Postgres

Comments
5 min read
Supabase Alternatives 🔄 in 2025 😼

Supabase Alternatives 🔄 in 2025 😼

10
Comments
4 min read
From Slow Queries to Fast Responses: The Power of Connection Pooling

From Slow Queries to Fast Responses: The Power of Connection Pooling

3
Comments 2
5 min read
Best MySQL NuGet Packages for .NET Development

Best MySQL NuGet Packages for .NET Development

1
Comments
3 min read
Everything about PostgreSQL

Everything about PostgreSQL

7
Comments 6
15 min read
Best Database Clients for Developers and Administrators

Best Database Clients for Developers and Administrators

1
Comments
3 min read
TypeORM Eager - Don't fall for it

TypeORM Eager - Don't fall for it

Comments
2 min read
Calculate Monthly Account Balance and Fill in Missing Dates — From SQL to SPL #10

Calculate Monthly Account Balance and Fill in Missing Dates — From SQL to SPL #10

6
Comments 1
2 min read
loading...