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.
Air Quality App with Enhance

Air Quality App with Enhance

5
Comments
4 min read
Why you should use a hidden replica set member

Why you should use a hidden replica set member

5
Comments
2 min read
Indexing in PostgreSQL: Boost Your Database Queries

Indexing in PostgreSQL: Boost Your Database Queries

2
Comments
4 min read
Exploring MS SQL Server Triggers

Exploring MS SQL Server Triggers

1
Comments 1
2 min read
Unlocking the Power of Graph Analytics with Apache AGE

Unlocking the Power of Graph Analytics with Apache AGE

2
Comments
3 min read
Explorando Amazon Aurora: La base de datos relacional de próxima generación

Explorando Amazon Aurora: La base de datos relacional de próxima generación

2
Comments 2
7 min read
Exploring the NoSQL Powerhouse Amazon DynamoDB

Exploring the NoSQL Powerhouse Amazon DynamoDB

1
Comments
9 min read
Exploring Amazon Aurora: The Next Generation Relational Database

Exploring Amazon Aurora: The Next Generation Relational Database

2
Comments
6 min read
Chapter 3 Query Processing: Join Operations in PostgreSQL (continue)

Chapter 3 Query Processing: Join Operations in PostgreSQL (continue)

1
Comments
3 min read
A Step-by-Step Guide for Deploying LLMs with MindsDB and OpenAI

A Step-by-Step Guide for Deploying LLMs with MindsDB and OpenAI

Comments
6 min read
The Number of Employees Which Report to Each Employee | LeetCode | MSSQL

The Number of Employees Which Report to Each Employee | LeetCode | MSSQL

Comments
4 min read
Database regions and why they matter

Database regions and why they matter

4
Comments
2 min read
Find Followers Count | LeetCode | MSSQL

Find Followers Count | LeetCode | MSSQL

Comments
2 min read
Apache Doris 2.0 Beta Now Available: Faster, Stabler, and More Versatile

Apache Doris 2.0 Beta Now Available: Faster, Stabler, and More Versatile

Comments
15 min read
Daily Leads and Partners | LeetCode | MSSQL

Daily Leads and Partners | LeetCode | MSSQL

Comments 1
3 min read
Structured Query Language (SQL)| Explicación Completa (Definición, uso, estructura y ejemplo con MySQL)

Structured Query Language (SQL)| Explicación Completa (Definición, uso, estructura y ejemplo con MySQL)

Comments
3 min read
Base Backup & Point-in-Time Recovery: PostgreSQL

Base Backup & Point-in-Time Recovery: PostgreSQL

1
Comments
2 min read
Symmetric Pairs | HackerRank | MSSQL

Symmetric Pairs | HackerRank | MSSQL

Comments
3 min read
The Index (Formerly the Weekly Update) #123 (July 7, 2023): PyMongo, Building Flask Apps, and Becoming Superhuman

The Index (Formerly the Weekly Update) #123 (July 7, 2023): PyMongo, Building Flask Apps, and Becoming Superhuman

Comments
5 min read
Mastering the Art of Optimizing Complex SQL Queries

Mastering the Art of Optimizing Complex SQL Queries

Comments
2 min read
Oracle Upgrade Decoded: Insights from an App Developer's Perspective

Oracle Upgrade Decoded: Insights from an App Developer's Perspective

Comments
4 min read
Rethink the way you share the data between micro-services with Change-Data-Capture

Rethink the way you share the data between micro-services with Change-Data-Capture

Comments
4 min read
System Design vs Software Architecture : What You Need to Know

System Design vs Software Architecture : What You Need to Know

1
Comments
8 min read
Triggers in SQL Server: Unlocking the Power of Automation

Triggers in SQL Server: Unlocking the Power of Automation

Comments
3 min read
MySQL usar tipo SET para validar

MySQL usar tipo SET para validar

Comments
1 min read
Vector storage is coming to Meilisearch to empower search through AI

Vector storage is coming to Meilisearch to empower search through AI

15
Comments
4 min read
Using PgBouncer to improve performance and reduce the load on PostgreSQL

Using PgBouncer to improve performance and reduce the load on PostgreSQL

2
Comments
7 min read
Zero Downtime Database Migrations at Woovi

Zero Downtime Database Migrations at Woovi

7
Comments
3 min read
Apache AGE vs Neo4j: Battle of the Graph Databases

