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.
Exploring ACID Properties in SQL with Practical Queries

Exploring ACID Properties in SQL with Practical Queries

1
Comments
2 min read
Exploring SQL Transactions, Deadlocks & Log-Based Recovery

Exploring SQL Transactions, Deadlocks & Log-Based Recovery

Comments 2
2 min read
SQL Cursors and Triggers

SQL Cursors and Triggers

1
Comments
1 min read
Database Normalization in SQL — 1NF, 2NF, and 3NF Explained (Student–Course Case Study)

Database Normalization in SQL — 1NF, 2NF, and 3NF Explained (Student–Course Case Study)

1
Comments
3 min read
Transactions, Deadlocks & Log Based Recovery

Transactions, Deadlocks & Log Based Recovery

1
Comments
1 min read
SQL Indexing, Hashing & Query Optimization with a Students Table

SQL Indexing, Hashing & Query Optimization with a Students Table

Comments
3 min read
SQL Cursor and Trigger Implementation

SQL Cursor and Trigger Implementation

Comments
2 min read
Discovering Hidden Connections with Neo4j: My First Real Use Case

Discovering Hidden Connections with Neo4j: My First Real Use Case

Comments
2 min read
First/Last per Group: PostgreSQL DISTINCT ON and MongoDB DISTINCT_SCAN Performance

First/Last per Group: PostgreSQL DISTINCT ON and MongoDB DISTINCT_SCAN Performance

Comments
5 min read
Supabase Managing database migrations across multiple environments (Local, Staging, Production)

Supabase Managing database migrations across multiple environments (Local, Staging, Production)

2
Comments
26 min read
Cursor & Trigger in SQL with Examples

Cursor & Trigger in SQL with Examples

Comments
2 min read
How to Deploy a PostgreSQL Database on AWS RDS (Step-by-Step)

How to Deploy a PostgreSQL Database on AWS RDS (Step-by-Step)

Comments
7 min read
Persisting data in Rust with Heave

Persisting data in Rust with Heave

2
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
8 min read
A Beginner’s Guide to AWS DynamoDB: Creating Your First Table

A Beginner’s Guide to AWS DynamoDB: Creating Your First Table

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