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.
Seed Data Without a Dependency Tree: A Tiny PHP CLI Instead of Faker
sendotltd profile

Seed Data Without a Dependency Tree: A Tiny PHP CLI Instead of Faker

#php #cli #database #tutorial
Comments
10 min read
Secure Database Access for AI Agents: Building an MCP Server with SQLatte
osmanuygar profile

Secure Database Access for AI Agents: Building an MCP Server with SQLatte

#ai #mcp #database #security
2
Comments 3
6 min read
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
PostgreSQL Slow Query Log: Finding & Fixing Your Slowest Queries
philip_mcclarence_2ef9475 profile

PostgreSQL Slow Query Log: Finding & Fixing Your Slowest Queries

#database #monitoring #performance #postgres
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
Fixing an email confirmation problem in Supabase
kansoldev profile

Fixing an email confirmation problem in Supabase

#database #learning #supabase
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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.