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.
Cutting a MySQL table in half with one line
andreasbergstrom profile

Cutting a MySQL table in half with one line

#mysql #database #performance
Comments
1 min read
How to Export QuickBooks Data to a Database
ilshadyx profile

How to Export QuickBooks Data to a Database

#webdev #postgres #quickbooks #database
Comments
11 min read
PostgreSQL Query Anti-Patterns and Common Mistakes
philip_mcclarence_2ef9475 profile

PostgreSQL Query Anti-Patterns and Common Mistakes

#database #performance #postgres #sql
Comments 1
7 min read
SQL Subqueries vs CTEs
venuskennedy profile

SQL Subqueries vs CTEs

#beginners #database #sql #tutorial
Comments
3 min read
Schema migrations in SurrealDB: A local dev workflow
mgyles profile

Schema migrations in SurrealDB: A local dev workflow

#surrealdb #surrealkit #database #schema
20
Comments 1
5 min read
High Memory Usage in Postgres is Good, Actually
meg528 profile

High Memory Usage in Postgres is Good, Actually

#planetscale #postgres #database #webdev
1
Comments
7 min read
How I was introduced to SQL window function
dhairya_pandya profile

How I was introduced to SQL window function

#analytics #database #postgres #sql
Comments
2 min read
Data Management Systems: Transactional to Analytical Architectures
edmund_eryuba profile

Data Management Systems: Transactional to Analytical Architectures

#database #dataengineering #datastructures #data
Comments
7 min read
OLAP vs OLTP: A Deep Dive into Database Processing Systems
karen_langat_299784e2c330 profile

OLAP vs OLTP: A Deep Dive into Database Processing Systems

#data #database #dataengineering #systemdesign
Comments
3 min read
The CAP Theorem in Practice: Making the Right Trade-offs at Scale
aloknecessary profile

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

#distributedsystems #architecture #database #systemdesign
Comments
2 min read
SQL Date & Time Functions: A Practical Guide for Real-World Queries
vivekdraxlr profile

SQL Date & Time Functions: A Practical Guide for Real-World Queries

#sql #database #postgres #mysql
Comments
7 min read
Designing for Soft Deletes: Patterns, Performance, and Queries
alex_aslam profile

Designing for Soft Deletes: Patterns, Performance, and Queries

#webdev #programming #productivity #database
Comments
7 min read
How Redis Actually Works — RAM, Single Thread, and the Expiry Behavior Nobody Explains
piyush_kumarsingh_da3833 profile

How Redis Actually Works — RAM, Single Thread, and the Expiry Behavior Nobody Explains

#redis #softwareengineering #database #backend
Comments
7 min read
OLAP vs OLTP: Understanding the Backbone of Modern Data Systems
petermuriya profile

OLAP vs OLTP: Understanding the Backbone of Modern Data Systems

#data #database #dataengineering #systemdesign
1
Comments
2 min read
Why I Built a Database Client in Go Instead of Electron
shubhesh07 profile

Why I Built a Database Client in Go Instead of Electron

#showdev #database #go #performance
Comments 1
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.