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.
$lookup: more than just a SQL join (understand performance)

$lookup: more than just a SQL join (understand performance)

8
Comments 1
5 min read
The Case of the Frozen Supabase/Prisma db push: Why Your Migrations Might Be Stuck

The Case of the Frozen Supabase/Prisma db push: Why Your Migrations Might Be Stuck

Comments
2 min read
PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup

PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup

Comments
3 min read
Free PostgreSQL Hosting Now Available – Public Access Included

Free PostgreSQL Hosting Now Available – Public Access Included

Comments 1
3 min read
Which LLM writes the best SQL?

Which LLM writes the best SQL?

Comments
10 min read
Why the Future of Stream Processing Is Rust + Iceberg + Postgres + S3

Why the Future of Stream Processing Is Rust + Iceberg + Postgres + S3

Comments
2 min read
Create Columns from Distinct Values of a Column — From SQL to SPL #26

Create Columns from Distinct Values of a Column — From SQL to SPL #26

6
Comments 1
1 min read
Understanding Database Schema Structure for Beginners

Understanding Database Schema Structure for Beginners

1
Comments
4 min read
Educational Credentials in the Digital Age: Ensuring Authenticity and Portability

Educational Credentials in the Digital Age: Ensuring Authenticity and Portability

Comments
3 min read
Why Transactional Databases Matter: Concepts, Use Cases, and Examples

Why Transactional Databases Matter: Concepts, Use Cases, and Examples

2
Comments 2
3 min read
How to Think in Access Patterns First With DynamoDB

How to Think in Access Patterns First With DynamoDB

Comments
3 min read
Why Postgres is Your App’s Secret Superpower (And Why You’re Overcomplicating Everything)

Why Postgres is Your App’s Secret Superpower (And Why You’re Overcomplicating Everything)

Comments 1
4 min read
🚀 Boosting React Native Performance with Caching — Made Simple

🚀 Boosting React Native Performance with Caching — Made Simple

Comments 1
3 min read
How I Got x311 Faster Analytics on 110M Rows

How I Got x311 Faster Analytics on 110M Rows

Comments
3 min read
How Excel is Used in Real-World Data Analysis

How Excel is Used in Real-World Data Analysis

4
Comments 2
3 min read
Substring from a Column of Strings — From SQL to SPL #25

Substring from a Column of Strings — From SQL to SPL #25

5
Comments 1
2 min read
Total under Recursive Relationship — From SQL to SPL #33

Total under Recursive Relationship — From SQL to SPL #33

7
Comments 1
2 min read
Importing Excel with multiple headers into a database

Importing Excel with multiple headers into a database

Comments
1 min read
Learning PostgreSQL

Learning PostgreSQL

Comments
2 min read
Isolation Level for MongoDB Multi-Document Transactions (Strong Consistency)

Isolation Level for MongoDB Multi-Document Transactions (Strong Consistency)

6
Comments 2
11 min read
Batch export database tables to Excel

Batch export database tables to Excel

Comments
2 min read
How to install PostgreSQL on macOS: Step-by-Step Instructions

How to install PostgreSQL on macOS: Step-by-Step Instructions

Comments
1 min read
How to Configure Docker Volumes for MySQL

How to Configure Docker Volumes for MySQL

3
Comments 1
1 min read
Couchbase Weekly Updates - May 16, 2025

Couchbase Weekly Updates - May 16, 2025

1
Comments
1 min read
Retrieval Technique Series-4.How Search Engines Generate Indexes for Trillions of Websites?

Retrieval Technique Series-4.How Search Engines Generate Indexes for Trillions of Websites?

2
Comments
5 min read
loading...