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.
Announcing the Redis Hackathon on DEV!

Announcing the Redis Hackathon on DEV!

810
Comments 88
10 min read
Mastering Relational Database Design: A Comprehensive Guide

Mastering Relational Database Design: A Comprehensive Guide

716
Comments 49
20 min read
Back-end Developers RoadMap❤

Back-end Developers RoadMap❤

714
Comments 10
2 min read
ISP Proxies vs Residential Proxies: Main differences

ISP Proxies vs Residential Proxies: Main differences

632
Comments 4
4 min read
Database 101: How does migration between databases work in the real world?

Database 101: How does migration between databases work in the real world?

577
Comments 54
9 min read
Database 101: How social media “likes” are stored in a database

Database 101: How social media “likes” are stored in a database

530
Comments 65
6 min read
The Comprehensive Sequelize Cheatsheet

The Comprehensive Sequelize Cheatsheet

476
Comments 12
12 min read
Database 101: Data Consistency for Beginners

Database 101: Data Consistency for Beginners

461
Comments 44
7 min read
Database 101: How to Model Leaderboards for 1M Player's Game.

Database 101: How to Model Leaderboards for 1M Player's Game.

447
Comments 41
9 min read
Count(*) vs Count(1) in SQL

Count(*) vs Count(1) in SQL

399
Comments 18
3 min read
Design DB schema and generate SQL code with dbdiagram.io

Design DB schema and generate SQL code with dbdiagram.io

386
Comments 5
9 min read
How to Use Google Sheets as a Database (Responsibly)

How to Use Google Sheets as a Database (Responsibly)

379
Comments 21
7 min read
1 SQL Query You Should Stop Using

1 SQL Query You Should Stop Using

369
Comments 43
3 min read
Beginner's guide to Elasticsearch

Beginner's guide to Elasticsearch

357
Comments 41
16 min read
Database 101: Twitch Bot in a higher level for beginners.

Database 101: Twitch Bot in a higher level for beginners.

356
Comments 23
10 min read
Database Architectures & Use Cases - Explained

Database Architectures & Use Cases - Explained

282
Comments 11
7 min read
Database 101: SSL/TLS for beginners

Database 101: SSL/TLS for beginners

269
Comments 7
17 min read
HERN Stack, Comin’ In Hot

HERN Stack, Comin’ In Hot

264
Comments 34
5 min read
Advanced SQL: Mastering Query Optimization and Complex Joins

Advanced SQL: Mastering Query Optimization and Complex Joins

262
Comments 19
7 min read
The Better Way of Sending Data to the Backend

The Better Way of Sending Data to the Backend

257
Comments 17
2 min read
Why I switched away from Google Firestore

Why I switched away from Google Firestore

245
Comments 43
7 min read
Database Naming Standards

Database Naming Standards

237
Comments 20
6 min read
What exactly is API?

What exactly is API?

236
Comments 16
3 min read
How to set up a free PostgreSQL database on Heroku

How to set up a free PostgreSQL database on Heroku

231
Comments 13
3 min read
Do you know GeoJSON ?

Do you know GeoJSON ?

226
Comments 4
4 min read
How my open source project got angel investment from a user itself! 🎃

How my open source project got angel investment from a user itself! 🎃

221
Comments 17
5 min read
From 15,000 database connections to under 100: DigitalOcean's tale of tech debt

From 15,000 database connections to under 100: DigitalOcean's tale of tech debt

220
Comments 20
7 min read
How to build 7,000+ REST APIs within 2 mins (Node.js + MySQL) !!

How to build 7,000+ REST APIs within 2 mins (Node.js + MySQL) !!

211
Comments 1
1 min read
🌱 Complete REST API with MongoDB Atlas cloud, Node, and Express in 10 minutes

🌱 Complete REST API with MongoDB Atlas cloud, Node, and Express in 10 minutes

211
Comments 6
10 min read
When to choose NoSQL over SQL?

When to choose NoSQL over SQL?

210
Comments 22
2 min read
Building a Database Written in Node.js from the Ground Up

Building a Database Written in Node.js from the Ground Up

209
Comments 17
8 min read
Join us for the Open Source AI Challenge with pgai and Ollama: $3,000 in Prizes!

