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.
Highlights from Peter DeSantis Keynote at re:Invent 2023

Highlights from Peter DeSantis Keynote at re:Invent 2023

3
Comments
2 min read
History of Database

History of Database

Comments
5 min read
Monolithic vs Microservices Architecture

Monolithic vs Microservices Architecture

2
Comments 1
3 min read
SPL understanding and Open Source

SPL understanding and Open Source

29
Comments 6
5 min read
Isolation Levels - part I: Introduction

Isolation Levels - part I: Introduction

14
Comments
3 min read
Backup sem estresse: Como criar o dump do seu BD PostgreSQL no Docker de forma simples

Backup sem estresse: Como criar o dump do seu BD PostgreSQL no Docker de forma simples

10
Comments 2
2 min read
Comparing MongoDB composite indexes

Comparing MongoDB composite indexes

3
Comments
8 min read
Unlock the Power of SQL JOINs: A Comprehensive Guide

Unlock the Power of SQL JOINs: A Comprehensive Guide

1
Comments
4 min read
Indexes in MySQL – Notes

Indexes in MySQL – Notes

2
Comments
5 min read
Best Programming languages for Data Analysisđź“Š

Best Programming languages for Data Analysisđź“Š

31
Comments 6
3 min read
Soft introduction to Dapper and EF Core

Soft introduction to Dapper and EF Core

9
Comments
5 min read
Chaos Engineering - Who's to Blame for the Bug Mess?

Chaos Engineering - Who's to Blame for the Bug Mess?

Comments
4 min read
Let's have fun with MySQL JSON functions!

Let's have fun with MySQL JSON functions!

2
Comments 4
4 min read
Understanding Queryable State in RisingWave Streaming Database

Understanding Queryable State in RisingWave Streaming Database

1
Comments
8 min read
How to Shrink EBS Volumes

How to Shrink EBS Volumes

1
Comments
6 min read
Using SQLite with Python

Using SQLite with Python

1
Comments
1 min read
It's not surprising that it's N times faster than ORACLE, such lightweight is the king

It's not surprising that it's N times faster than ORACLE, such lightweight is the king

7
Comments
7 min read
Potential Pitfalls of Over-Reliance on SQLAlchemy

Potential Pitfalls of Over-Reliance on SQLAlchemy

1
Comments 1
1 min read
Structured Query Language (SQL) - Series

Structured Query Language (SQL) - Series

3
Comments 1
2 min read
Very basic introduction (revision tool) to SQL

Very basic introduction (revision tool) to SQL

2
Comments
2 min read
The Hallucinated Rows Incident

The Hallucinated Rows Incident

3
Comments 1
11 min read
A Comprehensive Guide to SQL Query Optimization Techniques

A Comprehensive Guide to SQL Query Optimization Techniques

28
Comments 1
2 min read
How We Optimized Dragonfly to Get 30x Throughput with BullMQ

How We Optimized Dragonfly to Get 30x Throughput with BullMQ

Comments
13 min read
Unveiling the Robust Architecture of SQL Server A Comprehensive Overview

Unveiling the Robust Architecture of SQL Server A Comprehensive Overview

Comments
2 min read
Secure Connection between Lambda and RDS: Choosing and Implementing SSL/TLS Certificates

Secure Connection between Lambda and RDS: Choosing and Implementing SSL/TLS Certificates

8
Comments
2 min read
Solving duplicate data with performant deduplication

Solving duplicate data with performant deduplication

1
Comments
8 min read
eCommerce Database Design

eCommerce Database Design

185
Comments 14
5 min read
🔥🤯 Top 7 AI-Enhanced Database Tools for Next-Level Development 🚀🧠

🔥🤯 Top 7 AI-Enhanced Database Tools for Next-Level Development 🚀🧠

41
Comments 9
6 min read
Achieving High Availability and Replication in PostgreSQL

Achieving High Availability and Replication in PostgreSQL

Comments
2 min read
PostgreSQL Backup and Restore Strategies

PostgreSQL Backup and Restore Strategies

Comments
2 min read
How to Avoid N+1 Queries in Django: Tips and Solutions

