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.
From object graph to query

From object graph to query

2
Comments
2 min read
Demystifying Uniface: A Simple Guide to the $totkeys Function ✨

Demystifying Uniface: A Simple Guide to the $totkeys Function ✨

Comments
2 min read
How to Data Engineer the ETLFunnel Way

How to Data Engineer the ETLFunnel Way

Comments
5 min read
How to Data Engineer the ETLFunnel Way

How to Data Engineer the ETLFunnel Way

Comments
5 min read
How to Data Engineer the ETLFunnel Way

How to Data Engineer the ETLFunnel Way

Comments
3 min read
Schema Design with Supabase: Partitioning and Normalization

Schema Design with Supabase: Partitioning and Normalization

Comments
5 min read
Understanding the Difference Between Subquery, CTE, and Stored Procedure

Understanding the Difference Between Subquery, CTE, and Stored Procedure

Comments
3 min read
🔫Why You Suck at Structuring Data And How to Finally Get Better 💪

🔫Why You Suck at Structuring Data And How to Finally Get Better 💪

4
Comments
3 min read
CRUD Operations in MongoDB — Student Management System

CRUD Operations in MongoDB — Student Management System

Comments
2 min read
🚀 Understanding Indexing in Oracle (B-Tree, B+ Tree, Hash Cluster) Indexes are one of the most important concepts in databases.

🚀 Understanding Indexing in Oracle (B-Tree, B+ Tree, Hash Cluster) Indexes are one of the most important concepts in databases.

Comments
3 min read
💾 ACID Properties

💾 ACID Properties

Comments
2 min read
Guide to Seamless Data Security in Rails With Mongoid’s Automatic Encryption

Guide to Seamless Data Security in Rails With Mongoid’s Automatic Encryption

1
Comments
6 min read
📝 Understanding Transactions, Deadlocks & Log-Based Recovery in SQL 💾

📝 Understanding Transactions, Deadlocks & Log-Based Recovery in SQL 💾

1
Comments
2 min read
Similarities Between a Stored Procedure in SQL and a Function in Python

Similarities Between a Stored Procedure in SQL and a Function in Python

Comments
3 min read
CRUD (Create, Read, Update, Delete) operations in MongoDB using a simple college student schema.

CRUD (Create, Read, Update, Delete) operations in MongoDB using a simple college student schema.

Comments
2 min read
Effortless PostgreSQL Environment in Docker For Windows

Effortless PostgreSQL Environment in Docker For Windows

Comments
5 min read
Role Based Access Control in SeaORM 2.0

Role Based Access Control in SeaORM 2.0

1
Comments
9 min read
Understanding PL/SQL Collections: Associative Arrays, Nested Tables, and VARRAYs

Understanding PL/SQL Collections: Associative Arrays, Nested Tables, and VARRAYs

1
Comments
3 min read
Working with Hibernate in Java - Part 1: Using xml config

Working with Hibernate in Java - Part 1: Using xml config

4
Comments
3 min read
From Postgres to Iceberg

From Postgres to Iceberg

1
Comments
11 min read
How We Used DBtune to Cut Our Postgres Query Time by 50% on AWS RDS

How We Used DBtune to Cut Our Postgres Query Time by 50% on AWS RDS

2
Comments
9 min read
AWS Database Savings Plans – Save Up to 35% – FINALLY!

AWS Database Savings Plans – Save Up to 35% – FINALLY!

3
Comments 2
5 min read
A Practical Guide to Kubernetes Stateful Backup and Recovery

A Practical Guide to Kubernetes Stateful Backup and Recovery

1
Comments 1
5 min read
9 Launches from re:Invent Season I'm Excited About (so far!)

9 Launches from re:Invent Season I'm Excited About (so far!)

118
Comments 1
2 min read
handle text

handle text

Comments
1 min read
loading...