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.
SQL Complete guide for Interview

SQL Complete guide for Interview

57
Comments 7
13 min read
BigQuery's New JSON Functions: Struct vs. JSON - Choosing the Right Structure

BigQuery's New JSON Functions: Struct vs. JSON - Choosing the Right Structure

1
Comments
3 min read
How to Effectively Use the ALL Keyword in SQL Server Queries

How to Effectively Use the ALL Keyword in SQL Server Queries

Comments
6 min read
Automating Database Health Checks with Python: A Step-by-Step Guide

Automating Database Health Checks with Python: A Step-by-Step Guide

8
Comments
6 min read
Data Orientation in Relational Databases

Data Orientation in Relational Databases

Comments
2 min read
How to Check Fragmentation in an Oracle Database

How to Check Fragmentation in an Oracle Database

4
Comments
4 min read
GBase Database Cluster Monitoring

GBase Database Cluster Monitoring

Comments
4 min read
GBase 8c Compatibility with MySQL Syntax and Modifications

GBase 8c Compatibility with MySQL Syntax and Modifications

Comments
3 min read
Monitoring and Managing AWS RDS Snapshot Storage Across All Regions

Monitoring and Managing AWS RDS Snapshot Storage Across All Regions

1
Comments
3 min read
Neon Scaffolder

Neon Scaffolder

20
Comments 2
3 min read
GBase 8s Database HAC Cluster Switch and Recovery Operations

GBase 8s Database HAC Cluster Switch and Recovery Operations

1
Comments
2 min read
Open-Source Database Designs: Powered by AI

Open-Source Database Designs: Powered by AI

1
Comments
2 min read
Ma Première ExpÊrience avec SQL Server et T-SQL : CrÊation d'une Base de DonnÊes pour une Bibliothèque

Ma Première ExpÊrience avec SQL Server et T-SQL : CrÊation d'une Base de DonnÊes pour une Bibliothèque

Comments
5 min read
SQL Server: How to Use the ADD Keyword for Schema Changes

SQL Server: How to Use the ADD Keyword for Schema Changes

Comments
3 min read
Build your own SQLite, Part 2: Scanning large tables

Build your own SQLite, Part 2: Scanning large tables

2
Comments
7 min read
Exploring New Features in PostgreSQL 17 with Python

Exploring New Features in PostgreSQL 17 with Python

2
Comments 1
3 min read
Basic MySQL Queries: A Comprehensive Guide

Basic MySQL Queries: A Comprehensive Guide

7
Comments
4 min read
Database Indexing Explained: Why It's Like a Book's Table of Contents

Database Indexing Explained: Why It's Like a Book's Table of Contents

Comments
3 min read
Receipt of Deceit: A Tale of Unencrypted RDS Database Blunders and Why You Should Encrypt Data-in-Transit

Receipt of Deceit: A Tale of Unencrypted RDS Database Blunders and Why You Should Encrypt Data-in-Transit

1
Comments
4 min read
Mastering Backend Development with NodeJS: MongoDB Integration, Mongoose, CRUD Operations, and MVC Architecture

Mastering Backend Development with NodeJS: MongoDB Integration, Mongoose, CRUD Operations, and MVC Architecture

Comments
5 min read
Supabase Realtime: Broadcast and Presence Authorization

Supabase Realtime: Broadcast and Presence Authorization

50
Comments
5 min read
Why Data Replication is Important

Why Data Replication is Important

Comments
8 min read
From Data to Forecast: The Essential Role of Weather Stations

From Data to Forecast: The Essential Role of Weather Stations

Comments 1
4 min read
How to Build a Data Analysis Tool (Quick & Easy Guide)

How to Build a Data Analysis Tool (Quick & Easy Guide)

Comments
20 min read
Jarvis, gÊnère moi un schÊma de base de donnÊes

Jarvis, gÊnère moi un schÊma de base de donnÊes

1
Comments
5 min read
A Comparative Analysis of Five Mainstream Database Connection Pools

A Comparative Analysis of Five Mainstream Database Connection Pools

Comments
2 min read
High Availability Solution for GBase 8a Based on Rose HA

High Availability Solution for GBase 8a Based on Rose HA

Comments
6 min read
Comparing DataSpaces and Cloud

Comparing DataSpaces and Cloud

Comments
8 min read
GBase 8s HAC Cluster Deployment Guide (2)

GBase 8s HAC Cluster Deployment Guide (2)

Comments
5 min read
Using wal2json Logical Replication Slot in GBase 8c

Using wal2json Logical Replication Slot in GBase 8c

Comments
2 min read
Implementing “Get or Create” in YugabyteDB (or PostgreSQL)

