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.
Indexing, Hashing & Query Optimization in SQL

Indexing, Hashing & Query Optimization in SQL

Comments
4 min read
mongoDB CRUD OPERATION IN SQL

mongoDB CRUD OPERATION IN SQL

Comments
2 min read
HASHING IN SQL

HASHING IN SQL

Comments
2 min read
MongoDB Pagination: IXSCAN vs COLLSCAN and Building Efficient Page Bookmarks

MongoDB Pagination: IXSCAN vs COLLSCAN and Building Efficient Page Bookmarks

Comments 1
4 min read
Cursors and Triggers

Cursors and Triggers

Comments
3 min read
💾Database Reliability Explained: Transactions, Deadlocks & Log-Based Recovery

💾Database Reliability Explained: Transactions, Deadlocks & Log-Based Recovery

Comments
3 min read
PostgreSQL 18 Uncovered: Asynchronous I/O, UUIDv7, and Pain-Free Upgrades

PostgreSQL 18 Uncovered: Asynchronous I/O, UUIDv7, and Pain-Free Upgrades

Comments
10 min read
Understanding 1NF, 2NF, and 3NF in DBMS with SQL Examples

Understanding 1NF, 2NF, and 3NF in DBMS with SQL Examples

Comments
2 min read
Algo entre o VARCHAR2 e o CLOB: VARCHAR2 com esteróides [MAX_STRING_SIZE]

Algo entre o VARCHAR2 e o CLOB: VARCHAR2 com esteróides [MAX_STRING_SIZE]

1
Comments
2 min read
NestJS Expert Series (Part 2): Database Integration with Prisma & TypeORM

NestJS Expert Series (Part 2): Database Integration with Prisma & TypeORM

1
Comments
2 min read
What if we improve the way developers are given access to databases

What if we improve the way developers are given access to databases

Comments
4 min read
AWS Use Cases | Why Focus on Access Patterns (Reads) Instead of Writes in DynamoDB Modelling

AWS Use Cases | Why Focus on Access Patterns (Reads) Instead of Writes in DynamoDB Modelling

1
Comments
7 min read
What is Laravel Eloquent ORM?

What is Laravel Eloquent ORM?

Comments 1
4 min read
PostgreSQL WAL: The Backbone of Reliable and Scalable Databases

PostgreSQL WAL: The Backbone of Reliable and Scalable Databases

1
Comments
3 min read
# 🚀 Redis Memory Eviction: Deep Dive into the Algorithm Behind Redis Performance

# 🚀 Redis Memory Eviction: Deep Dive into the Algorithm Behind Redis Performance

Comments
5 min read
##System Design Explained: Insights and Examples for Beginners

##System Design Explained: Insights and Examples for Beginners

Comments
3 min read
Database : DBMS + Postgres — catatan dasar

Database : DBMS + Postgres — catatan dasar

Comments
7 min read
Cursor and Trigger

Cursor and Trigger

Comments 1
2 min read
Covering index for $group/$sum in MongoDB aggregation (with hint)

Covering index for $group/$sum in MongoDB aggregation (with hint)

Comments 1
6 min read
Accelerate Distributed Joins with Predicate Transfer

Accelerate Distributed Joins with Predicate Transfer

Comments
7 min read
Database Normalization

Database Normalization

Comments
2 min read
Redis: The Unsung Hero of Modern Software Architecture

Redis: The Unsung Hero of Modern Software Architecture

1
Comments
9 min read
CRUD Operations in MongoDB: Hands-On with a Student Collection

CRUD Operations in MongoDB: Hands-On with a Student Collection

2
Comments
2 min read
High-Availability Schema Changes: Rolling Updates with Flyway and Spring Boot

High-Availability Schema Changes: Rolling Updates with Flyway and Spring Boot

3
Comments
5 min read
🚀 Introducing Agentic Postgres: The First & Free Database Built for Agents

🚀 Introducing Agentic Postgres: The First & Free Database Built for Agents

130
Comments 7
3 min read
loading...