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.
PostgreSQL Backup and Restore Strategies

PostgreSQL Backup and Restore Strategies

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

You forget RethinkDB, it's a shame

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

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

12
Comments
4 min read
eCommerce Database Design

eCommerce Database Design

160
Comments 14
5 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

3
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

13
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
Mastering Postgres Debugging: must-know queries for database troubleshooting

Mastering Postgres Debugging: must-know queries for database troubleshooting

12
Comments 1
5 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

6
Comments
1 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

17
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?

5
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 🔑

6
Comments 3
2 min read
How to Use MySQL Database in Total.js with QueryBuilderMySQL?

How to Use MySQL Database in Total.js with QueryBuilderMySQL?

Comments
5 min read
Announcing Dragonfly Kubernetes Operator General Availability

Announcing Dragonfly Kubernetes Operator General Availability

Comments
5 min read
Building a Real-Time Ad Server with Dragonfly

Building a Real-Time Ad Server with Dragonfly

Comments
9 min read
What Are ORMs & Should You Use Them

What Are ORMs & Should You Use Them

Comments
7 min read
Simplifying architecture for a hotel management SaaS solution

Simplifying architecture for a hotel management SaaS solution

1
Comments
4 min read
Unlocking the Power of Python: The Vital Role of SQLAlchemy

Unlocking the Power of Python: The Vital Role of SQLAlchemy

3
Comments 2
3 min read
Database in System Design | Relational & Non-relational Database

Database in System Design | Relational & Non-relational Database

6
Comments
4 min read
TableSpace ;

TableSpace ;

5
Comments
5 min read
Dominando JOINs no SQL: Guia Completo

Dominando JOINs no SQL: Guia Completo

2
Comments
4 min read
Super Easy Database Documentation Tool - "Prisma Markdown"

Super Easy Database Documentation Tool - "Prisma Markdown"

30
Comments 4
4 min read
What is the CASE Statement in sql?

What is the CASE Statement in sql?

5
Comments
2 min read
Modern Database Management Explained

Modern Database Management Explained

1
Comments
13 min read
SQL 📊 challenge_3 ⚔️

SQL 📊 challenge_3 ⚔️

Comments
1 min read
Spring JDBC: Where Java Meets the Database, with a Dash of Humor!

Spring JDBC: Where Java Meets the Database, with a Dash of Humor!

6
Comments
3 min read
PostgreSQL Internals: A Deep Dive into the Inner Workings of a Powerful Relational Database

PostgreSQL Internals: A Deep Dive into the Inner Workings of a Powerful Relational Database

4
Comments
3 min read
Easy tips to reduce MongoDB database size in no time

Easy tips to reduce MongoDB database size in no time

1
Comments
4 min read
Unleashing the Power of Indexes in PostgreSQL

Unleashing the Power of Indexes in PostgreSQL

Comments 1
2 min read
How to prevent database problems from hitting production?

How to prevent database problems from hitting production?

Comments
10 min read
Foreign Keys on Distributed SQL: don't worry, it scales

Foreign Keys on Distributed SQL: don't worry, it scales

1
Comments
6 min read
7 Tips to Optimise Postgres query performance

7 Tips to Optimise Postgres query performance

1
Comments
1 min read
Indexes 101: What They Are, Why They Matter, and How to Use Them in PostgreSQL

Indexes 101: What They Are, Why They Matter, and How to Use Them in PostgreSQL

2
Comments
6 min read
Data Modelling In AGE:Common Data Modelling Mistakes To Avoid

Data Modelling In AGE:Common Data Modelling Mistakes To Avoid

Comments
2 min read
PostgreSQL Extension: ApacheAGE

PostgreSQL Extension: ApacheAGE

Comments
1 min read
Triggers in SQL database to extend its declarative data logic (but not business logic)

Triggers in SQL database to extend its declarative data logic (but not business logic)

1
Comments
5 min read
CAP Theorem

CAP Theorem

3
Comments 1
2 min read
How To Write SQL Statements That Are Migratable Between Databases

How To Write SQL Statements That Are Migratable Between Databases

5
Comments
4 min read
PostgreSQL's Emerging Role in Decentralized Applications(DApps)

PostgreSQL's Emerging Role in Decentralized Applications(DApps)

2
Comments 1
3 min read
PostgreSQL and NoSQL: Bridging the Gap with JSON and Hstore

PostgreSQL and NoSQL: Bridging the Gap with JSON and Hstore

1
Comments
3 min read
loading...