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.
Database for newbies: Hands On

Database for newbies: Hands On

91
Comments 6
6 min read
All MongoDB commands you need to know

All MongoDB commands you need to know

87
Comments 31
4 min read
Meet Datomic: the immutable and functional database.

Meet Datomic: the immutable and functional database.

79
Comments 11
9 min read
PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?

PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?

47
Comments 11
6 min read
Redis reborn, a new chapter begins

Redis reborn, a new chapter begins

36
Comments 15
3 min read
Difference between WHERE vs HAVING Clause in SQL

Difference between WHERE vs HAVING Clause in SQL

32
Comments
3 min read
Mastering SQL Queries: A Comprehensive Guide for Beginners

Mastering SQL Queries: A Comprehensive Guide for Beginners

25
Comments 5
2 min read
End-To-End Polymorphism: From Database to UI, Achieving SOLID Design

End-To-End Polymorphism: From Database to UI, Achieving SOLID Design

21
Comments
10 min read
3 Proven Patterns for Reporting with Serverless

3 Proven Patterns for Reporting with Serverless

15
Comments
10 min read
End of ElephantSQL 😔

End of ElephantSQL 😔

13
Comments 3
1 min read
The best free database providers in 2024

The best free database providers in 2024

12
Comments 1
5 min read
This is How You Build AI Apps Using the RAG Framework in 5 Minutes!

This is How You Build AI Apps Using the RAG Framework in 5 Minutes!

11
Comments
6 min read
PostgreSQL index Correlation with UPDATE

PostgreSQL index Correlation with UPDATE

10
Comments
17 min read
Boom 💥, Supabase Marks Its GA Milestone

Boom 💥, Supabase Marks Its GA Milestone

10
Comments 2
3 min read
Como normalizar banco de dados?

Como normalizar banco de dados?

9
Comments
2 min read
9 differences between IndexedDB and LocalStorage

9 differences between IndexedDB and LocalStorage

8
Comments 1
6 min read
Iniciando no Elasticsearch: Conceitos básicos

Iniciando no Elasticsearch: Conceitos básicos

7
Comments
6 min read
A Straightforward Guide for Isolation Levels

A Straightforward Guide for Isolation Levels

7
Comments
13 min read
Managing Concurrent Database Writes in a Distributed System with Redis or PostgreSQL

Managing Concurrent Database Writes in a Distributed System with Redis or PostgreSQL

7
Comments
3 min read
Scalable Notification System Design for 50 Million Users (Database Design)

Scalable Notification System Design for 50 Million Users (Database Design)

7
Comments
3 min read
Astro DB: Migrating my analytics data from Vercel Postgres

Astro DB: Migrating my analytics data from Vercel Postgres

6
Comments
4 min read
How to Handle N+1 Queries for Optimal Database Performance in Django?

How to Handle N+1 Queries for Optimal Database Performance in Django?

6
Comments
7 min read
How to Replace a Null with the Corresponding Value in the Previous Record

How to Replace a Null with the Corresponding Value in the Previous Record

6
Comments 1
1 min read
Prisma Part 1: Your Easy Tutorial to Set up Prisma

Prisma Part 1: Your Easy Tutorial to Set up Prisma

6
Comments
4 min read
How to Convert Dates in One Group into An Interval

How to Convert Dates in One Group into An Interval

5
Comments
2 min read
What You Possibly Don’t Know About Columnar Storage

What You Possibly Don’t Know About Columnar Storage

5
Comments
6 min read
How to Calculate Median on Values That Have Corresponding Quantities

How to Calculate Median on Values That Have Corresponding Quantities

5
Comments
2 min read
Introducing Map Projection in Apache AGE Open Cypher

Introducing Map Projection in Apache AGE Open Cypher

5
Comments 2
2 min read
In a Multilevel Relationship, How to Replace Null Values at Nodes by Corresponding Values at Their Parent Nodes

In a Multilevel Relationship, How to Replace Null Values at Nodes by Corresponding Values at Their Parent Nodes

5
Comments 1
1 min read
How to Transpose Rows to Columns on Multiple Fields in Each Group

How to Transpose Rows to Columns on Multiple Fields in Each Group

5
Comments 1
2 min read
Docker for beginners: Creating Database Containers

Docker for beginners: Creating Database Containers

