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.
Count Distinct within Intervals in Order — From SQL to SPL #38

Count Distinct within Intervals in Order — From SQL to SPL #38

6
Comments 2
2 min read
Top Free ER Diagram Tools for PostgreSQL in 2025

Top Free ER Diagram Tools for PostgreSQL in 2025

11
Comments 1
7 min read
SQL Commands

SQL Commands

Comments
2 min read
Optimistic Locking & Pessimistic Locking

Optimistic Locking & Pessimistic Locking

1
Comments
2 min read
đź’ˇ Mastering SQL Query Optimization: Tips Every Backend Developer Should Know

đź’ˇ Mastering SQL Query Optimization: Tips Every Backend Developer Should Know

Comments
3 min read
đź§© When to Use NoSQL and SQL?

đź§© When to Use NoSQL and SQL?

5
Comments
2 min read
Understanding the PostgreSQL Crosstab Function

Understanding the PostgreSQL Crosstab Function

3
Comments
4 min read
Mastering the Uniface Edit Statement: A Developer's Guide 🚀

Mastering the Uniface Edit Statement: A Developer's Guide 🚀

Comments
2 min read
Understanding the Uniface Display Statement: Creating Read-Only Forms đź“–

Understanding the Uniface Display Statement: Creating Read-Only Forms đź“–

Comments
2 min read
🎯 Mastering Uniface's `discard` Statement: Memory Management in Batch Operations

🎯 Mastering Uniface's `discard` Statement: Memory Management in Batch Operations

Comments
2 min read
🔄 Mastering Database Transactions in Uniface: The commit Statement Explained

🔄 Mastering Database Transactions in Uniface: The commit Statement Explained

Comments
2 min read
🔍 Mastering Uniface's Compare Statement: A Developer's Guide

🔍 Mastering Uniface's Compare Statement: A Developer's Guide

Comments
2 min read
Understanding Uniface componentToStruct: Converting Component Data to Structures 🚀

Understanding Uniface componentToStruct: Converting Component Data to Structures 🚀

Comments
2 min read
Uniface 10.4: The blockdata Statement - Elegant Multi-line Text Definition

Uniface 10.4: The blockdata Statement - Elegant Multi-line Text Definition

Comments
2 min read
Weekly #28-2025: Git Mastery, Algorithms, Why are there So many Databases, AI Agents & Prompting

Weekly #28-2025: Git Mastery, Algorithms, Why are there So many Databases, AI Agents & Prompting

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