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.
Mastering Table Relationships in Relational Databases: The Role of Primary and Foreign Keys

Mastering Table Relationships in Relational Databases: The Role of Primary and Foreign Keys

Comments
3 min read
Replication in Distributed Systems - Part 3

Replication in Distributed Systems - Part 3

Comments
6 min read
How Tables and indexes stored on Disk

How Tables and indexes stored on Disk

Comments
2 min read
Data API for Amazon Aurora Serverless v2 with AWS SDK for Java - Part 3 Executing update and insert SQL statements in batch

Data API for Amazon Aurora Serverless v2 with AWS SDK for Java - Part 3 Executing update and insert SQL statements in batch

1
Comments
3 min read
Learnings from a 5-hour production downtime!

Learnings from a 5-hour production downtime!

20
Comments 4
4 min read
ACID (Atomicity, Consistency, Isolation, and Durability)

ACID (Atomicity, Consistency, Isolation, and Durability)

14
Comments 3
3 min read
Docker Compose: Quick Local Development Setup - Postgresql

Docker Compose: Quick Local Development Setup - Postgresql

Comments
2 min read
Unraveling the Web: A Comprehensive Guide to Mastering SQL Joins

Unraveling the Web: A Comprehensive Guide to Mastering SQL Joins

Comments
3 min read
COMMON MISTAKES TO AVOID IN SQL QUERY WRITING

COMMON MISTAKES TO AVOID IN SQL QUERY WRITING

Comments
2 min read
Navigating SQL Data Types: A Comprehensive Guide

Navigating SQL Data Types: A Comprehensive Guide

Comments
3 min read
How to Build an Advanced AI-Powered Enterprise Content Pipeline Using Mixtral 8x7B and Qdrant

How to Build an Advanced AI-Powered Enterprise Content Pipeline Using Mixtral 8x7B and Qdrant

2
Comments
10 min read
EF Core/NorthWind for Oracle

EF Core/NorthWind for Oracle

Comments
14 min read
Understanding DynamoDB Write Capacity Units: PutItem vs UpdateItem

Understanding DynamoDB Write Capacity Units: PutItem vs UpdateItem

3
Comments
3 min read
Research Paper Sharing - Exploiting Cloud Object Storage for High-Performance Analytics

Research Paper Sharing - Exploiting Cloud Object Storage for High-Performance Analytics

Comments
8 min read
10 Reasons to Make Apache Iceberg and Dremio Part of your Data Lakehouse Strategy

10 Reasons to Make Apache Iceberg and Dremio Part of your Data Lakehouse Strategy

Comments
9 min read
How to Implement Sharding in MongoDB

How to Implement Sharding in MongoDB

14
Comments
3 min read
ADO OR Entity framework?

ADO OR Entity framework?

19
Comments
2 min read
Key-Value Database: A Simple and Fast Way to Store Data

Key-Value Database: A Simple and Fast Way to Store Data

Comments
3 min read
Better Postgres Database Migrations and Testing by Ditching Bloated ORMs

Better Postgres Database Migrations and Testing by Ditching Bloated ORMs

Comments
3 min read
🔄 How to Synchronize Database Schemas🔥🚀

🔄 How to Synchronize Database Schemas🔥🚀

7
Comments 1
5 min read
What to Expect Next? GreptimeDB Roadmap for 2024

What to Expect Next? GreptimeDB Roadmap for 2024

Comments
4 min read
Chat with your Database using Custom GPTs

Chat with your Database using Custom GPTs

Comments
3 min read
Query optimisation using database indexes

Query optimisation using database indexes

1
Comments
3 min read
Hey Managers! Don’t Let Developers Break Your Production! Let Metis Help You

Hey Managers! Don’t Let Developers Break Your Production! Let Metis Help You

Comments
7 min read
Benchmarking Python Processing Engines: Who’s the Fastest?

Benchmarking Python Processing Engines: Who’s the Fastest?

3
Comments
4 min read
SQL(Structured query language)

SQL(Structured query language)

1
Comments
15 min read
How to choose the right type of database

How to choose the right type of database

2
Comments
13 min read
Structured Query Language-SQL : Mastering

Structured Query Language-SQL : Mastering

1
Comments
5 min read
Battle of the Node.js ORMs: Sequelize vs. Prisma

Battle of the Node.js ORMs: Sequelize vs. Prisma

4
Comments 1
4 min read
Sharding vs Partitioning

Sharding vs Partitioning

1
Comments
1 min read
SQLite3 Replication: A Wizard's Guide🧙🏽

SQLite3 Replication: A Wizard's Guide🧙🏽

