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.
🕵️ OSINT: link company acronyms to Standard Occupation Classification w. Open Source LLMs

🕵️ OSINT: link company acronyms to Standard Occupation Classification w. Open Source LLMs

Comments 4
5 min read
Mastering Data Cleaning: Your Guide to a Cleaner, Reliable Dataset 🚀

Mastering Data Cleaning: Your Guide to a Cleaner, Reliable Dataset 🚀

10
Comments
4 min read
No Gap Ordered Numbering in SQL: A Unique Index to Serialize In Read Committed

No Gap Ordered Numbering in SQL: A Unique Index to Serialize In Read Committed

Comments
2 min read
Laravel Custom Query Builders Over Scopes

Laravel Custom Query Builders Over Scopes

Comments
3 min read
Garantindo a Integridade de Dados em Transações Financeiras: A Solução com Transações no PostgreSQL

Garantindo a Integridade de Dados em Transações Financeiras: A Solução com Transações no PostgreSQL

Comments
4 min read
Database Indexing Explained

Database Indexing Explained

Comments
4 min read
10 Future Apache Iceberg Developments to Look forward to in 2025

10 Future Apache Iceberg Developments to Look forward to in 2025

Comments
13 min read
Why DB Migration Versioning when we have GIT?

Why DB Migration Versioning when we have GIT?

Comments
5 min read
Aurora Limitless - Single and Multi-Shard Scan

Aurora Limitless - Single and Multi-Shard Scan

1
Comments
5 min read
Statement Level Trigger vs Row Level Trigger

Statement Level Trigger vs Row Level Trigger

Comments
2 min read
The Comprehensive Guide to Databases and Their Major Uses in Application Software

The Comprehensive Guide to Databases and Their Major Uses in Application Software

Comments
7 min read
What is Real-Time Data Processing?

What is Real-Time Data Processing?

Comments
7 min read
How to Install PostgreSQL on Ubuntu 22.04 LTS

How to Install PostgreSQL on Ubuntu 22.04 LTS

2
Comments
10 min read
Why is Hamiltonian graph?

Why is Hamiltonian graph?

Comments
2 min read
🇩🇪 Datenmanipulation und Abfragen mit SQL

🇩🇪 Datenmanipulation und Abfragen mit SQL

Comments
8 min read
Aurora Limitless - Connection

Aurora Limitless - Connection

1
Comments
4 min read
PostgreSQL - low_cal_3

PostgreSQL - low_cal_3

Comments
1 min read
A Critical Performance Issue Led Me to Discover EchoAPI's Load Testing

A Critical Performance Issue Led Me to Discover EchoAPI's Load Testing

Comments
5 min read
lowCalProj Update 1

lowCalProj Update 1

Comments
1 min read
Transaction Safety in Rails: Identifying and Addressing Non-Atomic Interactions

Transaction Safety in Rails: Identifying and Addressing Non-Atomic Interactions

1
Comments
4 min read
MySQL Not Responding? A Simple Guide to Diagnosing and Fixing It

MySQL Not Responding? A Simple Guide to Diagnosing and Fixing It

Comments
6 min read
Resolving MongoDB Error When Starting with Homebrew on macOS

Resolving MongoDB Error When Starting with Homebrew on macOS

Comments
2 min read
GBASE数据库 | GBase 8c Compatibility Analysis with Distributed Databases

GBASE数据库 | GBase 8c Compatibility Analysis with Distributed Databases

1
Comments
3 min read
GBASE数据库 | GBase 8c Compatibility Analysis with Distributed Databases

GBASE数据库 | GBase 8c Compatibility Analysis with Distributed Databases

1
Comments
3 min read
GBASE数据库 | GBase 8c Compatibility Analysis with Distributed Databases

GBASE数据库 | GBase 8c Compatibility Analysis with Distributed Databases

1
Comments
3 min read
Git. Universary DB

Git. Universary DB

1
Comments
1 min read
Aurora Limitless - Sharded Table

Aurora Limitless - Sharded Table

2
Comments
9 min read
Docker configurations for relational and non-relational databases

Docker configurations for relational and non-relational databases

Comments
1 min read
04. தரவு ஒருங்கிணைவு (Data Integrity)

04. தரவு ஒருங்கிணைவு (Data Integrity)

Comments
1 min read
03. ரிலேஷனல் டேட்டாபேஸ் மாடல் என்றால் என்ன? What is Relational Database Model ? (RDBMS)

03. ரிலேஷனல் டேட்டாபேஸ் மாடல் என்றால் என்ன? What is Relational Database Model ? (RDBMS)

Comments
1 min read
3 Hot Trends In Database Reliability

3 Hot Trends In Database Reliability

Comments
4 min read
Amazon Redshift now supports refresh interval in a zero-ETL integration

Amazon Redshift now supports refresh interval in a zero-ETL integration

1
Comments
2 min read
The Most Common Types of Databases in IT Today

The Most Common Types of Databases in IT Today

