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.
Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41
judith677 profile

Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41

#programming #database #sql #esprocspl
10
Comments 3
2 min read
One million $lookup challenge (performance comparison)
franckpachot profile

One million $lookup challenge (performance comparison)

#mongodb #document #database #join
6
Comments
6 min read
A Unified, Type-Safe Database Adapter System for Multi-DB Applications
bilelsalemdev profile

A Unified, Type-Safe Database Adapter System for Multi-DB Applications

#database #backend #nestjs #designpatterns
3
Comments
5 min read
I Built a Free CSV Toolkit That Runs Everything in Your Browser (No Signups)
crafting-code profile

I Built a Free CSV Toolkit That Runs Everything in Your Browser (No Signups)

#webdev #programming #productivity #database
5
Comments
2 min read
5 Things I Learned Building a Database File Format from Scratch
devdevgo profile

5 Things I Learned Building a Database File Format from Scratch

#database #programming #go
Comments
5 min read
Best Oracle Database Design Tools in 2025
roxana_haidiner profile

Best Oracle Database Design Tools in 2025

#oracle #sql #database #webdev
13
Comments 8
7 min read
How to Document a PostgreSQL Schema in 2025
roxana_haidiner profile

How to Document a PostgreSQL Schema in 2025

#postgres #postgressql #sql #database
13
Comments 1
4 min read
Using NoSQL Features in PostgreSQL
josethz00 profile

Using NoSQL Features in PostgreSQL

#database #tutorial #postgres #nosql
9
Comments
3 min read
Inside Databases: BSTs, B-Trees, & LSM Trees
chameera profile

Inside Databases: BSTs, B-Trees, & LSM Trees

#database #dataengineering #datastructures
1
Comments
7 min read
Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40
judith677 profile

Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40

#programming #database #sql #esprocspl
11
Comments 3
2 min read
How I Use Pydantic to Save AI Projects from Data Disasters
brains_behind_bots profile

How I Use Pydantic to Save AI Projects from Data Disasters

#pydantic #ai #database #python
11
Comments
3 min read
Diagnosing and fixing critical PostgreSQL performance issues: A deep dive
pedrohgoncalves profile

Diagnosing and fixing critical PostgreSQL performance issues: A deep dive

#database #postgres #advanced #performance
11
Comments 1
14 min read
Find Consecutive Alphabetical Characters in String — From SQL to SPL #28
judith677 profile

Find Consecutive Alphabetical Characters in String — From SQL to SPL #28

#programming #database #sql #esproc
8
Comments 1
2 min read
Scaling PostgreSQL Performance with Table Partitioning
amree profile

Scaling PostgreSQL Performance with Table Partitioning

#postgres #database #rails
48
Comments 7
12 min read
How to Speed Up EXISTS in Primary-Subtable Joins with esProc
esproc_spl profile

How to Speed Up EXISTS in Primary-Subtable Joins with esProc

#mysql #development #esproc #database
6
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.