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.
Why I'm Building My Own Distributed Database

Why I'm Building My Own Distributed Database

5
Comments
5 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: The Unsung Hero of Modern Software Architecture

Redis: The Unsung Hero of Modern Software Architecture

Comments
9 min read
CRUD, reps, repeat - My Database Grind

CRUD, reps, repeat - My Database Grind

Comments
3 min read
The Card Whisperer: Predicting Database Query Costs... Without Data by Arvind Sundararajan

The Card Whisperer: Predicting Database Query Costs... Without Data by Arvind Sundararajan

Comments
2 min read
An Introduction to Commonly Used PL/SQL Data Types

An Introduction to Commonly Used PL/SQL Data Types

Comments
4 min read
Beautify and Organize Your Queries Effortlessly with DevUtilX SQL Formatter 💡

Beautify and Organize Your Queries Effortlessly with DevUtilX SQL Formatter 💡

Comments
2 min read
Undo Redo Database Queries

Undo Redo Database Queries

Comments
25 min read
Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table

Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table

Comments
18 min read
Query Anything with SQL: Your Developer's Deep Dive into Apache Drill

Query Anything with SQL: Your Developer's Deep Dive into Apache Drill

Comments
8 min read
SQL is King, But is it Your Only Ruler? A Developer's Guide to NoSQL

SQL is King, But is it Your Only Ruler? A Developer's Guide to NoSQL

1
Comments
7 min read
Why Do Data Pipelines Need Streaming — Isn’t Batch Processing Enough?

Why Do Data Pipelines Need Streaming — Isn’t Batch Processing Enough?

Comments
4 min read
🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨

🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨

Comments
3 min read
py schema

py schema

Comments
2 min read
Database Normalization: From 1NF to 3NF

Database Normalization: From 1NF to 3NF

Comments
2 min read
Cursor +Trigger

Cursor +Trigger

Comments
2 min read
Understanding SQL Databases

Understanding SQL Databases

1
Comments
1 min read
GETTING TO KNOW:STAR AND SNOWFLAKE SCHEMA.

GETTING TO KNOW:STAR AND SNOWFLAKE SCHEMA.

Comments
3 min read
ACID Properties in DBMS

ACID Properties in DBMS

Comments
1 min read
INDEXING - HASHING - AND -QUERY

INDEXING - HASHING - AND -QUERY

Comments
1 min read
Transactions, Deadlocks & Log Based Recovery

Transactions, Deadlocks & Log Based Recovery

Comments
1 min read
CRUD Operations in MongoDB — Student Management System

CRUD Operations in MongoDB — Student Management System

Comments
3 min read
🚀 MongoDB CRUD Operations with a Student Schema

🚀 MongoDB CRUD Operations with a Student Schema

1
Comments
2 min read
Cursor + Trigger

Cursor + Trigger

1
Comments
2 min read
💾Ensuring Database Stability: Transactions, Deadlocks & Log-Based Recovery

💾Ensuring Database Stability: Transactions, Deadlocks & Log-Based Recovery

Comments
3 min read
loading...