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.
5 SQL mistakes that return the wrong number with no error (reproduce each one in Postgres)

5 SQL mistakes that return the wrong number with no error (reproduce each one in Postgres)

2
Comments
4 min read
Our migration folder has 51 numbers, 50 files, 49 snapshots, and 289 lines of SQL the tool will never touch

Our migration folder has 51 numbers, 50 files, 49 snapshots, and 289 lines of SQL the tool will never touch

Comments
5 min read
WINDOW FUNCTIONS,JOINS,SUBQUERIES AND CTEs

WINDOW FUNCTIONS,JOINS,SUBQUERIES AND CTEs

Comments
5 min read
A Residue Report Is a Priced Work List: What Honest Oracle-to-PostgreSQL Conversion Looks Like

A Residue Report Is a Priced Work List: What Honest Oracle-to-PostgreSQL Conversion Looks Like

Comments
4 min read
The CDP Was Built for Campaigns. AI Needs Customer Memory.

The CDP Was Built for Campaigns. AI Needs Customer Memory.

1
Comments 1
4 min read
Building a context-aware support agent on MongoDB Atlas

Building a context-aware support agent on MongoDB Atlas

Comments
18 min read
How to Fix Epicor Kinetic BAQ Timeouts: PartTran, TranGLC & Query Tuning

How to Fix Epicor Kinetic BAQ Timeouts: PartTran, TranGLC & Query Tuning

Comments
5 min read
How I compute a "typical price" for 22,000 LEGO offers (and why shop discounts are mostly theatre)

How I compute a "typical price" for 22,000 LEGO offers (and why shop discounts are mostly theatre)

2
Comments
6 min read
How is your team actually handling "memory" for AI agents right now?

How is your team actually handling "memory" for AI agents right now?

Comments
1 min read
LioranDB v2 Alpha Is Here! 15+ Days in Production, 15K Ops/sec, and Our First Cloud Users

LioranDB v2 Alpha Is Here! 15+ Days in Production, 15K Ops/sec, and Our First Cloud Users

1
Comments
4 min read
Laravel Docker: Install Adminer with a MySQL or PostgreSQL Database

Laravel Docker: Install Adminer with a MySQL or PostgreSQL Database

2
Comments
4 min read
SQL Server INT to BIGINT Primary Key: Four Ways to Change It and What Each One Costs

SQL Server INT to BIGINT Primary Key: Four Ways to Change It and What Each One Costs

Comments
11 min read
DynamoDB with Lambda and CDK: Build a Guestbook API

DynamoDB with Lambda and CDK: Build a Guestbook API

Comments
20 min read
Dual Write Problem: Have you ever faced it?

Dual Write Problem: Have you ever faced it?

Comments
2 min read
PostgreSQL Commands – Step-by-Step Guide

PostgreSQL Commands – Step-by-Step Guide

Comments
1 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.