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.
Finding Slow Queries in Postgres Using Datadog

Finding Slow Queries in Postgres Using Datadog

5
Comments
7 min read
DB2 Cheat Sheet

DB2 Cheat Sheet

1
Comments
1 min read
6 guidelines for risk-less data migrations

6 guidelines for risk-less data migrations

32
Comments 2
6 min read
Automating the creation of Shopify stores with Xata

Automating the creation of Shopify stores with Xata

1
Comments 1
4 min read
Introdução aos Dados Geoespaciais no MongoDB

Introdução aos Dados Geoespaciais no MongoDB

Comments
3 min read
Isolation Levels - part XI: Read Uncommitted

Isolation Levels - part XI: Read Uncommitted

Comments 2
1 min read
SQL vs No-SQL

SQL vs No-SQL

1
Comments
2 min read
Understan How Sql works

Understan How Sql works

1
Comments
2 min read
Sql Beginners Tutorials

Sql Beginners Tutorials

1
Comments
2 min read
Isolation Levels - part X: Non-Transactional Writes

Isolation Levels - part X: Non-Transactional Writes

1
Comments
2 min read
Help SQL query

Help SQL query

Comments
1 min read
How Metis Detects Too Many Open Connections on Postgres

How Metis Detects Too Many Open Connections on Postgres

Comments
3 min read
Relational Algebra Is the Root of SQL Problems

Relational Algebra Is the Root of SQL Problems

12
Comments 2
5 min read
DATA ENGINEERING ROADMAP FOR BEGINNERS.

DATA ENGINEERING ROADMAP FOR BEGINNERS.

Comments
8 min read
Optimising a web application (II): indexing

Optimising a web application (II): indexing

Comments
5 min read
O que são triggers?

O que são triggers?

1
Comments
2 min read
To Aggregate or Not to Aggregate, That is the Query

To Aggregate or Not to Aggregate, That is the Query

10
Comments
5 min read
Database documentation and ER diagram using SchemaSpy

Database documentation and ER diagram using SchemaSpy

Comments
1 min read
Add feature flags in Astro apps using Xata and Vercel

Add feature flags in Astro apps using Xata and Vercel

1
Comments
6 min read
ON CONFLICT DO NOTHING in YugabyteDB

ON CONFLICT DO NOTHING in YugabyteDB

Comments
4 min read
Isolation Levels - part IX: Read Committed

Isolation Levels - part IX: Read Committed

1
Comments 8
4 min read
How to reduce MongoDB database storage size by 95% with no effort?

How to reduce MongoDB database storage size by 95% with no effort?

2
Comments
8 min read
Type Conversion in C programming.

Type Conversion in C programming.

7
Comments
2 min read
Airbnb ETL

Airbnb ETL

1
Comments
2 min read
MongoDB and PostgreSQL - Key Difference Between Databases

MongoDB and PostgreSQL - Key Difference Between Databases

Comments
2 min read
Understanding Pluggable Storage In Postgresql And Its Benefits

Understanding Pluggable Storage In Postgresql And Its Benefits

1
Comments 1
8 min read
Back to the Future: Exploring Frameworkless and Serverless Web Development

Back to the Future: Exploring Frameworkless and Serverless Web Development

6
Comments 1
8 min read
I# NoSQL'nin Ötesinde: Redis ile Caching Stratejileri

I# NoSQL'nin Ötesinde: Redis ile Caching Stratejileri

3
Comments
6 min read
Simplifying ETL Pipelines with SQL: Three Tips for Data Processing

Simplifying ETL Pipelines with SQL: Three Tips for Data Processing

19
Comments
3 min read
Extended Statistics and pg_hint_plan /*+ Rows() */

Extended Statistics and pg_hint_plan /*+ Rows() */

2
Comments 2
7 min read
SQL and NoSQL databases: What are the types and ideal use cases

SQL and NoSQL databases: What are the types and ideal use cases

