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.
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
A Quick Glance at Software Engineering and CI/CD

A Quick Glance at Software Engineering and CI/CD

Comments
1 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
🚀 Introducing Amazon Aurora DSQL: The Next Evolution in Databases 📊

🚀 Introducing Amazon Aurora DSQL: The Next Evolution in Databases 📊

13
Comments
4 min read
Why You Should Learn Entity Relationship Diagrams Before ORMs and Specific Databases

Why You Should Learn Entity Relationship Diagrams Before ORMs and Specific Databases

2
Comments 1
4 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
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
Top 8 Free Database Design Tools for 2025

Top 8 Free Database Design Tools for 2025

6
Comments
6 min read
Detecting and Analyzing Comment Quality Using Vector Search

Detecting and Analyzing Comment Quality Using Vector Search

22
Comments
6 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
Move Data from Oracle to ClickHouse in Minutes

Move Data from Oracle to ClickHouse in Minutes

Comments
4 min read
PostgreSQL CSV Import and Export Guide

PostgreSQL CSV Import and Export Guide

2
Comments
1 min read
Avoid SELECT *, even on a single-column tables

Avoid SELECT *, even on a single-column tables

1
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
Top 10 advanced-level questions | ORACLE PLSQL DEVELOPER

Top 10 advanced-level questions | ORACLE PLSQL DEVELOPER

5
Comments
3 min read
Query optimization techniques in Short | Best Explanation

Query optimization techniques in Short | Best Explanation

Comments
1 min read
Exploring new AWS Aurora DSQL. What is it ? Why it is important ? How to quickstart ?

Exploring new AWS Aurora DSQL. What is it ? Why it is important ? How to quickstart ?

4
Comments
4 min read
💡 Database Development: It’s Not Just About Querying!

💡 Database Development: It’s Not Just About Querying!

Comments
2 min read
Redis

Redis

Comments
1 min read
Database Indexing: A Comprehensive Guide for All Levels

Database Indexing: A Comprehensive Guide for All Levels

3
Comments
4 min read
Customer Support RAG Assistant

Customer Support RAG Assistant

Comments
1 min read
GBASE数据库 | GBase 8c Enterprise Database Feature: Compatibility

GBASE数据库 | GBase 8c Enterprise Database Feature: Compatibility

Comments
4 min read
What you should know about CIDR in clear terms

What you should know about CIDR in clear terms

Comments
3 min read
Code Archeologist: AI-Powered Git Repository Analysis with PostgreSQL

Code Archeologist: AI-Powered Git Repository Analysis with PostgreSQL

Comments
4 min read
Reset autoincrement sequences for IDs in Django application after all instances are deleted (PostgreSQL)

Reset autoincrement sequences for IDs in Django application after all instances are deleted (PostgreSQL)

Comments
1 min read
GBASE数据库 | Introduction to GBase 8a Cluster Transparent Gateway and DBLINK Usage

GBASE数据库 | Introduction to GBase 8a Cluster Transparent Gateway and DBLINK Usage

5
Comments
15 min read
open-contribution

open-contribution

Comments
1 min read
DSQL Part 2 – More Rust and a Momento Cache

DSQL Part 2 – More Rust and a Momento Cache

9
Comments
17 min read
Automating EC2 Instance and Tag Management with AWS SDK and PostgreSQL

Automating EC2 Instance and Tag Management with AWS SDK and PostgreSQL

5
Comments
4 min read
Buddy Fit: The Ultimate AI Weightlifting Companion Powered by Dr. Mike Israetel and Jeff Nippard

Buddy Fit: The Ultimate AI Weightlifting Companion Powered by Dr. Mike Israetel and Jeff Nippard

Comments
6 min read
StarSense - new way of interacting with repos

StarSense - new way of interacting with repos

Comments
2 min read
Web3 explained for Web2 Developers: My Personal Journey from SQL to Solana

Web3 explained for Web2 Developers: My Personal Journey from SQL to Solana

10
Comments 2
7 min read
Database Sharding: Simplifying Data Scalability

Database Sharding: Simplifying Data Scalability

Comments
7 min read
Demystifying Relational Databases

Demystifying Relational Databases

6
Comments
3 min read
Data Pipeline Filters 101: Choosing Between Static and Dynamic Approaches

Data Pipeline Filters 101: Choosing Between Static and Dynamic Approaches

Comments
1 min read
Making the Ivorian Labor Code Accessible and Understandable through the RAG System

Making the Ivorian Labor Code Accessible and Understandable through the RAG System

Comments
2 min read
Unlocking DuckDB from Anywhere - A Guide to Remote Access with Apache Arrow and Flight RPC (gRPC)

Unlocking DuckDB from Anywhere - A Guide to Remote Access with Apache Arrow and Flight RPC (gRPC)

3
Comments
7 min read
Data integrity in Ably Pub/Sub

Data integrity in Ably Pub/Sub

1
Comments
5 min read
How I Went From Being a DBA to DevOps Engineer

How I Went From Being a DBA to DevOps Engineer

Comments
1 min read
Mastering MySQL's Query Cache: Key Variables and Best Practices for Optimization

Mastering MySQL's Query Cache: Key Variables and Best Practices for Optimization

2
Comments
8 min read
DynamoDB-style Limits for Predictable SQL Performance?

DynamoDB-style Limits for Predictable SQL Performance?

15
Comments 2
6 min read
SQL - table assistant

SQL - table assistant

3
Comments
2 min read
Everyone Uses Postgres… But Why?

Everyone Uses Postgres… But Why?

1
Comments
9 min read
JOINs (not just JSONs) can help

JOINs (not just JSONs) can help

Comments
2 min read
Doctrine’s Collection filter method - a double-edged sword

Doctrine’s Collection filter method - a double-edged sword

1
Comments
5 min read
ACID Properties in Databases - Part 2: Your Shield Against Transactional Chaos

ACID Properties in Databases - Part 2: Your Shield Against Transactional Chaos

8
Comments
5 min read
What is Database Normalization- With an Example

What is Database Normalization- With an Example

4
Comments
3 min read
Rust Fullstack - Ollama: RepStar

Rust Fullstack - Ollama: RepStar

Comments
2 min read
🔧 Embed SQL Editor ✍️ in Your Internal Web Portal 💻

🔧 Embed SQL Editor ✍️ in Your Internal Web Portal 💻

13
Comments
5 min read
GBASE数据库 | GBase 8s RHAC Cluster Basic Principles and Setup Steps

GBASE数据库 | GBase 8s RHAC Cluster Basic Principles and Setup Steps

Comments
9 min read
Provide private storage for internal company documents

Provide private storage for internal company documents

Comments
5 min read
loading...