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.
Fixing Database Import Failures After Moving Text Files from Windows to Linux

Fixing Database Import Failures After Moving Text Files from Windows to Linux

2
Comments
1 min read
Track Rolling-Back Transactions in GBase 8s

Track Rolling-Back Transactions in GBase 8s

2
Comments
1 min read
How to Export QuickBooks Data to a Database

How to Export QuickBooks Data to a Database

Comments
11 min read
PostgreSQL Query Anti-Patterns and Common Mistakes

PostgreSQL Query Anti-Patterns and Common Mistakes

Comments 1
7 min read
SQL Subqueries vs CTEs

SQL Subqueries vs CTEs

Comments
3 min read
High Memory Usage in Postgres is Good, Actually

High Memory Usage in Postgres is Good, Actually

1
Comments
7 min read
PostgreSQL AI Memory, Perf Tuning; Data Pipeline Orchestration Comparison

PostgreSQL AI Memory, Perf Tuning; Data Pipeline Orchestration Comparison

Comments 1
3 min read
We Replaced Redis with MySQL SKIP LOCKED for Inventory Reservation — Oversells Went to Zero

We Replaced Redis with MySQL SKIP LOCKED for Inventory Reservation — Oversells Went to Zero

Comments
3 min read
How I was introduced to SQL window function

How I was introduced to SQL window function

Comments
2 min read
Data Management Systems: Transactional to Analytical Architectures

Data Management Systems: Transactional to Analytical Architectures

Comments
7 min read
Troubleshooting GBase 8c: OS, Network, Disk, and Database

Troubleshooting GBase 8c: OS, Network, Disk, and Database

2
Comments
3 min read
OLAP vs OLTP: A Deep Dive into Database Processing Systems

OLAP vs OLTP: A Deep Dive into Database Processing Systems

Comments
3 min read
The CAP Theorem in Practice: Making the Right Trade-offs at Scale

The CAP Theorem in Practice: Making the Right Trade-offs at Scale

Comments
2 min read
What is Prisma Client, and why do I have to keep running prisma generate?

What is Prisma Client, and why do I have to keep running prisma generate?

Comments
5 min read
I built a free SQL practice game where you work at a fictional Singapore bank

I built a free SQL practice game where you work at a fictional Singapore bank

4
Comments 2
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.