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.
Embracing Open Source: A Catalyst for Scientific Progress

Embracing Open Source: A Catalyst for Scientific Progress

Comments
2 min read
Integrating Georeferenced Maps: Passing Data from Firebase Backend to Frontend

Integrating Georeferenced Maps: Passing Data from Firebase Backend to Frontend

Comments
1 min read
How to Transpose Rows to Columns on Multiple Fields in Each Group

How to Transpose Rows to Columns on Multiple Fields in Each Group

5
Comments 1
2 min read
Using AI on top of your DB

Using AI on top of your DB

Comments
1 min read
Criar massa de dados para teste

Criar massa de dados para teste

Comments
1 min read
Collection of Hands-on Exercises to Get Started with Apache Iceberg

Collection of Hands-on Exercises to Get Started with Apache Iceberg

Comments
4 min read
OCI - Restore DB System Backups across OCI Cloud regions is now available.

OCI - Restore DB System Backups across OCI Cloud regions is now available.

Comments
1 min read
All Your Monitoring Solutions Are Just Wrong

All Your Monitoring Solutions Are Just Wrong

Comments
8 min read
Running schema/database migrations using Geni

Running schema/database migrations using Geni

2
Comments
4 min read
Introducing usage monitoring in Xata

Introducing usage monitoring in Xata

Comments
5 min read
Discover the Latest in ApsaraDB for MongoDB 7.0 and How It Can Benefit Your Business

Discover the Latest in ApsaraDB for MongoDB 7.0 and How It Can Benefit Your Business

Comments
4 min read
Understanding Database Normalization: A Comprehensive Guide

Understanding Database Normalization: A Comprehensive Guide

Comments
4 min read
Iniciando no Elasticsearch: Conceitos básicos

Iniciando no Elasticsearch: Conceitos básicos

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

ACID properties of a database system.

Comments
1 min read
Boom 💥, Supabase Marks Its GA Milestone

Boom 💥, Supabase Marks Its GA Milestone

10
Comments 1
3 min read
Inside DuckDB: Deep Dive into DuckDB MetaPipeline

Inside DuckDB: Deep Dive into DuckDB MetaPipeline

Comments
1 min read
Xata Dedicated Clusters for PostgreSQL

Xata Dedicated Clusters for PostgreSQL

Comments
8 min read
Get started with Drizzle ORM and Xata's Postgres service

Get started with Drizzle ORM and Xata's Postgres service

Comments
3 min read
Database Education Needs Moderization

Database Education Needs Moderization

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

How to Calculate Median on Values That Have Corresponding Quantities

5
Comments
2 min read
Data Warehouse, Data Mart e Data Lake: Uma Visão Abrangente

Data Warehouse, Data Mart e Data Lake: Uma Visão Abrangente

Comments
3 min read
Move Fast and “Branch” Things

Move Fast and “Branch” Things

1
Comments
8 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
Migrating MySQL database to SQL Server Using Radzen Blazor Studio.

Migrating MySQL database to SQL Server Using Radzen Blazor Studio.

Comments
2 min read
Introducing pgzx: create PostgreSQL extensions using Zig

Introducing pgzx: create PostgreSQL extensions using Zig

Comments
10 min read
What happens when you type https://www.google.com in your browser and press Enter?

What happens when you type https://www.google.com in your browser and press Enter?

Comments
4 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
MongoDB Shell Commands - A Comprehensive Guide

MongoDB Shell Commands - A Comprehensive Guide

Comments
2 min read
MongoDB vs Redis: A Comprehensive Comparison

MongoDB vs Redis: A Comprehensive Comparison

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

Time Series Blob Data: ReductStore vs. MongoDB

1
Comments
7 min read
AWS Read Replica vs Multi-AZ

AWS Read Replica vs Multi-AZ

Comments
3 min read
Making FoodIntake, Part I

Making FoodIntake, Part I

Comments
3 min read
This is How You Build AI Apps Using the RAG Framework in 5 Minutes!

This is How You Build AI Apps Using the RAG Framework in 5 Minutes!

9
Comments
6 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
PostgreSQL. How do you find potentially ineffective indexes?

PostgreSQL. How do you find potentially ineffective indexes?

Comments
2 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
🪄 DuckDB sql hack : get things SORTED w/ constraint CHECK

🪄 DuckDB sql hack : get things SORTED w/ constraint CHECK

Comments 2
3 min read
Oracle Database - Identifying Session Tracefiles - without actually tracing them :-)

Oracle Database - Identifying Session Tracefiles - without actually tracing them :-)

2
Comments
4 min read
Oracle Database - Compare Execution Plans

Oracle Database - Compare Execution Plans

3
Comments
4 min read
How to assign the foreign key in the existing table.

How to assign the foreign key in the existing table.

Comments
2 min read
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

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

Time Series Blob Data: ReductStore vs. TimescaleDB

1
Comments
5 min read
MongoDB Filtering in C# – Beginner’s Guide For Easy Filters

MongoDB Filtering in C# – Beginner’s Guide For Easy Filters

Comments
5 min read
Are There “Queries over Trillion-Row Tables in Seconds”? Is “N-Times Faster Than ORACLE” an Exaggeration?

Are There “Queries over Trillion-Row Tables in Seconds”? Is “N-Times Faster Than ORACLE” an Exaggeration?

Comments
4 min read
Weekly Updates - Apr 12 2024

Weekly Updates - Apr 12 2024

2
Comments
1 min read
Core Count vs. Clock Speed: The Silent Cost Factor in Software Licensing

Core Count vs. Clock Speed: The Silent Cost Factor in Software Licensing

Comments
2 min read
Meet Datomic: the immutable and functional database.

Meet Datomic: the immutable and functional database.

76
Comments 10
9 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 Convert Dates in One Group into An Interval

How to Convert Dates in One Group into An Interval

5
Comments
2 min read
[HELP] PG Trigger on before update

[HELP] PG Trigger on before update

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

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

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

8 Indexing Strategies to Optimize Database Performance

Comments 1
8 min read
The Undistributed System

The Undistributed System

Comments
3 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

1
Comments
3 min read
Replacing Planetscale

Replacing Planetscale

Comments
8 min read
Scaling App Data in DynamoDB With Vertical Partitioning

Scaling App Data in DynamoDB With Vertical Partitioning

Comments
4 min read
How to Back Up and Restore Azure SQL Databases

How to Back Up and Restore Azure SQL Databases

1
Comments
8 min read
In a Multilevel Relationship, How to Replace Null Values at Nodes by Corresponding Values at Their Parent Nodes

In a Multilevel Relationship, How to Replace Null Values at Nodes by Corresponding Values at Their Parent Nodes

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

What You Possibly Don’t Know About Columnar Storage

5
Comments
6 min read
loading...