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.
# How to Connect Power BI to PostgreSQL: Local and Aiven Cloud Setup

# How to Connect Power BI to PostgreSQL: Local and Aiven Cloud Setup

Comments
3 min read
How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)

How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)

Comments
2 min read
Scaling SQLite with Node worker threads and better-sqlite3

Scaling SQLite with Node worker threads and better-sqlite3

26
Comments
8 min read
Secrets to Smarter Architecture: AI's Role in 2025 Decisions

Secrets to Smarter Architecture: AI's Role in 2025 Decisions

Comments
6 min read
Day 20 : Django Learning

Day 20 : Django Learning

Comments
1 min read
AlloyDB Agentic RAG Application with MCP Toolbox [Part 2]

AlloyDB Agentic RAG Application with MCP Toolbox [Part 2]

10
Comments
13 min read
Database Center from Google Cloud — The “Virtual DBA” You Didn’t Know You Hired

Database Center from Google Cloud — The “Virtual DBA” You Didn’t Know You Hired

29
Comments
3 min read
Mastering SQL: Revisiting the Basics

Mastering SQL: Revisiting the Basics

Comments
3 min read
Quick Recap: NoSQL Databases

Quick Recap: NoSQL Databases

Comments
2 min read
Bitnami MySQL Docker Image Tags Deleted

Bitnami MySQL Docker Image Tags Deleted

Comments
2 min read
Building Real-Time Lakehouse with S3 Tables, AWS Glue, and Apache Doris

Building Real-Time Lakehouse with S3 Tables, AWS Glue, and Apache Doris

Comments
3 min read
Quick Recap: Elasticsearch & Lucene

Quick Recap: Elasticsearch & Lucene

Comments
2 min read
Why You Should Use a Database In Your Projects!

Why You Should Use a Database In Your Projects!

Comments
3 min read
Quick Recap: SQL Databases

Quick Recap: SQL Databases

Comments
2 min read
Database Migration Strategies for Zero-Downtime

Database Migration Strategies for Zero-Downtime

Comments
9 min read
10x Query Performance Improvement: The Design and Implementation of the New Unique Key

10x Query Performance Improvement: The Design and Implementation of the New Unique Key

Comments
30 min read
WebRTC + Signaling Server

WebRTC + Signaling Server

2
Comments
5 min read
Secure Agent Database Access: Architecture Patterns That Actually Work

Secure Agent Database Access: Architecture Patterns That Actually Work

Comments
15 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!)

117
Comments 1
2 min read
Understanding Common Table Expressions (CTEs) in SQL — And Why They Matter in Data Analysis

Understanding Common Table Expressions (CTEs) in SQL — And Why They Matter in Data Analysis

Comments
3 min read
LimeDB: Architectural Shift to a Go-based Distributed Key-Value Store with Consistent Hashing

LimeDB: Architectural Shift to a Go-based Distributed Key-Value Store with Consistent Hashing

Comments
4 min read
The Role of Excel in Business Intelligence(BI) and Data Driven Decision-Making

The Role of Excel in Business Intelligence(BI) and Data Driven Decision-Making

Comments
3 min read
Key Microsoft Dataverse Features That Improve Data and App Development

Key Microsoft Dataverse Features That Improve Data and App Development

Comments
4 min read
Performance Testing Databases the Right Way: A Real-World Engineering Journey

Performance Testing Databases the Right Way: A Real-World Engineering Journey

Comments
4 min read
Change Data Capture(Example using Microsoft SQL Server Log-based CDC vs Trigger-based CDC

Change Data Capture(Example using Microsoft SQL Server Log-based CDC vs Trigger-based CDC

Comments
6 min read
loading...