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.
Building a Sales Analytics Data Warehouse with PostgreSQL
otasium profile

Building a Sales Analytics Data Warehouse with PostgreSQL

#analytics #data #database #sql
Comments
3 min read
I built a free portable tool to import huge MySQL dumps on Windows (9GB+ tested) — with real-time progress
muhammad_suleman_095 profile

I built a free portable tool to import huge MySQL dumps on Windows (9GB+ tested) — with real-time progress

#mysql #opensource #database
Comments
1 min read
40001 is not a query error
mohamedaboelmagd profile

40001 is not a query error

#postgres #node #typescript #database
1
Comments
8 min read
Offline reads are easy. Durable offline writes are the hard part.
bkniffler profile

Offline reads are easy. Durable offline writes are the hard part.

#webdev #database #opensource #architecture
Comments
3 min read
What Happens If a Bank Transfer Fails Halfway? Understanding ACID Properties in SQL
darshan_dev profile

What Happens If a Bank Transfer Fails Halfway? Understanding ACID Properties in SQL

#sql #database #programming #beginners
1
Comments
6 min read
Implementing UUID v7 with nothing but crypto.getRandomValues()
takahiro_hashito_a1f3f0dc profile

Implementing UUID v7 with nothing but crypto.getRandomValues()

#javascript #database #programming
Comments
3 min read
My Favorite Constant in Retrieval Is 60. Nobody Tunes It. That's the Point.
fagundesv profile

My Favorite Constant in Retrieval Is 60. Nobody Tunes It. That's the Point.

#python #datascience #database #vectordatabase
Comments
2 min read
SSMS Database Diagrams: Your ERD Is Trapped Inside the Database It Documents
tbson87 profile

SSMS Database Diagrams: Your ERD Is Trapped Inside the Database It Documents

#database #sqlserver #sql #documentation
Comments
6 min read
Começando minha jornada em Dados e Tecnologia
beth_rodrigues26 profile

Começando minha jornada em Dados e Tecnologia

#database #ai
Comments
1 min read
Simple PostgreSQL
chad_3a62e9557f66829b45bb profile
Chad

Simple PostgreSQL

#database #postgres #software #tools
Comments
1 min read
Fixing Enterprise HR Hierarchy Lookups Without Cache Invalidation Nightmares
shubhamshaw profile

Fixing Enterprise HR Hierarchy Lookups Without Cache Invalidation Nightmares

#database #softwareengineering #architecture #sql
Comments
1 min read
The N+1 Query Problem: The Silent Database Killer Explained Simply
saurav_tb_pandey profile

The N+1 Query Problem: The Silent Database Killer Explained Simply

#n1query #database #performance #backend
2
Comments
3 min read
Database Views in Your ERD: Read-Only Entities, Not Fake Tables
tbson87 profile

Database Views in Your ERD: Read-Only Entities, Not Fake Tables

#database #sql #postgres #architecture
Comments 1
5 min read
How Do SQL Database Engines Work?
ishimwe_charles_9a4461252 profile

How Do SQL Database Engines Work?

#sql #database
Comments
6 min read
WordPress Plugin
anandu_ravi39 profile

WordPress Plugin

#wordpress #woocommerce #opensource #database
Comments
1 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.