Apache AGE vs Neo4j: Battle of the Graph Databases

1
Comments
3 min read
A New Era for TypeDB

A New Era for TypeDB

13
Comments
4 min read
Demystifying PostgreSQL: Concurrency Control

Demystifying PostgreSQL: Concurrency Control

1
Comments
3 min read
Aggregation Function in Apache AGE: The count() function

Aggregation Function in Apache AGE: The count() function

3
Comments
3 min read
The Rails database.yml File

The Rails database.yml File

2
Comments
9 min read
Apache Age: A New Contender in the Graph Database Space?

Apache Age: A New Contender in the Graph Database Space?

1
Comments
3 min read
Why reads are more expensive as compared to writes in Cassandra database ?

Why reads are more expensive as compared to writes in Cassandra database ?

Comments
3 min read
What is going in AGE PG16

What is going in AGE PG16

2
Comments
2 min read
Exploring the Process and Memory Architecture of PostgreSQL: Chapter 2

Exploring the Process and Memory Architecture of PostgreSQL: Chapter 2

Comments
4 min read
Designing SQL Database for a blog application

Designing SQL Database for a blog application

1
Comments
2 min read
"The Internals of Postgresql" chapter #6

"The Internals of Postgresql" chapter #6

Comments
3 min read
" The Internals of Postgresql" chapter #5

" The Internals of Postgresql" chapter #5

Comments
5 min read
Placements | HackerRank | MSSQL

Placements | HackerRank | MSSQL

Comments
3 min read
Redis Analysis - Part 2: Simplicity

Redis Analysis - Part 2: Simplicity

Comments
6 min read
Functions for manipulating data in PostgreSQL

Functions for manipulating data in PostgreSQL

Comments
10 min read
My PostgreSQL Notes

My PostgreSQL Notes

2
Comments
5 min read
Postgres SQL for Dummies: The Architecture (Part 2)

Postgres SQL for Dummies: The Architecture (Part 2)

Comments
2 min read
Structured Query Language (SQL)| Full Explanation (Definition, usage, structure and example with MySQL)

Structured Query Language (SQL)| Full Explanation (Definition, usage, structure and example with MySQL)

4
Comments
3 min read
How to deliver the best search results: inside a full text search engine

How to deliver the best search results: inside a full text search engine

2
Comments
10 min read
结构化查询语言(SQL)| 完整解释(定义、用法、结构和 MySQL 示例)

结构化查询语言(SQL)| 完整解释(定义、用法、结构和 MySQL 示例)

Comments
1 min read
Maximising Database Performance: Tips and Techniques for PostgreSQL Optimisation

Maximising Database Performance: Tips and Techniques for PostgreSQL Optimisation

2
Comments
2 min read
How to implement real-time data sync in your Next.js app with Appwrite Cloud

How to implement real-time data sync in your Next.js app with Appwrite Cloud

2
Comments
6 min read
Postgres schema changes are still a PITA

Postgres schema changes are still a PITA

8
Comments
9 min read
Why You should Start Contributing to OpenSource

Why You should Start Contributing to OpenSource

6
Comments
2 min read
Desbravando os Segredos do SQL: Um Guia Completo para Dominar a Linguagem de Bancos de Dados

Desbravando os Segredos do SQL: Um Guia Completo para Dominar a Linguagem de Bancos de Dados

Comments
3 min read
YugabyteDB fast path write

YugabyteDB fast path write

1
Comments
9 min read
Understanding Data Compaction in 3 Minutes

Understanding Data Compaction in 3 Minutes

Comments
6 min read
Database Normalisation: Efficient Database Design

Database Normalisation: Efficient Database Design

2
Comments
2 min read
Build a fully typed web app using Next.js, PlanetScale, Drizzle, and Kysely

Build a fully typed web app using Next.js, PlanetScale, Drizzle, and Kysely

Comments
16 min read
Demystifying the Internals of PostgreSQL - Chapter 5

Demystifying the Internals of PostgreSQL - Chapter 5

Comments
5 min read
Understanding the Basics of PostgreSQL's Database Cluster

Understanding the Basics of PostgreSQL's Database Cluster

1
Comments
4 min read
Vacuum Processing in PostgreSQL: Chapter 6

Vacuum Processing in PostgreSQL: Chapter 6

Comments
3 min read
loading...