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.
Supercharge Your Database: 25 Essential MySQL Query Optimization Techniques

Supercharge Your Database: 25 Essential MySQL Query Optimization Techniques

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

Learnings from a 5-hour production downtime!

20
Comments 4
4 min read
Docker Compose: Quick Local Development Setup - Postgresql

Docker Compose: Quick Local Development Setup - Postgresql

3
Comments
2 min read
ACID (Atomicity, Consistency, Isolation, and Durability)

ACID (Atomicity, Consistency, Isolation, and Durability)

15
Comments 3
3 min read
Day-7 SQL

Day-7 SQL

2
Comments
12 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
Why we are betting on Rust!

Why we are betting on Rust!

26
Comments 2
4 min read
EF Core/NorthWind for Oracle

EF Core/NorthWind for Oracle

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

Understanding DynamoDB Write Capacity Units: PutItem vs UpdateItem

5
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
ADO OR Entity framework?

ADO OR Entity framework?

20
Comments
2 min read
How to Implement Sharding in MongoDB

How to Implement Sharding in MongoDB

15
Comments
3 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
Key-Value Database: A Simple and Fast Way to Store Data

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

1
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
What are Object-Relational Mappers (ORMs)?

What are Object-Relational Mappers (ORMs)?

3
Comments 1
2 min read
Choosing the Right Database: A Comprehensive Guide to Types and Selection Criteria

Choosing the Right Database: A Comprehensive Guide to Types and Selection Criteria

Comments
2 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
How to Keep a History of MQTT Data With Python

How to Keep a History of MQTT Data With Python

6
Comments
5 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
Battle of the Node.js ORMs: Sequelize vs. Prisma

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

44
Comments 2
4 min read
Construyendo un mapa para aprender sobre el Back-end

Construyendo un mapa para aprender sobre el Back-end

1
Comments
5 min read
Structured Query Language-SQL : Mastering SQL Queries: From Beginner to Expert

Structured Query Language-SQL : Mastering SQL Queries: From Beginner to Expert

2
Comments
6 min read
SQL vs. No SQL | Database Types | Mastering Data Architecture

SQL vs. No SQL | Database Types | Mastering Data Architecture

1
Comments
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🧙🏽

7
Comments
4 min read
On DynamoDB’s Single Table Design

On DynamoDB’s Single Table Design

3
Comments 1
6 min read
Functions in SQL

Functions in SQL

Comments
3 min read
Our favourite open-source customer data platforms

Our favourite open-source customer data platforms

52
Comments 14
4 min read
High Frequency Data Analysis: Working with Pivoting

High Frequency Data Analysis: Working with Pivoting

1
Comments
4 min read
SOLID.JS & SUPABASE Authentication App

SOLID.JS & SUPABASE Authentication App

13
Comments
2 min read
Chat with your SQL database

Chat with your SQL database

1
Comments
3 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
Investigating and Optimizing Over-Querying

Investigating and Optimizing Over-Querying

Comments
13 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
The Role of Ontologies in Data Management

The Role of Ontologies in Data Management

1
Comments
6 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
Essential Database Optimizations Before Re-Architecting Your Backend

Essential Database Optimizations Before Re-Architecting Your Backend

Comments
5 min read
Meus aprendizados com a Rinha de Backend 2023 Q3

Meus aprendizados com a Rinha de Backend 2023 Q3

6
Comments
4 min read
Consistency isn’t consistent at all!

Consistency isn’t consistent at all!

Comments
2 min read
Normalization in Relational Databases

Normalization in Relational Databases

Comments
3 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
Breaking IndexedDB consistency to explore its transactions

Breaking IndexedDB consistency to explore its transactions

Comments 2
10 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
SQL Interview Questions.

SQL Interview Questions.

1
Comments 2
6 min read
Understanding Amazon RDS: A Beginner's Guide to Managed Databases in AWS

Understanding Amazon RDS: A Beginner's Guide to Managed Databases in AWS

Comments
2 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

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

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

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

🏁🐘Winning Race Conditions With PostgreSQL

43
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
loading...