1
Comments 1
6 min read
How Modern SQL Databases Are Changing Web Development - #3 Better Developer Experience

How Modern SQL Databases Are Changing Web Development - #3 Better Developer Experience

24
Comments
6 min read
The Most Annoying Optimizer Fail in Postgres ✅ Best index solved it.

The Most Annoying Optimizer Fail in Postgres ✅ Best index solved it.

10
Comments 1
9 min read
Comparing Types of Databases: A Real-World Benchmark Analysis

Comparing Types of Databases: A Real-World Benchmark Analysis

Comments
8 min read
Holiday Hackathon

Holiday Hackathon

1
Comments 1
2 min read
🔮 SuperDuperDB is #3 on GitHub Trending globally! 🥉

🔮 SuperDuperDB is #3 on GitHub Trending globally! 🥉

7
Comments 1
1 min read
Set-oriented Syntax – Using SQL as an Example

Set-oriented Syntax – Using SQL as an Example

6
Comments 1
4 min read
Configuring Delete Behaviour for One to Many Related Objects in SQLAlchemy 2.0

Configuring Delete Behaviour for One to Many Related Objects in SQLAlchemy 2.0

Comments
1 min read
How To Get Started With ETL Processes In Apache Age

How To Get Started With ETL Processes In Apache Age

Comments
4 min read
Create your CRUD Application in PHP

Create your CRUD Application in PHP

4
Comments
4 min read
Views, Sequences, e Synonyms in Oracle.

Views, Sequences, e Synonyms in Oracle.

8
Comments 1
4 min read
Isolation Levels - part VIII: Cursor Stability

Isolation Levels - part VIII: Cursor Stability

2
Comments
1 min read
SQL - Joins (Tutorial Prático)

SQL - Joins (Tutorial Prático)

Comments 1
8 min read
Equipping yourself with Excel increase job opportunities

Equipping yourself with Excel increase job opportunities

4
Comments
2 min read
Artigo: Banco de Dados Flashback

Artigo: Banco de Dados Flashback

Comments
2 min read
Quick 📸 on 🐘 wait events from pg_stat_activity

Quick 📸 on 🐘 wait events from pg_stat_activity

5
Comments
2 min read
Practical Storage Savings for Backend Developers

Practical Storage Savings for Backend Developers

1
Comments
1 min read
How pgroll works under the hood

How pgroll works under the hood

4
Comments 1
11 min read
Announcing Dragonfly Search

Announcing Dragonfly Search

Comments
10 min read
MySQL Analyze Query Execution Plans: How to Reach Top Query SpeedMemory storage engine

MySQL Analyze Query Execution Plans: How to Reach Top Query SpeedMemory storage engine

5
Comments 1
20 min read
🔮 Open-Source Launch of SuperDuperDB: Integrate AI with your Database

🔮 Open-Source Launch of SuperDuperDB: Integrate AI with your Database

24
Comments 1
1 min read
Announcing the release of the Xata Go SDK

Announcing the release of the Xata Go SDK

Comments
3 min read
What is Horizontal Sharding?

What is Horizontal Sharding?

Comments
10 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
Batched Nested Loop for Join With Large Pagination

Batched Nested Loop for Join With Large Pagination

3
Comments
6 min read
How to Optimize Indexing for Distributed One-to-Many Join With Pagination

How to Optimize Indexing for Distributed One-to-Many Join With Pagination

11
Comments
6 min read
Decoding the N+1 Query Problem

Decoding the N+1 Query Problem

2
Comments
2 min read
Understanding Database Transactions: A Developer's Guide

Understanding Database Transactions: A Developer's Guide

2
Comments
3 min read
Ultimate guide: Best databases for NodeJS apps

Ultimate guide: Best databases for NodeJS apps

14
Comments
14 min read
Use SQL without Databases

Use SQL without Databases

18
Comments 8
9 min read
loading...