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.
The filesystem - a quick & dirty way to store temp data in your API

The filesystem - a quick & dirty way to store temp data in your API

Comments
2 min read
Postgres Is All You Need

Postgres Is All You Need

94
Comments 9
4 min read
Are SQL Joins Expensive?

Are SQL Joins Expensive?

5
Comments
2 min read
𝗛𝗼𝘄 𝘁𝗼 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 𝗦𝗽𝗲𝗻𝘁 𝗔𝗺𝗼𝘂𝗻𝘁 𝗶𝗻 𝗕𝘂𝗱𝗴𝗲𝘁 𝗨𝘀𝗶𝗻𝗴 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀 𝗶𝗻 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿

𝗛𝗼𝘄 𝘁𝗼 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝗨𝗽𝗱𝗮𝘁𝗲 𝗦𝗽𝗲𝗻𝘁 𝗔𝗺𝗼𝘂𝗻𝘁 𝗶𝗻 𝗕𝘂𝗱𝗴𝗲𝘁 𝗨𝘀𝗶𝗻𝗴 𝗧𝗿𝗶𝗴𝗴𝗲𝗿𝘀 𝗶𝗻 𝗦𝗤𝗟 𝗦𝗲𝗿𝘃𝗲𝗿

Comments
1 min read
Trust But Verify: Evaluating Security When Choosing Data Infrastructure Tools

Trust But Verify: Evaluating Security When Choosing Data Infrastructure Tools

Comments
8 min read
How to test Umbraco against a real database

How to test Umbraco against a real database

1
Comments
5 min read
Mastering SQLite: Efficient Database Management Tips

Mastering SQLite: Efficient Database Management Tips

2
Comments
3 min read
Postgresql vs. MongoDB

Postgresql vs. MongoDB

1
Comments
2 min read
🛠️ Copying and Moving Data Between Tables in ClickHouse (with Different Engines)

🛠️ Copying and Moving Data Between Tables in ClickHouse (with Different Engines)

7
Comments
2 min read
TiDB Serverless vs PlanetScale: The Ultimate Cloud Database Showdown

TiDB Serverless vs PlanetScale: The Ultimate Cloud Database Showdown

Comments
3 min read
TiDB Serverless vs Amazon RDS: The Ultimate Cloud Database Showdown

TiDB Serverless vs Amazon RDS: The Ultimate Cloud Database Showdown

Comments
3 min read
Lessons learned from 5 years operating huge ClickHouse® clusters: Part II

Lessons learned from 5 years operating huge ClickHouse® clusters: Part II

1
Comments
8 min read
Filtering Data in SQL: Using WHERE, AND, OR, and NOT

Filtering Data in SQL: Using WHERE, AND, OR, and NOT

Comments
1 min read
I've operated petabyte-scale ClickHouse® clusters for 5 years

I've operated petabyte-scale ClickHouse® clusters for 5 years

1
Comments
14 min read
Get Total Count of Tables per Database in MySQL

Get Total Count of Tables per Database in MySQL

Comments
1 min read
Building a Worldbuilding Tool with Flutter

Building a Worldbuilding Tool with Flutter

Comments
3 min read
How I Migrated An SQL Database To DynamoDB

How I Migrated An SQL Database To DynamoDB

1
Comments
5 min read
NestJS + Neo4j + GraphQL Setup

NestJS + Neo4j + GraphQL Setup

Comments
4 min read
Build a free ip info cache with PocketBase

Build a free ip info cache with PocketBase

Comments
1 min read
What counts as a "slow database query"? It's surprisingly hard to say

What counts as a "slow database query"? It's surprisingly hard to say

2
Comments
6 min read
Database Management Systems for SaaS: A Comprehensive Guide

Database Management Systems for SaaS: A Comprehensive Guide

1
Comments
3 min read
Embedded Documents and Arrays | MongoDB Tutorial 2025

Embedded Documents and Arrays | MongoDB Tutorial 2025

11
Comments
4 min read
Mastering PostgreSQL Table Partitioning for Scalable Databases

Mastering PostgreSQL Table Partitioning for Scalable Databases

Comments
3 min read
It’s Still Postgres—But Better: Timescale Integration Guides

It’s Still Postgres—But Better: Timescale Integration Guides

1
Comments
1 min read
Game-Changing Guide to SQL for SEO Optimization

Game-Changing Guide to SQL for SEO Optimization

Comments
6 min read
loading...