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.
SQL: is there a better way to code this?

SQL: is there a better way to code this?

Comments 1
1 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
Building a Sales Database in PostgreSQL — Schema, Data & JOIN Examples

Building a Sales Database in PostgreSQL — Schema, Data & JOIN Examples

3
Comments
6 min read
3 ερωτήσεις για IT Systems Architect (Αρχιτέκτονας Συστημάτων Πληροφορικής). Τομέας: Δεδομένα & Απόδοση.

3 ερωτήσεις για IT Systems Architect (Αρχιτέκτονας Συστημάτων Πληροφορικής). Τομέας: Δεδομένα & Απόδοση.

Comments
1 min read
Multi-Tenancy Database Patterns with examples in Go

Multi-Tenancy Database Patterns with examples in Go

2
Comments
9 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
Discussion: How do you feel about giving your database credentials to cloud-hosted dev tools?

Discussion: How do you feel about giving your database credentials to cloud-hosted dev tools?

Comments
1 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
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
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
Covering Index for $group/$sum in MongoDB Aggregation (With Hint)

Covering Index for $group/$sum in MongoDB Aggregation (With Hint)

1
Comments 1
6 min read
loading...