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

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

#mongodb #document #database #sql
8
Comments 1
5 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
15
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
49
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
Breaking Up With ORMs – Part One: Reclaiming Control with Custom SQL Adapters
sogweb profile

Breaking Up With ORMs – Part One: Reclaiming Control with Custom SQL Adapters

#backenddevelopment #webdev #opensource #database
Comments
4 min read
Understanding Atomicity in PostgreSQL: A Deep Dive into the “A” in ACID
kfir-g profile

Understanding Atomicity in PostgreSQL: A Deep Dive into the “A” in ACID

#transactions #database #postgres #atomicity
Comments
4 min read
Entenda Teorema CAP
ikauedev profile

Entenda Teorema CAP

#webdev #programming #database
1
Comments
5 min read
Databricks News: Highlights from Data + AI Summit 2025
gabrielhca profile

Databricks News: Highlights from Data + AI Summit 2025

#discuss #webdev #database #programming
Comments
2 min read
Virtual Learning Festival and Vouchers: An Unmissable Opportunity
gabrielhca profile

Virtual Learning Festival and Vouchers: An Unmissable Opportunity

#webdev #programming #database #webassembly
Comments
2 min read
Understanding BSON for Java Developers: A Beginner’s Guide to MongoDB’s Data Format
timkelly profile

Understanding BSON for Java Developers: A Beginner’s Guide to MongoDB’s Data Format

#mongodb #java #database #data
16
Comments 1
16 min read
Understanding Query Cost in SQL
samitkapoor profile

Understanding Query Cost in SQL

#sql #database
3
Comments 1
7 min read
Understanding T-SQL vs PL/SQL Database Curveballs
michael-gokey profile

Understanding T-SQL vs PL/SQL Database Curveballs

#tsql #plsql #database #dba
1
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.