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.
How to Replace a Null with the Corresponding Value in the Previous Record

How to Replace a Null with the Corresponding Value in the Previous Record

11
Comments 1
1 min read
Move Fast and “Branch” Things

Move Fast and “Branch” Things

2
Comments
8 min read
Understanding Database Normalization: A Comprehensive Guide

Understanding Database Normalization: A Comprehensive Guide

4
Comments
4 min read
Unraveling the Power of MongoDB: Exploring NoSQL Database Magic

Unraveling the Power of MongoDB: Exploring NoSQL Database Magic

Comments
2 min read
Building IRIS Responsive dashboard with Python Flask Web Framework

Building IRIS Responsive dashboard with Python Flask Web Framework

Comments
5 min read
Optimising Database Performance: The Pitfalls of ‘SELECT * FROM’ Queries

Optimising Database Performance: The Pitfalls of ‘SELECT * FROM’ Queries

Comments
4 min read
Getting Started with SQL Transactions in PostgreSQL

Getting Started with SQL Transactions in PostgreSQL

Comments
4 min read
PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?

PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?

54
Comments 11
6 min read
ACID properties of a database system.

ACID properties of a database system.

Comments
1 min read
Como normalizar banco de dados?

Como normalizar banco de dados?

9
Comments
2 min read
MongoDB vs Redis: A Comprehensive Comparison

MongoDB vs Redis: A Comprehensive Comparison

2
Comments 2
5 min read
How to Secure Your Supabase Database and Storage

How to Secure Your Supabase Database and Storage

2
Comments
6 min read
9 differences between IndexedDB and LocalStorage

9 differences between IndexedDB and LocalStorage

31
Comments 2
6 min read
Fundamentals of MongoDB (part 1) - architecture

Fundamentals of MongoDB (part 1) - architecture

6
Comments 1
3 min read
How to Calculate Median on Values That Have Corresponding Quantities

How to Calculate Median on Values That Have Corresponding Quantities

10
Comments
2 min read
Making FoodIntake, Part I

Making FoodIntake, Part I

Comments
3 min read
Easy no-code REST API for your databases

Easy no-code REST API for your databases

12
Comments 3
3 min read
A ImportĂąncia da CiĂȘncia de Dados no Mundo de Hoje

A ImportĂąncia da CiĂȘncia de Dados no Mundo de Hoje

Comments
3 min read
Unveiling the Power of Database-Side Rendering: Elevating Web Development Standards

Unveiling the Power of Database-Side Rendering: Elevating Web Development Standards

Comments
2 min read
How To Create a Linux Virtual Machine in Microsoft Azure - Password Authentication

How To Create a Linux Virtual Machine in Microsoft Azure - Password Authentication

Comments
5 min read
ReductStore CLI Client now in Rust

ReductStore CLI Client now in Rust

1
Comments
2 min read
8 Indexing Strategies to Optimize Database Performance

8 Indexing Strategies to Optimize Database Performance

1
Comments 1
8 min read
Analyzing Software Supply Chain Security with Graph Analytics

Analyzing Software Supply Chain Security with Graph Analytics

Comments
1 min read
Understanding SQL vs. NoSQL Databases: A Beginner's Guide

Understanding SQL vs. NoSQL Databases: A Beginner's Guide

3
Comments
2 min read
Data API for Amazon Aurora Serverless v2 with AWS SDK for Java - Part 5 Basic cold and warm starts measurements

Data API for Amazon Aurora Serverless v2 with AWS SDK for Java - Part 5 Basic cold and warm starts measurements

2
Comments
3 min read
Using SQL to discover problem dates in your data

Using SQL to discover problem dates in your data

Comments
10 min read
Time Series Blob Data: ReductStore vs. MongoDB

Time Series Blob Data: ReductStore vs. MongoDB

1
Comments
7 min read
PostgreSQL

PostgreSQL

1
Comments
3 min read
Emergence of Vector Databases

Emergence of Vector Databases

3
Comments
4 min read
End of ElephantSQL 😔

End of ElephantSQL 😔

18
Comments 4
1 min read
What You Possibly Don’t Know About Columnar Storage

What You Possibly Don’t Know About Columnar Storage

10
Comments
6 min read
DataDen - Coming Soon. Tailor Your Data, Your Way