Implementing “Get or Create” in YugabyteDB (or PostgreSQL)

2
Comments
11 min read
Complete Tutorial: Setting up email sending on OCI Free Tier with Oracle APEX on Autonomous Database

Complete Tutorial: Setting up email sending on OCI Free Tier with Oracle APEX on Autonomous Database

1
Comments 5
6 min read
How to Store Vibration Sensor Data | ReductStore vs InfluxDB

How to Store Vibration Sensor Data | ReductStore vs InfluxDB

15
Comments
8 min read
The Developer’s Guide to Real-Time Data Platforms!

The Developer’s Guide to Real-Time Data Platforms!

9
Comments
6 min read
Understanding Apache Iceberg's metadata.json file

Understanding Apache Iceberg's metadata.json file

4
Comments
7 min read
🌐 Get started: What is MongoDB operational data layer? (Part 2) 🌐

🌐 Get started: What is MongoDB operational data layer? (Part 2) 🌐

5
Comments
2 min read
🌐 开始使用: MongoDB Operational Data Layer 是什么? (第1部分)

🌐 开始使用: MongoDB Operational Data Layer 是什么? (第1部分)

5
Comments
1 min read
Advanced Transact-SQL (T-SQL) Queries

Advanced Transact-SQL (T-SQL) Queries

1
Comments
3 min read
Databases in Plang

Databases in Plang

Comments
2 min read
Cast for type conversion in SQL

Cast for type conversion in SQL

1
Comments
2 min read
Multi-Leader Replication

Multi-Leader Replication

Comments
1 min read
Data Load High Availability Case - Log Management System Configuration Manual

Data Load High Availability Case - Log Management System Configuration Manual

Comments
6 min read
GBase 8c Compatibility - Oracle Partition Syntax

GBase 8c Compatibility - Oracle Partition Syntax

Comments
3 min read
Calculating Fingerprints For SQL Queries

Calculating Fingerprints For SQL Queries

Comments
4 min read
Creating cloud, provisioning database and dbeaver and connect it to code quickly

Creating cloud, provisioning database and dbeaver and connect it to code quickly

Comments
2 min read
Data API for Amazon Aurora Serverless v2 with AWS SDK for Java - Part 9 Comparing cold and warm starts: Data API vs DynamoDB

Data API for Amazon Aurora Serverless v2 with AWS SDK for Java - Part 9 Comparing cold and warm starts: Data API vs DynamoDB

1
Comments
3 min read
Relational vs Non-Relational Databases: Key Differences You Need to Know

Relational vs Non-Relational Databases: Key Differences You Need to Know

Comments
2 min read
One Minute: DuckDB

One Minute: DuckDB

1
Comments
1 min read
Effective Real-Time Database Monitoring with Supabase and PostgreSQL: A Guide to Minimizing Overhead and Managing I/O

Effective Real-Time Database Monitoring with Supabase and PostgreSQL: A Guide to Minimizing Overhead and Managing I/O

4
Comments
11 min read
Overview of Network Interactions in GBase 8s SSC Clusters (2)

Overview of Network Interactions in GBase 8s SSC Clusters (2)

Comments
4 min read
🦆 💏 🐘 Let PostgreSQL & duckdb "sql" together

🦆 💏 🐘 Let PostgreSQL & duckdb "sql" together

2
Comments 2
3 min read
Mastering MySQL: Key Performance Metrics Every Developer Should Monitor

Mastering MySQL: Key Performance Metrics Every Developer Should Monitor

5
Comments 2
7 min read
Tips for Working with Complex Normalized Databases

Tips for Working with Complex Normalized Databases

Comments
15 min read
Understanding The ‘AND’ Keyword In SQL Server

Understanding The ‘AND’ Keyword In SQL Server

1
Comments
5 min read
ArrayList a simple List DB

ArrayList a simple List DB

1
Comments
1 min read
Understanding Data Normalization and Database Design Principles

Understanding Data Normalization and Database Design Principles

1
Comments
2 min read
Overview of GBase 8s SSC Cluster Network Interaction (1)

Overview of GBase 8s SSC Cluster Network Interaction (1)

Comments
6 min read
Introduction to High Availability in GBase 8a

Introduction to High Availability in GBase 8a

Comments
3 min read
GBase 8c: Compatibility and High-Performance Distributed Database

GBase 8c: Compatibility and High-Performance Distributed Database

Comments
3 min read
Top 10 Affordable Options To Host Your PostgreSQL Database

Top 10 Affordable Options To Host Your PostgreSQL Database

3
Comments 1
7 min read
loading...