2
Comments
4 min read
Functions in SQL

Functions in SQL

Comments
3 min read
On DynamoDB’s Single Table Design

On DynamoDB’s Single Table Design

3
Comments 1
6 min read
SOLID.JS & SUPABASE Authentication App

SOLID.JS & SUPABASE Authentication App

12
Comments
2 min read
Why Vector Search Is Not Enough for Your GenAI Applications?

Why Vector Search Is Not Enough for Your GenAI Applications?

8
Comments
7 min read
Database Isolation Levels: A Practical Guide

Database Isolation Levels: A Practical Guide

Comments 1
12 min read
Investigating and Optimizing Over-Querying

Investigating and Optimizing Over-Querying

Comments
13 min read
How to Use Reductstore as a Data Sink for Kafka

How to Use Reductstore as a Data Sink for Kafka

5
Comments
6 min read
Unlocking the Power of SQL Server: The Importance of Stored Procedures for Complex Queries

Unlocking the Power of SQL Server: The Importance of Stored Procedures for Complex Queries

Comments
2 min read
Mastering SQL Aggregate Functions: SUM, MAX, MIN, AVG

Mastering SQL Aggregate Functions: SUM, MAX, MIN, AVG

2
Comments
4 min read
Effortless Privacy Protection: Simplifying Account Deletions

Effortless Privacy Protection: Simplifying Account Deletions

Comments
2 min read
Beyond the Basics: Leveraging ACID for Advanced Database Management

Beyond the Basics: Leveraging ACID for Advanced Database Management

Comments
2 min read
Mongodb aggregation pipeline with examples

Mongodb aggregation pipeline with examples

Comments
5 min read
The Six Pillars of Database-Driven Application Performance

The Six Pillars of Database-Driven Application Performance

Comments
5 min read
Storing classes with user configurable parameters in the database (with Laravel)

Storing classes with user configurable parameters in the database (with Laravel)

1
Comments
3 min read
Consistency isn’t consistent at all!

Consistency isn’t consistent at all!

Comments
2 min read
What is JSON-LD?

What is JSON-LD?

Comments
8 min read
MYSQL VS POSTGRESQL: CHOOSING THE RIGHT DATABASE FOR YOUR NEEDS

MYSQL VS POSTGRESQL: CHOOSING THE RIGHT DATABASE FOR YOUR NEEDS

Comments
3 min read
Thinking Inside The Box: Relational Style Joins in SurrealDB

Thinking Inside The Box: Relational Style Joins in SurrealDB

14
Comments
7 min read
Studio 3T Performance Suite: How to Identify and Resolve Performance Bottlenecks in MongoDB

Studio 3T Performance Suite: How to Identify and Resolve Performance Bottlenecks in MongoDB

Comments
5 min read
Hands-on Guide to Enable Compute Nodes for Data Lake Analytics in Apache Doris

Hands-on Guide to Enable Compute Nodes for Data Lake Analytics in Apache Doris

Comments
4 min read
Prisma vs Sequelize: A Comprehensive Comparison of Node.js ORMs

Prisma vs Sequelize: A Comprehensive Comparison of Node.js ORMs

6
Comments
3 min read
🏁🐘Winning Race Conditions With PostgreSQL

🏁🐘Winning Race Conditions With PostgreSQL

34
Comments 2
10 min read
Sparse Vectors in Qdrant: Pure Vector-based Hybrid Search

Sparse Vectors in Qdrant: Pure Vector-based Hybrid Search

36
Comments 2
15 min read
🦉 AthenaDB: Distributed Vector Database Powered by Cloudflare 🌩️

🦉 AthenaDB: Distributed Vector Database Powered by Cloudflare 🌩️

4
Comments 1
4 min read
Navigating Django Schemas with Ease: How Django-schema-viewer Helps Developers

Navigating Django Schemas with Ease: How Django-schema-viewer Helps Developers

Comments
3 min read
Adminer With Custom Login Servers Selector Plugin Run In Docker

Adminer With Custom Login Servers Selector Plugin Run In Docker

Comments
3 min read
[20 Days of DynamoDB] Day 8 - Conditional Delete operation

[20 Days of DynamoDB] Day 8 - Conditional Delete operation

2
Comments
1 min read
Music Monitor x Five: Building a Modern Database Solution for Music Schools

Music Monitor x Five: Building a Modern Database Solution for Music Schools

Comments
4 min read
Unlocking the Power of Databases: A Brief Overview of SQL

Unlocking the Power of Databases: A Brief Overview of SQL

3
Comments
9 min read
loading...