5
Comments 2
10 min read
Fundamentals of MongoDB (part 1)

Fundamentals of MongoDB (part 1)

5
Comments 1
3 min read
PostgreSQL with modern storage: what about a lower random_page_cost?

PostgreSQL with modern storage: what about a lower random_page_cost?

5
Comments
11 min read
Clear Vision, Not So Clear (or.. The User Is Me)

Clear Vision, Not So Clear (or.. The User Is Me)

4
Comments 2
3 min read
SQL Pro Tips : industrial GCP BigQuery SQL using WITH

SQL Pro Tips : industrial GCP BigQuery SQL using WITH

3
Comments
5 min read
SQL Pro Tips : industrial Oracle SQL using WITH

SQL Pro Tips : industrial Oracle SQL using WITH

3
Comments
4 min read
What I learned from managing hundred millions of data in MongoDB

What I learned from managing hundred millions of data in MongoDB

3
Comments 1
2 min read
Easy no-code REST API for your databases

Easy no-code REST API for your databases

3
Comments 2
3 min read
Oracle Database - Compare Execution Plans

Oracle Database - Compare Execution Plans

3
Comments
5 min read
SQL Pro Tips : industrial AWS Athena SQL using WITH

SQL Pro Tips : industrial AWS Athena SQL using WITH

3
Comments
4 min read
Vector Database solutions on AWS

Vector Database solutions on AWS

3
Comments 1
2 min read
Best Practices for dynamodb

Best Practices for dynamodb

3
Comments
3 min read
Get started with Prisma ORM and Xata's Postgres service

Get started with Prisma ORM and Xata's Postgres service

3
Comments
5 min read
Setting up a Database Driver, Repository and Implementation of a transaction function for your Go App

Setting up a Database Driver, Repository and Implementation of a transaction function for your Go App

3
Comments 2
13 min read
MongoDB in C#: Simplified Guide For Inserting Data

MongoDB in C#: Simplified Guide For Inserting Data

2
Comments
7 min read
Running schema/database migrations using Geni

Running schema/database migrations using Geni

2
Comments
4 min read
Emergence of Vector Databases

Emergence of Vector Databases

2
Comments
4 min read
Weekly Updates - Apr 5 2024

Weekly Updates - Apr 5 2024

2
Comments
1 min read
End-to-End Basic Data Engineering Tutorial (Spark, Dremio, Superset)

End-to-End Basic Data Engineering Tutorial (Spark, Dremio, Superset)

2
Comments
11 min read
How to find the number of SELECTs, INSERTs, DELETEs, and UPDATEs on a specific table in PostgreSQL?

How to find the number of SELECTs, INSERTs, DELETEs, and UPDATEs on a specific table in PostgreSQL?

2
Comments
1 min read
How come there are tens of thousands of tables in a database

How come there are tens of thousands of tables in a database

2
Comments 1
5 min read
Oracle Database - Identifying Session Tracefiles - without actually tracing them :-)

Oracle Database - Identifying Session Tracefiles - without actually tracing them :-)

2
Comments
5 min read
Weekly Updates - Apr 12 2024

Weekly Updates - Apr 12 2024

2
Comments
1 min read
MongoDB vs Redis: A Comprehensive Comparison

MongoDB vs Redis: A Comprehensive Comparison

2
Comments 2
5 min read
Setting Up Your Database (Next.js)

Setting Up Your Database (Next.js)

2
Comments
3 min read
Retrieving the latest row per group from PostgreSQL

Retrieving the latest row per group from PostgreSQL

2
Comments
11 min read
Integrating Predictive Analytics Models into SQL Queries

Integrating Predictive Analytics Models into SQL Queries

2
Comments
14 min read
Eli5 - Why SurrealDB, explained through building with LEGO

Eli5 - Why SurrealDB, explained through building with LEGO

2
Comments
4 min read
Data API for Amazon Aurora Serverless v2 with AWS SDK for Java - Part 5 Basic cold and warm starts measurements

Data API for Amazon Aurora Serverless v2 with AWS SDK for Java - Part 5 Basic cold and warm starts measurements

2
Comments
3 min read
MongoDB For Beginners(Using Docker)

MongoDB For Beginners(Using Docker)

2
Comments 4
9 min read
loading...