How to Avoid N+1 Queries in Django: Tips and Solutions

15
Comments
4 min read
You forget RethinkDB, it's a shame

You forget RethinkDB, it's a shame

11
Comments 8
6 min read
How To Create Many-to-Many Relationships in SQL

How To Create Many-to-Many Relationships in SQL

14
Comments 2
21 min read
Why do we NOLOCK in SQL server with an example

Why do we NOLOCK in SQL server with an example

5
Comments
1 min read
Why do we NOLOCK AND LOCK in SQL server with an example

Why do we NOLOCK AND LOCK in SQL server with an example

1
Comments
1 min read
Building E-Commerce Applications with Dragonfly

Building E-Commerce Applications with Dragonfly

Comments
10 min read
Why do we use indexes in the database SSMS?

Why do we use indexes in the database SSMS?

Comments
2 min read
How to create and configure a linked server in SQL Server Management Studio

How to create and configure a linked server in SQL Server Management Studio

14
Comments
2 min read
Optimizing Rust Code for the Lsm-Tree Iterator in RisingWave

Optimizing Rust Code for the Lsm-Tree Iterator in RisingWave

Comments
7 min read
Inserting Data from One Table to Another in SQL using INSERT INTO using SELECT Statement

Inserting Data from One Table to Another in SQL using INSERT INTO using SELECT Statement

8
Comments
1 min read
Mastering Postgres Debugging: must-know queries for database troubleshooting

Mastering Postgres Debugging: must-know queries for database troubleshooting

13
Comments 1
5 min read
Why Everyone Should Know the CAP Theorem?

Why Everyone Should Know the CAP Theorem?

2
Comments 2
2 min read
SQL Magic with SQLite

SQL Magic with SQLite

3
Comments
2 min read
What makes a database ACID compliant?🧪

What makes a database ACID compliant?🧪

9
Comments
6 min read
Google FireStore Data Source Plugin for Grafana.

Google FireStore Data Source Plugin for Grafana.

2
Comments
1 min read
Entendendo o WHERE e o ORDER BY

Entendendo o WHERE e o ORDER BY

1
Comments
2 min read
How to reset pg_stat_database statistics for all DBs on a PostgreSQL Server?

How to reset pg_stat_database statistics for all DBs on a PostgreSQL Server?

1
Comments
2 min read
Stored Procedures: Where to Go

Stored Procedures: Where to Go

10
Comments
5 min read
Connecting Alpine.js to a Database REST API: A Simple Guide

Connecting Alpine.js to a Database REST API: A Simple Guide

18
Comments 1
3 min read
How To Use EF Core Interceptors

How To Use EF Core Interceptors

2
Comments
5 min read
Partition Strategies: Fundamental Concepts for PostgreSQL Partitioning

Partition Strategies: Fundamental Concepts for PostgreSQL Partitioning

4
Comments
4 min read
Digging into Marten query sets

Digging into Marten query sets

3
Comments
8 min read
How materialized views saved our bacon

How materialized views saved our bacon

7
Comments
6 min read
Greptime User Guide - How to Store GreptimeDB Data on AWS S3

Greptime User Guide - How to Store GreptimeDB Data on AWS S3

Comments
5 min read
Running BullMQ with Dragonfly

Running BullMQ with Dragonfly

Comments
6 min read
Automating `updated_at` Timestamps with `update_all` in Ruby on Rails

Automating `updated_at` Timestamps with `update_all` in Ruby on Rails

2
Comments
2 min read
Object Relationships in Room ORM Library for Android

Object Relationships in Room ORM Library for Android

1
Comments 1
12 min read
How to check the number of transactions per second (TPS) for the given PostgreSQL DB instance?

How to check the number of transactions per second (TPS) for the given PostgreSQL DB instance?

6
Comments
2 min read
How to check the number of queries per second (QPS) on the PostgreSQL DB instance?

How to check the number of queries per second (QPS) on the PostgreSQL DB instance?

6
Comments
1 min read
Understanding Keys in Relational Databases 🔑

Understanding Keys in Relational Databases 🔑

7
Comments 3
2 min read
loading...