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.
Your leaderboard is ranking luck: 3,736 models, 46,284 graded calls, and a split-half correlation of 0.04

Your leaderboard is ranking luck: 3,736 models, 46,284 graded calls, and a split-half correlation of 0.04

Comments
7 min read
Building a headless ERP: one codebase, a database per client

Building a headless ERP: one codebase, a database per client

Comments
4 min read
How to Verify Oracle Database 19c Release Update Patching in CDB and PDB Environments

How to Verify Oracle Database 19c Release Update Patching in CDB and PDB Environments

Comments
9 min read
SQL Server Statistics Explained: Why Your Query Plans Go Wrong

SQL Server Statistics Explained: Why Your Query Plans Go Wrong

Comments
3 min read
Modelling KEBS S-Mark Permits in an ERP: Product-Brand-Site Scope, Expiry Alerts and Label Validation

Modelling KEBS S-Mark Permits in an ERP: Product-Brand-Site Scope, Expiry Alerts and Label Validation

Comments
12 min read
Querying 7,636 Small Music Venues Under 500 Capacity: Schema, Pay Data and Corridor Routing

Querying 7,636 Small Music Venues Under 500 Capacity: Schema, Pay Data and Corridor Routing

Comments
5 min read
SmartInventory

SmartInventory

Comments
8 min read
Troubleshooting Cost: Three Classes of GBase Database(GBase 8c) Installation Failures

Troubleshooting Cost: Three Classes of GBase Database(GBase 8c) Installation Failures

2
Comments
4 min read
Port Already in Use: How to Locate and Resolve Port Conflicts in GBase Database(GBase 8c)

Port Already in Use: How to Locate and Resolve Port Conflicts in GBase Database(GBase 8c)

2
Comments
4 min read
Version Mismatch and Architecture Mix-ups: Pre-Install Checks for GBase Database(GBase 8c)

Version Mismatch and Architecture Mix-ups: Pre-Install Checks for GBase Database(GBase 8c)

2
Comments
3 min read
Evaluating Event Sourcing: Balancing Production Trade-Offs and Operational Complexity Against Theoretical Benefits

Evaluating Event Sourcing: Balancing Production Trade-Offs and Operational Complexity Against Theoretical Benefits

Comments
9 min read
I built an SSTable storage engine

I built an SSTable storage engine

Comments
15 min read
Postgres to Redshift: A CDC Walkthrough That Ends in One External Schema

Postgres to Redshift: A CDC Walkthrough That Ends in One External Schema

Comments
12 min read
Getting PostgreSQL ready for Black Friday: a SQL-first checklist

Getting PostgreSQL ready for Black Friday: a SQL-first checklist

Comments
25 min read
A Full Table Scan Isn’t Always a Mistake

A Full Table Scan Isn’t Always a Mistake

Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.