Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Graph database vs relational vs vector vs NoSQL
Cover image for Graph database vs relational vs vector vs NoSQL

Graph database vs relational vs vector vs NoSQL

10
Comments
2 min read
Belajar Flyway Episode 1: Pengenalan dan Migrasi Pertama
Cover image for Belajar Flyway Episode 1: Pengenalan dan Migrasi Pertama

Belajar Flyway Episode 1: Pengenalan dan Migrasi Pertama

5
Comments
10 min read
Optimizing Large Datasets in PostgreSQL With Partitioning
Cover image for Optimizing Large Datasets in PostgreSQL With Partitioning

Optimizing Large Datasets in PostgreSQL With Partitioning

Comments
2 min read
How to Optimize a Slow Query

How to Optimize a Slow Query

Comments
2 min read
Using PostgreSQL Full-Text Search for Powerful Querying in Node.js Apps
Cover image for Using PostgreSQL Full-Text Search for Powerful Querying in Node.js Apps

Using PostgreSQL Full-Text Search for Powerful Querying in Node.js Apps

Comments
2 min read
Understanding Atomicity: The First Pillar of ACID Transactions
Cover image for Understanding Atomicity: The First Pillar of ACID Transactions

Understanding Atomicity: The First Pillar of ACID Transactions

5
Comments
5 min read
Entity-Relationship (ER) Diagrams: Visualizing Your Database Structure
Cover image for Entity-Relationship (ER) Diagrams: Visualizing Your Database Structure

Entity-Relationship (ER) Diagrams: Visualizing Your Database Structure

1
Comments
2 min read
Duplicate Rows Detection in MySQL
Cover image for Duplicate Rows Detection in MySQL

Duplicate Rows Detection in MySQL

5
Comments
4 min read
How MySQL Handles a Single Data Insert
Cover image for How MySQL Handles a Single Data Insert

How MySQL Handles a Single Data Insert

11
Comments
6 min read
Database Optimization: Partitioning vs Indexing

Database Optimization: Partitioning vs Indexing

Comments
1 min read
Optimized Email lookup for millions of users

Optimized Email lookup for millions of users

1
Comments 2
3 min read
SQL Execution Order: What Really Happens Under the Hood

SQL Execution Order: What Really Happens Under the Hood

Comments
3 min read
What are Transactions ?

What are Transactions ?

Comments
1 min read
🔍 Understanding Clustered vs Non-Clustered Indexes in SQL Server

🔍 Understanding Clustered vs Non-Clustered Indexes in SQL Server

6
Comments
3 min read
Normalization: How to Structure Your Database for Efficiency
Cover image for Normalization: How to Structure Your Database for Efficiency

Normalization: How to Structure Your Database for Efficiency

4
Comments
2 min read
Master SQL with These Handy Tools, Tips, and Tricks
Cover image for Master SQL with These Handy Tools, Tips, and Tricks

Master SQL with These Handy Tools, Tips, and Tricks

1
Comments
3 min read
LINQ in Entity Framework You Should Know 🧐

LINQ in Entity Framework You Should Know 🧐

Comments
2 min read
Dbms Definition
Cover image for Dbms Definition

Dbms Definition

Comments
3 min read
7 Best Change Data Capture (CDC) Tools in 2025
Cover image for 7 Best Change Data Capture (CDC) Tools in 2025

7 Best Change Data Capture (CDC) Tools in 2025

2
Comments
6 min read
Examples of Database Management Systems
Cover image for Examples of Database Management Systems

Examples of Database Management Systems

Comments
1 min read
The simplest way to count 100 billion unique IDs: Part 1
Cover image for The simplest way to count 100 billion unique IDs: Part 1

The simplest way to count 100 billion unique IDs: Part 1

2
Comments 1
5 min read
GraphQL in 2025: What It Is, Why It Matters, and Whether You Should Bother Learning It
Cover image for GraphQL in 2025: What It Is, Why It Matters, and Whether You Should Bother Learning It

GraphQL in 2025: What It Is, Why It Matters, and Whether You Should Bother Learning It

2
Comments 1
3 min read
Tipos de Tablas en Bases de Datos: Una Guía Simplificada
Cover image for Tipos de Tablas en Bases de Datos: Una Guía Simplificada

Tipos de Tablas en Bases de Datos: Una Guía Simplificada

Comments
3 min read
I made a project in Golang with no packages or libraries (also not ORM's)
Cover image for I made a project in Golang with no packages or libraries (also not ORM's)

I made a project in Golang with no packages or libraries (also not ORM's)

Comments
8 min read
The simplest way to count 100 billion unique IDs: Part 2
Cover image for The simplest way to count 100 billion unique IDs: Part 2

The simplest way to count 100 billion unique IDs: Part 2

2
Comments
6 min read
loading...