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.
End-To-End Polymorphism: From Database to UI, Achieving SOLID Design

End-To-End Polymorphism: From Database to UI, Achieving SOLID Design

20
Comments
10 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
The Undistributed System

The Undistributed System

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
Ultra High-Performance Database OpenM(ysq)LDB: Seamless Compatibility with MySQL Protocol and Multi-Language MySQL Client

Ultra High-Performance Database OpenM(ysq)LDB: Seamless Compatibility with MySQL Protocol and Multi-Language MySQL Client

Comments
6 min read
Vector Database solutions on AWS

Vector Database solutions on AWS

3
Comments 1
2 min read
Clear Vision, Not So Clear (or.. The User Is Me)

Clear Vision, Not So Clear (or.. The User Is Me)

4
Comments 2
3 min read
Variant in Apache Doris 2.1.0: a new data type 8 times faster than JSON for semi-structured data analysis

Variant in Apache Doris 2.1.0: a new data type 8 times faster than JSON for semi-structured data analysis

Comments
12 min read
PostgreSQL setup via homebrew for junior devs

PostgreSQL setup via homebrew for junior devs

1
Comments
1 min read
Unlocking the Potential: Best Databases for Python Projects

Unlocking the Potential: Best Databases for Python Projects

Comments
3 min read
Desentrañando el Proceso ETL: La Columna Vertebral de la Ciencia de Datos

Desentrañando el Proceso ETL: La Columna Vertebral de la Ciencia de Datos

Comments
2 min read
Configure Amazon RDS Proxy

Configure Amazon RDS Proxy

1
Comments
3 min read
Cómo Crear tu Primer Data Warehouse: Una Guía para Principiantes

Cómo Crear tu Primer Data Warehouse: Una Guía para Principiantes

1
Comments
3 min read
Propriedades ACID de uma transação em banco de dados.

Propriedades ACID de uma transação em banco de dados.

1
Comments
2 min read
Double bind the foreign key to avoid unnecessary JOIN in TypeORM

Double bind the foreign key to avoid unnecessary JOIN in TypeORM

Comments
3 min read
What is MySQL Throughput?

What is MySQL Throughput?

Comments
3 min read
How to Transpose Columns in Each Group to a Single Row

How to Transpose Columns in Each Group to a Single Row

7
Comments
2 min read
Handling NEW and OLD Immutability in PostgreSQL Triggers

Handling NEW and OLD Immutability in PostgreSQL Triggers

Comments
2 min read
Amazon DynamoDB: Scalable NoSQL for High-Performance Applications

Amazon DynamoDB: Scalable NoSQL for High-Performance Applications

1
Comments
3 min read
Multi-region, strongly consistent databases matter

Multi-region, strongly consistent databases matter

Comments
2 min read
Build a simple serverless CRUD App with Neon, PostgREST and REST API

Build a simple serverless CRUD App with Neon, PostgREST and REST API

Comments
6 min read
Graph Databases

Graph Databases

Comments
3 min read
Apache Doris 2.1.0: TPC-DS, Parallel Adaptive Scan, Local Shuffle, Arrow Flight-based HTTP Data API

Apache Doris 2.1.0: TPC-DS, Parallel Adaptive Scan, Local Shuffle, Arrow Flight-based HTTP Data API

Comments
29 min read
Introducing Map Projection in Apache AGE Open Cypher

Introducing Map Projection in Apache AGE Open Cypher

5
Comments 2
2 min read
Mastering Distributed Database Development in 10 Minutes with OpenMLDB Developer Docker Image

Mastering Distributed Database Development in 10 Minutes with OpenMLDB Developer Docker Image

Comments
3 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
Mastering the Art of Database Engineering Management: Key Skills for Success

Mastering the Art of Database Engineering Management: Key Skills for Success

1
Comments
2 min read
MySQL Latency. Breaking Down MySQL Latency – What It Is and Why It Matters

MySQL Latency. Breaking Down MySQL Latency – What It Is and Why It Matters

Comments
4 min read
Spin up a Free Hosted MongoDB Database in 5 Minutes

Spin up a Free Hosted MongoDB Database in 5 Minutes

Comments
2 min read
DocumentDB Vacuum Locks

DocumentDB Vacuum Locks

1
Comments
3 min read
Database for newbies: Hands On

Database for newbies: Hands On

87
Comments 6
6 min read
Qdrant 1.8.0 - Major Performance Enhancements

Qdrant 1.8.0 - Major Performance Enhancements

28
Comments
5 min read
Databases: A Beginner’s Guide

Databases: A Beginner’s Guide

Comments
8 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
YAML-based Database Docu

YAML-based Database Docu

Comments
2 min read
small/swoole-db 1.0.0

small/swoole-db 1.0.0

1
Comments
1 min read
Unlock SQLite: Easy Data Analysis for Busy Software Engineers

Unlock SQLite: Easy Data Analysis for Busy Software Engineers

Comments
1 min read
Migrating SQL Server to Azure SQL Database with SQL Server Management Studio (SSMS)

Migrating SQL Server to Azure SQL Database with SQL Server Management Studio (SSMS)

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

DataDen - Coming Soon. Tailor Your Data, Your Way

Comments
2 min read
PostgreSQL index Correlation with UPDATE

PostgreSQL index Correlation with UPDATE

9
Comments
17 min read
Typesafe PostgreSQL queries with Kysely and Neon

Typesafe PostgreSQL queries with Kysely and Neon

1
Comments
10 min read
🚀🚀🚀Implementing Redis Functionalities in Node.js Applications 📦

🚀🚀🚀Implementing Redis Functionalities in Node.js Applications 📦

1
Comments
4 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
Integrating Predictive Analytics Models into SQL Queries

Integrating Predictive Analytics Models into SQL Queries

2
Comments
14 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
Managing Concurrent Database Writes in a Distributed System with Redis or PostgreSQL

Managing Concurrent Database Writes in a Distributed System with Redis or PostgreSQL

6
Comments
3 min read
Supercharge Your Database: 25 Essential MySQL Query Optimization Techniques

Supercharge Your Database: 25 Essential MySQL Query Optimization Techniques

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

Integrating Apache Hive — Offline Data for OpenMLDB

Comments
4 min read
Optimizing PostgreSQL Queries with Function Volatility: Volatile, Stable, and Immutable

Optimizing PostgreSQL Queries with Function Volatility: Volatile, Stable, and Immutable

Comments
3 min read
Unraveling the Web: A Comprehensive Guide to Mastering SQL Joins

Unraveling the Web: A Comprehensive Guide to Mastering SQL Joins

Comments
3 min read
Redis reborn, a new chapter begins

Redis reborn, a new chapter begins

34
Comments 15
3 min read
Advanced Querying Techniques in Vector Databases

Advanced Querying Techniques in Vector Databases

18
Comments
7 min read
Next JS 14 | Setting Up Your Database

Next JS 14 | Setting Up Your Database

2
Comments
4 min read
A Quick and Comprehensive Guide On Which Database to Use in your next Fullstack Application

A Quick and Comprehensive Guide On Which Database to Use in your next Fullstack Application

Comments
3 min read
How to Bulk Import a CSV File Into MongoDB Using Multer With Node.js

How to Bulk Import a CSV File Into MongoDB Using Multer With Node.js

Comments
3 min read
Manipulating Dates with SQL Server

Manipulating Dates with SQL Server

1
Comments
5 min read
loading...