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.
IFNULL vs NULLIF in GBase 8a: Why They Are Not Interchangeable
michaelfv profile

IFNULL vs NULLIF in GBase 8a: Why They Are Not Interchangeable

#gbase #database #数据库
2
Comments
1 min read
Troubleshooting Table Locks in GBase 8s: Find and Release Exclusive Locks Fast
michaelfv profile

Troubleshooting Table Locks in GBase 8s: Find and Release Exclusive Locks Fast

#gbase #database #数据库 #onstat
2
Comments
2 min read
Desvendando a Arquitetura: Frontend, Backend e Banco de Dados na Prática
kabrau profile

Desvendando a Arquitetura: Frontend, Backend e Banco de Dados na Prática

#ai #backend #frontend #database
Comments
3 min read
JPA: The Good, The Bad, and The Ugly
stephenflavin profile

JPA: The Good, The Bad, and The Ugly

#java #jpa #spring #database
Comments
17 min read
Beyond Basics: Mastering SQL's LEAD, LAG, RANK, DENSE_RANK, and NTILE
vivekdraxlr profile

Beyond Basics: Mastering SQL's LEAD, LAG, RANK, DENSE_RANK, and NTILE

#sql #database #postgres #analytics
Comments
6 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
3
Comments 3
6 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
1
Comments
6 min read
Inner vs Outer Joins: The Two Fundamental Join Types in SQL
michaelfv profile

Inner vs Outer Joins: The Two Fundamental Join Types in SQL

#gbase #database #数据库 #sql
2
Comments
1 min read
The 10 Best AI Memory Layers for Agents in 2026
jonathanfarrow profile

The 10 Best AI Memory Layers for Agents in 2026

#agents #ai #database #llm
1
Comments
7 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
Using Chinese Identifiers in GBase 8a: The gcluster_extend_ident Parameter
michaelfv profile

Using Chinese Identifiers in GBase 8a: The gcluster_extend_ident Parameter

#gbase #database #数据库 #parameter
2
Comments
2 min read
PostgreSQL Plan Signatures: Quick Reference
philip_mcclarence_2ef9475 profile

PostgreSQL Plan Signatures: Quick Reference

#database #performance #postgres #sql
Comments
7 min read
Provisioning PostgresSQL RDBMS on AWS with Terraform
vvasylkovskyi profile

Provisioning PostgresSQL RDBMS on AWS with Terraform

#aws #database #postgres #terraform
Comments
5 min read
Why Supavisor 1.0 Is Written in Elixir (And Why That's Actually a Brilliant Move)
dev-arafat-alim profile

Why Supavisor 1.0 Is Written in Elixir (And Why That's Actually a Brilliant Move)

#architecture #database #infrastructure #postgres
Comments
9 min read
Three months of running a Next.js aggregator on a CSV: what broke and what did not,
sweepbase profile

Three months of running a Next.js aggregator on a CSV: what broke and what did not,

#architecture #database #nextjs #sideprojects
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.