Join us for the Open Source AI Challenge with pgai and Ollama: $3,000 in Prizes!

208
Comments 27
4 min read
ChartDB: From Zero to 1.5K GitHub Stars in 3 Days - Here’s How 🚀⭐️

ChartDB: From Zero to 1.5K GitHub Stars in 3 Days - Here’s How 🚀⭐️

196
Comments 29
3 min read
How to write & run database migration in Golang

How to write & run database migration in Golang

194
Comments 14
8 min read
Join us for the Neon Open Source Starter Kit Challenge: $3,000 in Prizes!

Join us for the Neon Open Source Starter Kit Challenge: $3,000 in Prizes!

193
Comments 28
2 min read
NoSQL Database Design for E-Commerce Apps in 2021

NoSQL Database Design for E-Commerce Apps in 2021

190
Comments
6 min read
Redis Performance Tuning: How to Optimize Redis for High-Traffic Applications

Redis Performance Tuning: How to Optimize Redis for High-Traffic Applications

189
Comments 2
7 min read
Database GUIs in JavaScript

Database GUIs in JavaScript

188
Comments 13
5 min read
Top 7 Resources to Learn SQL

Top 7 Resources to Learn SQL

188
Comments 3
2 min read
Optimizing your MySQL queries

Optimizing your MySQL queries

188
Comments 2
8 min read
Web Scraper & Data Extraction with Python | Upwork Series #1

Web Scraper & Data Extraction with Python | Upwork Series #1

181
Comments 12
7 min read
NoSQL Databases vs Graph Databases: Which one should you use?

NoSQL Databases vs Graph Databases: Which one should you use?

178
Comments 6
14 min read
Redis, Kafka or RabbitMQ: Which MicroServices Message Broker To Choose?

Redis, Kafka or RabbitMQ: Which MicroServices Message Broker To Choose?

175
Comments 10
5 min read
Supabase - An OpenSource Firebase Alternative

Supabase - An OpenSource Firebase Alternative

174
Comments 7
5 min read
Make websites work offline - Offline Storage. Making IndexedDB the Hero!

Make websites work offline - Offline Storage. Making IndexedDB the Hero!

174
Comments 11
3 min read
PostgreSQL 16 Installation on Ubuntu 22.04

PostgreSQL 16 Installation on Ubuntu 22.04

172
Comments 12
2 min read
Should I use SQLite, PostgreSQL, or MySQL?

Should I use SQLite, PostgreSQL, or MySQL?

169
Comments 26
5 min read
WTF Is a Vector Database: A Beginner's Guide!

WTF Is a Vector Database: A Beginner's Guide!

168
Comments 17
9 min read
Graph Databases vs Relational Databases: What and why?

Graph Databases vs Relational Databases: What and why?

168
Comments 6
13 min read
Set Up a Decentralized Database with React and GunDB

Set Up a Decentralized Database with React and GunDB

168
Comments 10
3 min read
Building a Scalable E-Commerce Data Model

Building a Scalable E-Commerce Data Model

166
Comments 8
8 min read
Your Old Laptop Is Your New Database Server

Your Old Laptop Is Your New Database Server

166
Comments 12
8 min read
Mastering SQL: Comprehensive Guide To Structured Query Language

Mastering SQL: Comprehensive Guide To Structured Query Language

165
Comments 6
5 min read
PostgreSQL vs MongoDB

PostgreSQL vs MongoDB

164
Comments 76
1 min read
8 New SQL Tools That Will Change How You Work in 2020

8 New SQL Tools That Will Change How You Work in 2020

163
Comments 7
6 min read
The Resources I Wish I Had When I Learned About Databases

The Resources I Wish I Had When I Learned About Databases

163
Comments 3
3 min read
Turning Git into an application database

Turning Git into an application database

161
Comments 10
6 min read
Database Design Tutorial

Database Design Tutorial

158
Comments 2
9 min read
eCommerce Database Design

eCommerce Database Design

158
Comments 14
5 min read
DynamoDB Cheatsheet – Everything you need to know about Dynamo DB for the 2020 AWS Certified Developer Associate Certification

DynamoDB Cheatsheet – Everything you need to know about Dynamo DB for the 2020 AWS Certified Developer Associate Certification

155
Comments 3
9 min read
loading...