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.
Building a CRUD API with Node.js, Express, and TypeScript: Type-Safe Database Operations

Building a CRUD API with Node.js, Express, and TypeScript: Type-Safe Database Operations

1
Comments 1
10 min read
Oracle 19c — Audit Only Top-Level SQL Statements

Oracle 19c — Audit Only Top-Level SQL Statements

Comments
3 min read
Sharding in CouchDB: Increasing the Number of Shards

Sharding in CouchDB: Increasing the Number of Shards

2
Comments
1 min read
Your Complete Event Sourcing Toolkit: The GenesisDB VS Code Extension

Your Complete Event Sourcing Toolkit: The GenesisDB VS Code Extension

1
Comments
2 min read
Beyond Vector Search: Building a RAG That *Actually* Understands Your Data

Beyond Vector Search: Building a RAG That *Actually* Understands Your Data

1
Comments
7 min read
SQL Commands Guide

SQL Commands Guide

Comments 3
4 min read
How MySQL Actually Works: A Deep Dive into Database Internals

How MySQL Actually Works: A Deep Dive into Database Internals

5
Comments
16 min read
Peewee - A Lightweight ORM for Python

Peewee - A Lightweight ORM for Python

2
Comments
1 min read
Polars - Fast DataFrames Library for Python

Polars - Fast DataFrames Library for Python

2
Comments
1 min read
Database System Internals — Transactions, Deadlocks, Recovery & Indexing Explained with SQL Examples

Database System Internals — Transactions, Deadlocks, Recovery & Indexing Explained with SQL Examples

1
Comments 1
3 min read
Indexing, Hashing & Query Optimization

Indexing, Hashing & Query Optimization

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

Database Normalization Made Simple: From 1NF to 3NF

Comments
3 min read
SQL Cursor & AFTER INSERT Trigger — Step-by-Step Guide with Example

SQL Cursor & AFTER INSERT Trigger — Step-by-Step Guide with Example

Comments 1
2 min read
CRUD Operations in MongoDB: A Beginner's Guide for College Students

CRUD Operations in MongoDB: A Beginner's Guide for College Students

Comments
3 min read
SQLite Scalar Function: Random

SQLite Scalar Function: Random

1
Comments
1 min read
Simple College Student Schema

Simple College Student Schema

Comments
3 min read
Cascade Deletion: What Happens to Comments When You Delete Your Post MongoDB

Cascade Deletion: What Happens to Comments When You Delete Your Post MongoDB

1
Comments 11
2 min read
Who wants to build an admin UI?

Who wants to build an admin UI?

Comments
3 min read
A Dive into Apache Iceberg™'s Metadata

A Dive into Apache Iceberg™'s Metadata

Comments
4 min read
Securing Your Data in PostgreSQL Using PG_TDE for Encryption – Beginner-Friendly Guide

Securing Your Data in PostgreSQL Using PG_TDE for Encryption – Beginner-Friendly Guide

Comments
7 min read
From MySQL to PostgreSQL: My Django Migration Story (and a Tool to Help)

From MySQL to PostgreSQL: My Django Migration Story (and a Tool to Help)

6
Comments
2 min read
Using a Non-Deterministic System to Find Climate Patterns

Using a Non-Deterministic System to Find Climate Patterns

14
Comments 1
3 min read
Understanding ACID Properties in SQL with Examples

Understanding ACID Properties in SQL with Examples

Comments
2 min read
Understanding Database Types

Understanding Database Types

Comments
3 min read
DATABASE NORMALIZATION

DATABASE NORMALIZATION

Comments
3 min read
loading...