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.
A Beginner's Guide to SQL Joins and Window Functions
nganga_njongo profile

A Beginner's Guide to SQL Joins and Window Functions

#database #sql #dataengineering #datascience
1
Comments
6 min read
How We Query 16.8M SIRENE Establishments in 66ms
wbennaceur profile

How We Query 16.8M SIRENE Establishments in 66ms

#postgressql #database #performance #api
1
Comments
3 min read
Stop Passing *sql.Tx Through Your Go Service Layer
gabrielanhaia profile

Stop Passing *sql.Tx Through Your Go Service Layer

#go #architecture #database #tutorial
Comments
3 min read
Scaling pgvector: Memory, Quantization, and Index Build Strategies
philip_mcclarence_2ef9475 profile

Scaling pgvector: Memory, Quantization, and Index Build Strategies

#ai #database #performance #postgres
1
Comments
4 min read
PostgreSQL Query Optimization: 10 Techniques That Actually Work
philip_mcclarence_2ef9475 profile

PostgreSQL Query Optimization: 10 Techniques That Actually Work

#database #performance #postgres #sql
1
Comments
12 min read
Beyond Keywords: Unpacking Elasticsearch's Inverted Index for Sub-Millisecond Search
iprithv profile

Beyond Keywords: Unpacking Elasticsearch's Inverted Index for Sub-Millisecond Search

#elasticsearch #search #database #performance
Comments
7 min read
drm-cli v1.1 is out — PostgreSQL, Oracle, Liquibase & Flyway now supported
dband-drm profile

drm-cli v1.1 is out — PostgreSQL, Oracle, Liquibase & Flyway now supported

#database #devops #opensource #postgres
Comments
4 min read
I Built a Database That Never Forgets — Here's Why
walebadr profile

I Built a Database That Never Forgets — Here's Why

#rust #database #sql #opensource
1
Comments
14 min read
A Evolução do Modelo Relacional para o Objeto-Relacional: Entendendo o PostgreSQL
cesar_julio_8f42e72fa6b2e profile

A Evolução do Modelo Relacional para o Objeto-Relacional: Entendendo o PostgreSQL

#architecture #computerscience #database #postgres
Comments
3 min read
A Evolução do Modelo Relacional para Objeto-Relacional
_gian__c01de657218cfba0ea profile
_GIAN_

A Evolução do Modelo Relacional para Objeto-Relacional

#backend #computerscience #database #sql
1
Comments
4 min read
Meet Trysil: a lightweight ORM for Delphi
davidlastrucci profile

Meet Trysil: a lightweight ORM for Delphi

#delphi #orm #database #opensource
1
Comments
3 min read
Optimizing Complex Sequelize Queries: Search, Sorting & Pagination Done Right
muhammad_usman_dev profile

Optimizing Complex Sequelize Queries: Search, Sorting & Pagination Done Right

#database #javascript #node #sql
Comments
2 min read
SQL Aggregate Functions: Stop Guessing, Start Calculating
vivekdraxlr profile

SQL Aggregate Functions: Stop Guessing, Start Calculating

#sql #database #beginners #tutorial
Comments
6 min read
CLI Over MCP: Why AI Agents Need a Different Kind of Database Interface
_4f268336f6580845cdc475 profile

CLI Over MCP: Why AI Agents Need a Different Kind of Database Interface

#agents #cli #database #mcp
6
Comments
14 min read
PostgreSQL vs MongoDB: When I Pick Which for the Backend
iamsaadmehmood profile

PostgreSQL vs MongoDB: When I Pick Which for the Backend

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