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.
Recuperando dados no Oracle com FlashBack Query

Recuperando dados no Oracle com FlashBack Query

Comments
3 min read
Part 2 - MySQL vs PostgreSQL: Storage Architecture

Part 2 - MySQL vs PostgreSQL: Storage Architecture

Comments
10 min read
Part 1 - MySQL vs PostgreSQL: Connection Architecture

Part 1 - MySQL vs PostgreSQL: Connection Architecture

Comments
7 min read
Data Engineering 101 - A real beginner's approach

Data Engineering 101 - A real beginner's approach

67
Comments 2
15 min read
Why Model-First and where the Truth lives

Why Model-First and where the Truth lives

Comments
7 min read
Database Basics: Introduction to PostgreSQL for Beginners

Database Basics: Introduction to PostgreSQL for Beginners

Comments
14 min read
Understanding ORDS Pre-Hook Functions

Understanding ORDS Pre-Hook Functions

Comments
2 min read
Concurrency and Transactions - Part 2

Concurrency and Transactions - Part 2

Comments
5 min read
Oracle 21c — Removal of IGNORECASE and SEC_CASE_SENSITIVE_LOGON Parameters

Oracle 21c — Removal of IGNORECASE and SEC_CASE_SENSITIVE_LOGON Parameters

Comments
2 min read
MongoDB Pagination: IXSCAN vs COLLSCAN and Building Efficient Page Bookmarks

MongoDB Pagination: IXSCAN vs COLLSCAN and Building Efficient Page Bookmarks

2
Comments
4 min read
MySQL Deadlock Detection: How to Find and Fix Transaction Conflicts

MySQL Deadlock Detection: How to Find and Fix Transaction Conflicts

5
Comments
8 min read
Building a Redis Clone in Zig—Part 1

Building a Redis Clone in Zig—Part 1

Comments
5 min read
October 12 iHateReading Letter

October 12 iHateReading Letter

Comments
3 min read
POO con BBDD #1

POO con BBDD #1

4
Comments
3 min read
Enhancing query languages

Enhancing query languages

3
Comments
4 min read
The Card Whisperer: Predicting Database Query Costs... Without Data by Arvind Sundararajan

The Card Whisperer: Predicting Database Query Costs... Without Data by Arvind Sundararajan

Comments
2 min read
An Introduction to Commonly Used PL/SQL Data Types

An Introduction to Commonly Used PL/SQL Data Types

Comments
4 min read
Beautify and Organize Your Queries Effortlessly with DevUtilX SQL Formatter 💡

Beautify and Organize Your Queries Effortlessly with DevUtilX SQL Formatter 💡

Comments
2 min read
Undo Redo Database Queries

Undo Redo Database Queries

Comments
25 min read
Sequelize, Postgresql column does not exist Fix

Sequelize, Postgresql column does not exist Fix

4
Comments
1 min read
Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table

Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table

Comments
18 min read
Query Anything with SQL: Your Developer's Deep Dive into Apache Drill

Query Anything with SQL: Your Developer's Deep Dive into Apache Drill

Comments
8 min read
SQL is King, But is it Your Only Ruler? A Developer's Guide to NoSQL

SQL is King, But is it Your Only Ruler? A Developer's Guide to NoSQL

1
Comments
7 min read
Why Do Data Pipelines Need Streaming — Isn’t Batch Processing Enough?

Why Do Data Pipelines Need Streaming — Isn’t Batch Processing Enough?

Comments
4 min read
🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨

🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨

Comments
3 min read
loading...