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.
Secure Agent Database Access: Architecture Patterns That Actually Work

Secure Agent Database Access: Architecture Patterns That Actually Work

Comments
15 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
No, MongoDB Does Not Mean Skipping Design

No, MongoDB Does Not Mean Skipping Design

7
Comments 1
6 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
Troubleshooting Ruby on Rails Database Migrations: Common Issues and Real Fixes

Troubleshooting Ruby on Rails Database Migrations: Common Issues and Real Fixes

Comments
3 min read
Unstructured Data in Salesforce Data Cloud: A Developer’s Guide

Unstructured Data in Salesforce Data Cloud: A Developer’s Guide

1
Comments
5 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
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
FastAPI Mongo Admin: The Admin Interface Every FastAPI Developer Needs

FastAPI Mongo Admin: The Admin Interface Every FastAPI Developer Needs

Comments
3 min read
Dear Developer: Your Database Isn't a File Cabinet!

Dear Developer: Your Database Isn't a File Cabinet!

9
Comments
4 min read
Why Backups Fail in PostgreSQL: Common Mistakes and How to Avoid Them

Why Backups Fail in PostgreSQL: Common Mistakes and How to Avoid Them

1
Comments
5 min read
Quick Recap: JPA (Java Persistence API)

Quick Recap: JPA (Java Persistence API)

Comments
2 min read
🚀 Introducing Laravel Chatbot – A simple & powerful chatbot for your Laravel apps!

🚀 Introducing Laravel Chatbot – A simple & powerful chatbot for your Laravel apps!

Comments
1 min read
Extract & Analyze Your Hidden App Data (Chrome, iMessage, VS Code) Using Claude AI

Extract & Analyze Your Hidden App Data (Chrome, iMessage, VS Code) Using Claude AI

3
Comments
3 min read
Zero to NoSQL: A Hands-On MongoDB Tutorial (No Installation Required!)

Zero to NoSQL: A Hands-On MongoDB Tutorial (No Installation Required!)

Comments
4 min read
B-Trees, Pages, and the Hidden Problems Behind Traditional Indexin

B-Trees, Pages, and the Hidden Problems Behind Traditional Indexin

16
Comments
3 min read
The .NET Cross-Platform Showdown: MAUI vs Uno vs Avalonia (And Why Avalonia Won)

The .NET Cross-Platform Showdown: MAUI vs Uno vs Avalonia (And Why Avalonia Won)

Comments 5
9 min read
Physical vs Logical Backups in PostgreSQL: Decisive Comparison & Guide

Physical vs Logical Backups in PostgreSQL: Decisive Comparison & Guide

1
Comments
12 min read
6 Essential Data Formats in Cloud Analytics: A Complete Guide with Examples

6 Essential Data Formats in Cloud Analytics: A Complete Guide with Examples

Comments
5 min read
Your Tech Stack Is Limiting Your Creativity

Your Tech Stack Is Limiting Your Creativity

8
Comments 4
4 min read
I built a Chatbot GUI with Rust, Dioxus, and SQLite

I built a Chatbot GUI with Rust, Dioxus, and SQLite

Comments 1
1 min read
Trigger Logic Causing Recursive Updates or Data Duplication (Salesforce)

Trigger Logic Causing Recursive Updates or Data Duplication (Salesforce)

1
Comments
3 min read
loading...