DataDen - Coming Soon. Tailor Your Data, Your Way

Comments
2 min read
3 Proven Patterns for Reporting with Serverless

3 Proven Patterns for Reporting with Serverless

15
Comments
10 min read
Getting Started with SQL: An Overview of Its Role in Data Fields

Getting Started with SQL: An Overview of Its Role in Data Fields

Comments
3 min read
"ERROR: Perform RPC timed out after 602.000s" in YSQL

"ERROR: Perform RPC timed out after 602.000s" in YSQL

1
Comments
2 min read
Introducing GreptimeDB v0.7 — Unlock the Future of Cloud-Native Monitoring

Introducing GreptimeDB v0.7 — Unlock the Future of Cloud-Native Monitoring

Comments
6 min read
How do you check the top IOPs intensive queries in PostgreSQL DB?

How do you check the top IOPs intensive queries in PostgreSQL DB?

Comments
2 min read
How to find the number of SELECTs, INSERTs, DELETEs, and UPDATEs on a specific table in PostgreSQL?

How to find the number of SELECTs, INSERTs, DELETEs, and UPDATEs on a specific table in PostgreSQL?

2
Comments
1 min read
How to check the distribution of timestamps in a PostgreSQL table?

How to check the distribution of timestamps in a PostgreSQL table?

Comments
3 min read
C# MongoDB Insert Benchmarks – What You Need To Know

C# MongoDB Insert Benchmarks – What You Need To Know

1
Comments 1
6 min read
How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

Comments
2 min read
Unveiling Differences: A Deep Dive into Comparing Tables, Indexes, and Functions Across PostgreSQL Databases

Unveiling Differences: A Deep Dive into Comparing Tables, Indexes, and Functions Across PostgreSQL Databases

Comments
7 min read
PostgreSQL. How do you find potentially ineffective indexes?

PostgreSQL. How do you find potentially ineffective indexes?

1
Comments
2 min read
đŸȘ„ DuckDB sql hack : get things SORTED w/ constraint CHECK

đŸȘ„ DuckDB sql hack : get things SORTED w/ constraint CHECK

2
Comments 2
3 min read
Setting Up Your Database (Next.js)

Setting Up Your Database (Next.js)

3
Comments
2 min read
C# Testcontainers for MongoDB: How To Easily Run Local Databases

C# Testcontainers for MongoDB: How To Easily Run Local Databases

1
Comments 1
7 min read
How to scale a crawler for 1000 websites

How to scale a crawler for 1000 websites

1
Comments
2 min read
PostgreSQL with modern storage: what about a lower random_page_cost?

PostgreSQL with modern storage: what about a lower random_page_cost?

8
Comments 4
11 min read
MongoDB and Load Balancer Support

MongoDB and Load Balancer Support

Comments
9 min read
Manipulando Datas com SQL Server

Manipulando Datas com SQL Server

2
Comments
7 min read
The best free database providers in 2024

The best free database providers in 2024

12
Comments 1
5 min read
Latest row per group in PostgreSQL

Latest row per group in PostgreSQL

4
Comments
12 min read
A new serverless Postgres platform

A new serverless Postgres platform

1
Comments
10 min read
How To Delete Documents From MongoDB In C# – What You Need To Know

How To Delete Documents From MongoDB In C# – What You Need To Know

Comments
6 min read
Connecting a Node.js App to MongoDB - while listening to techno, because thats more fun đŸŽ¶

Connecting a Node.js App to MongoDB - while listening to techno, because thats more fun đŸŽ¶

1
Comments
1 min read
Astro DB: Migrating my analytics data from Vercel Postgres

Astro DB: Migrating my analytics data from Vercel Postgres

6
Comments
4 min read
How To Update MongoDB Documents in C# – What You Need To Know

How To Update MongoDB Documents in C# – What You Need To Know

Comments
6 min read
Integrating Apache Hive — Offline Data for OpenMLDB

Integrating Apache Hive — Offline Data for OpenMLDB

Comments
4 min read
What is Surrogate Key in SQL?

What is Surrogate Key in SQL?

Comments
2 min read
Time Series Blob Data: ReductStore vs. TimescaleDB

Time Series Blob Data: ReductStore vs. TimescaleDB

1
Comments
5 min read
loading...