Comments
8 min read
02. DBMS என்றால் என்ன? What is a DBMS?

02. DBMS என்றால் என்ன? What is a DBMS?

Comments 2
2 min read
為什麼資料庫顯示亂碼?深入探討 Latin1 與 Windows-1252 的編碼衝突

為什麼資料庫顯示亂碼?深入探討 Latin1 與 Windows-1252 的編碼衝突

Comments
1 min read
A Quick Glance at Software Engineering and CI/CD

A Quick Glance at Software Engineering and CI/CD

Comments
1 min read
What do 200 electrocuted monks have to do with Redis 8, the fastest Redis ever?

What do 200 electrocuted monks have to do with Redis 8, the fastest Redis ever?

Comments
4 min read
GBASE数据库 | GBase 8a MPP Cluster Cold-Warm-Hot Data Analysis Based on Audit Logs

GBASE数据库 | GBase 8a MPP Cluster Cold-Warm-Hot Data Analysis Based on Audit Logs

Comments
5 min read
GBASE数据库 | GBase 8a MPP Cluster Cold-Warm-Hot Data Analysis Based on Audit Logs

GBASE数据库 | GBase 8a MPP Cluster Cold-Warm-Hot Data Analysis Based on Audit Logs

Comments
5 min read
GBASE数据库 | GBase 8a MPP Cluster Cold-Warm-Hot Data Analysis Based on Audit Logs

GBASE数据库 | GBase 8a MPP Cluster Cold-Warm-Hot Data Analysis Based on Audit Logs

Comments
5 min read
Beyond LIKE: Advanced Text Search and Keyword Matching in Postgres using Full Text Search

Beyond LIKE: Advanced Text Search and Keyword Matching in Postgres using Full Text Search

2
Comments
4 min read
When and Why to Use JSON Columns in SQL Databases

When and Why to Use JSON Columns in SQL Databases

Comments
3 min read
Compound Trigger in Oracle SQL

Compound Trigger in Oracle SQL

Comments
3 min read
Solution for "DLL Load Failed Due to Absence of Wheel for sqlcipher3" Error

Solution for "DLL Load Failed Due to Absence of Wheel for sqlcipher3" Error

Comments
3 min read
ACID Properties in Databases: A Key to Data Integrity and Reliability

ACID Properties in Databases: A Key to Data Integrity and Reliability

Comments
4 min read
Unleash the Power of Data: The Hottest AWS Database Trends of 2024

Unleash the Power of Data: The Hottest AWS Database Trends of 2024

Comments
5 min read
Deep Dive into Dremio's File-based Auto Ingestion into Apache Iceberg Tables

Deep Dive into Dremio's File-based Auto Ingestion into Apache Iceberg Tables

Comments
13 min read
Effective Strategies for Writing Unit Tests with External Dependencies like Databases and APIs

Effective Strategies for Writing Unit Tests with External Dependencies like Databases and APIs

Comments
7 min read
SQL Window functions: Understanding PARTITION BY

SQL Window functions: Understanding PARTITION BY

1
Comments
5 min read
Interview Questions | 10 most important distinctions between concepts in Oracle SQL

Interview Questions | 10 most important distinctions between concepts in Oracle SQL

Comments
2 min read
Connecting SQL Databases to the Cloud: PostgreSQL, MySQL, SQLite, and Cloud Integration Explained

Connecting SQL Databases to the Cloud: PostgreSQL, MySQL, SQLite, and Cloud Integration Explained

Comments
7 min read
CouchDB’s Favourite File Systems

CouchDB’s Favourite File Systems

Comments
3 min read
Move Data from Oracle to ClickHouse in Minutes

Move Data from Oracle to ClickHouse in Minutes

Comments
4 min read
GBase数据库 | Understanding Cursor Variables in GBase 8s: Enhancing Database Operation Efficiency

GBase数据库 | Understanding Cursor Variables in GBase 8s: Enhancing Database Operation Efficiency

Comments
3 min read
GBase 数据库 | GBase 8a MPP Cluster Automatic Log Cleanup Implementation

GBase 数据库 | GBase 8a MPP Cluster Automatic Log Cleanup Implementation

Comments
2 min read
Three Tier Architecture. Overview and Each tier explained.

Three Tier Architecture. Overview and Each tier explained.

Comments
6 min read
How to Execute a SQL Statement on a Different Type of Database #eg74

How to Execute a SQL Statement on a Different Type of Database #eg74

6
Comments
1 min read
Using GenAI to Tackle Complex Prisma Model Migrations

Using GenAI to Tackle Complex Prisma Model Migrations

1
Comments 1
2 min read
Looking at How Replit Agent Handles Databases

Looking at How Replit Agent Handles Databases

Comments
7 min read
Top 10 advanced-level questions | ORACLE PLSQL DEVELOPER

Top 10 advanced-level questions | ORACLE PLSQL DEVELOPER

5
Comments
3 min read
loading...