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.
Stop Reading EXPLAIN Plans by Hand: Introducing pgexplain and pgwatch 🐘
bright98 profile

Stop Reading EXPLAIN Plans by Hand: Introducing pgexplain and pgwatch 🐘

#postgres #go #cli #database
2
Comments
4 min read
How to Prompt AI Tools to Write Accurate SQL Queries (And Why Most Developers Get This Wrong)
vivekdraxlr profile

How to Prompt AI Tools to Write Accurate SQL Queries (And Why Most Developers Get This Wrong)

#sql #database #ai #tutorial
2
Comments
6 min read
Oracle Database Performance Monitoring: A Practitioner's Decision Framework
damasosanoja profile

Oracle Database Performance Monitoring: A Practitioner's Decision Framework

#backend #database #monitoring #performance
Comments 1
20 min read
Fixing an email confirmation problem in Supabase
kansoldev profile

Fixing an email confirmation problem in Supabase

#database #learning #supabase
1
Comments
4 min read
Filtering, sorting, and pagination with the fluent query builder
davidlastrucci profile

Filtering, sorting, and pagination with the fluent query builder

#delphi #orm #database #opensource
Comments
3 min read
Using RPAD in GBase 8s: Syntax, Examples, and a Stored Procedure Hack
michaelfv profile

Using RPAD in GBase 8s: Syntax, Examples, and a Stored Procedure Hack

#gbase #database #数据库
2
Comments
2 min read
SQL vs NoSQL: Which one to choose for your next project?
geampiere profile

SQL vs NoSQL: Which one to choose for your next project?

#database #programming #productivity
Comments
3 min read
Redis Caching Strategies: What Actually Works in Production
sneha_wasankar profile

Redis Caching Strategies: What Actually Works in Production

#architecture #backend #database #performance
1
Comments
3 min read
Stop Writing Ugly SQL: A Developer's Guide to Clean, Readable Queries
99tools profile

Stop Writing Ugly SQL: A Developer's Guide to Clean, Readable Queries

#sql #database #webdev #productivity
8
Comments 2
6 min read
Stop Checking if Records Exist: Using UPSERT in Rust to Prevent Duplicate Data
manjushaps profile

Stop Checking if Records Exist: Using UPSERT in Rust to Prevent Duplicate Data

#rust #sqlx #database #beginners
Comments
1 min read
How We Built Sub-0.2ms Player Segmentation That Actually Works in Live Games
auxta profile

How We Built Sub-0.2ms Player Segmentation That Actually Works in Live Games

#gamedev #gamebackend #database
Comments
5 min read
C.A.P - The 3 Friends That Can’t Stay Together
theprinceofprogramming profile

C.A.P - The 3 Friends That Can’t Stay Together

#distributedsystems #fintech #backend #database
5
Comments 4
3 min read
Structuring the Database: Building an AI Task System [Floxis #2]
rina-park profile

Structuring the Database: Building an AI Task System [Floxis #2]

#webdev #database #softwareengineering #postgres
Comments
4 min read
Database Optimization Strategies That Cut Query Execution Time by 60%: A Practical Guide
oluwatosinolamilekan profile

Database Optimization Strategies That Cut Query Execution Time by 60%: A Practical Guide

#database #postgres #mysql #performance
1
Comments
9 min read
PostgreSQL Ecosystem Expands with ULAK Extension & Open-Source Xata; SQLite Vector Search Advances
soytuber profile
soy

PostgreSQL Ecosystem Expands with ULAK Extension & Open-Source Xata; SQLite Vector Search Advances

#database #sql #sqlite
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.