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.
Fraud Detection with Knowledge Graphs: A Protégé and VidyaAstra Approach

Fraud Detection with Knowledge Graphs: A Protégé and VidyaAstra Approach

Comments
16 min read
When PostgreSQL Transactions Lie to You: A Detective Story About Phantom Reads

When PostgreSQL Transactions Lie to You: A Detective Story About Phantom Reads

Comments
2 min read
🚀 Cómo Crear una Vista en SQL Server 2022: Simplifica tu Acceso a Datos

🚀 Cómo Crear una Vista en SQL Server 2022: Simplifica tu Acceso a Datos

Comments
2 min read
A Complete Guide to MongoDB for Developers (With Code Examples)

A Complete Guide to MongoDB for Developers (With Code Examples)

Comments
3 min read
Connecting PostgreSQL to Power BI

Connecting PostgreSQL to Power BI

Comments
3 min read
💸 SubZap: Hunting “Zombie Subscriptions” with AlloyDB and Gemini AI

💸 SubZap: Hunting “Zombie Subscriptions” with AlloyDB and Gemini AI

Comments
3 min read
select2

select2

Comments
1 min read
I Built a Real-Time HackerNews Search Engine with 50 Lines of Python (No Airflow, No Kafka)

I Built a Real-Time HackerNews Search Engine with 50 Lines of Python (No Airflow, No Kafka)

5
Comments
3 min read
How to Connect PostgreSQL to Power BI using Local PostgreSQL.

How to Connect PostgreSQL to Power BI using Local PostgreSQL.

Comments
2 min read
Scaling Your Database: Simple Solutions Anyone Can Use

Scaling Your Database: Simple Solutions Anyone Can Use

Comments
4 min read
The Delete Button Dilemma: When to Soft Delete vs Hard Delete

The Delete Button Dilemma: When to Soft Delete vs Hard Delete

5
Comments
5 min read
# 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
Understanding Prometheus Storage: From Scrape to Disk

Understanding Prometheus Storage: From Scrape to Disk

Comments
4 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
How Internet Archive Stores & Protects Trillions of Files

How Internet Archive Stores & Protects Trillions of Files

Comments
7 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
Horizontal vs. Vertical Scaling: Building Scalable Apps

Horizontal vs. Vertical Scaling: Building Scalable Apps

Comments
9 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
loading...