close
The Wayback Machine - https://web.archive.org/web/20231126222048/https://dev.to/t/database

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.
Soft introduction to Dapper and EF Core

Soft introduction to Dapper and EF Core

Comments
5 min read
How to Shrink EBS Volumes

How to Shrink EBS Volumes

Comments
6 min read
Very basic introduction (revision tool) to SQL

Very basic introduction (revision tool) to SQL

Image 1
Comments
2 min read
Multiple Regression

Multiple Regression

Image 2
Comments
2 min read
It's not surprising that it's N times faster than ORACLE, such lightweight is the king

It's not surprising that it's N times faster than ORACLE, such lightweight is the king

Image 2
Comments
7 min read
Structured Query Language (SQL) - Series

Structured Query Language (SQL) - Series

Image Image Image 4
Comments
2 min read
Evaluating performance of time series collections

Evaluating performance of time series collections

Image 1
Comments
12 min read
A Comprehensive Guide to SQL Query Optimization Techniques

A Comprehensive Guide to SQL Query Optimization Techniques

Image 1
Comments 1
2 min read
How We Optimized Dragonfly to Get 30x Throughput with BullMQ

How We Optimized Dragonfly to Get 30x Throughput with BullMQ

Comments
13 min read
Why do we NOLOCK in SQL server with an example

Why do we NOLOCK in SQL server with an example

Image 1
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

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

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

Comments
2 min read
Leveraging Apache Age for Advanced Data Analytics

Leveraging Apache Age for Advanced Data Analytics

Image 1
Comments
3 min read
Google FireStore Data Source Plugin for Grafana.

Google FireStore Data Source Plugin for Grafana.

Comments
1 min read
Partition Strategies: Fundamental Concepts for PostgreSQL Partitioning

Partition Strategies: Fundamental Concepts for PostgreSQL Partitioning

Image 3
Comments
4 min read
TableSpace ;

TableSpace ;

Comments
5 min read
Modern Database Management Explained

Modern Database Management Explained

Image 1
Comments
13 min read
Three tips to reduce MongoDB database size

Three tips to reduce MongoDB database size

Image 1
Comments
4 min read
How to use Redis as a search database

How to use Redis as a search database

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

Introdução aos Dados Geoespaciais no MongoDB

Comments
3 min read
Understanding simple-pgvector-python: A Tool for Vector Search in Python

Understanding simple-pgvector-python: A Tool for Vector Search in Python

Image Image Image Image Image 5
Comments
1 min read
A Solution for Retrieving Quiz URL IDs from Moodle's Database

A Solution for Retrieving Quiz URL IDs from Moodle's Database

Comments
2 min read
Unveiling the Robust Architecture of SQL Server A Comprehensive Overview

Unveiling the Robust Architecture of SQL Server A Comprehensive Overview

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

How Metis Detects Too Many Open Connections on Postgres

Comments
3 min read
Dominando JOINs no SQL: Guia Completo

Dominando JOINs no SQL: Guia Completo

Image 1
Comments
4 min read
DATA ENGINEERING ROADMAP FOR BEGINNERS.

DATA ENGINEERING ROADMAP FOR BEGINNERS.

Comments
8 min read
The Comprehensive Guide to Time Series Models: Navigating the Depths of Temporal Data

The Comprehensive Guide to Time Series Models: Navigating the Depths of Temporal Data

Comments
2 min read
O que são triggers?

O que são triggers?

Image 1
Comments
2 min read
PostgreSQL. How to list the most IOPs-intensive queries?

PostgreSQL. How to list the most IOPs-intensive queries?

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

PostgreSQL and NoSQL: Bridging the Gap with JSON and Hstore

Comments
3 min read
Unlocking the Power of Apache Age: Advanced Techniques for SQL/Cypher Hybrid Queries

Unlocking the Power of Apache Age: Advanced Techniques for SQL/Cypher Hybrid Queries

Comments
2 min read
Explicando ORM (Object Relational Mapping)

Explicando ORM (Object Relational Mapping)

Image 2
Comments 3
2 min read
PostgreSQL: script to connect to DB, and get tables, their records number and size.

PostgreSQL: script to connect to DB, and get tables, their records number and size.

Image 1
Comments 1
2 min read
Group By, Grouping Sets, Cube, and Rollup Queries in SQL

Group By, Grouping Sets, Cube, and Rollup Queries in SQL

Comments
5 min read
TypeORM - remove children with orphanedRowAction

TypeORM - remove children with orphanedRowAction

Image Image 3
Comments
2 min read
Comparing Types of Databases: A Real-World Benchmark Analysis

Comparing Types of Databases: A Real-World Benchmark Analysis

Comments
8 min read
Connecting Alpine.js to a Database REST API: A Simple Guide

Connecting Alpine.js to a Database REST API: A Simple Guide

Image Image Image Image Image 8
Comments
3 min read
Mastering Graph Queries with Cypher in Apache Age

Mastering Graph Queries with Cypher in Apache Age

Comments
3 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
Equipping yourself with Excel increase job opportunities

Equipping yourself with Excel increase job opportunities

Image Image 4
Comments
2 min read
Restore your MySQL Database on PlanetScale

Restore your MySQL Database on PlanetScale

Image Image Image 4
Comments
2 min read
Running BullMQ with Dragonfly

Running BullMQ with Dragonfly

Comments
6 min read
Object Relationships in Room ORM Library for Android

Object Relationships in Room ORM Library for Android

Image Image Image Image 4
Comments 1
12 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
World Best Database Documentation Tool - "Prisma Markdown"

World Best Database Documentation Tool - "Prisma Markdown"

Image Image Image Image Image 20
Comments 2
4 min read
The Hallucinated Rows Incident

The Hallucinated Rows Incident

Image Image Image 6
Comments 1
11 min read
Unlocking the Power of Python: The Vital Role of SQLAlchemy

Unlocking the Power of Python: The Vital Role of SQLAlchemy

Image Image Image 8
Comments 2
3 min read
Keep your files safe. What can happen if you throw away a defective hard drive?

Keep your files safe. What can happen if you throw away a defective hard drive?

Image Image Image Image 6
Comments 1
8 min read
Secure Connection between Lambda and RDS: Choosing and Implementing SSL/TLS Certificates

Secure Connection between Lambda and RDS: Choosing and Implementing SSL/TLS Certificates

Image Image Image Image 7
Comments
2 min read
Solving duplicate data with performant deduplication

Solving duplicate data with performant deduplication

Comments
8 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)

Image 1
Comments
5 min read
Ensuring Quality in Data & AI: A Comprehensive Approach to Quality in the Age of Data & AI [Testμ 2023]

Ensuring Quality in Data & AI: A Comprehensive Approach to Quality in the Age of Data & AI [Testμ 2023]

Image 1
Comments
7 min read
PostgreSQL's Emerging Role in Decentralized Applications(DApps)

PostgreSQL's Emerging Role in Decentralized Applications(DApps)

Image 1
Comments 1
3 min read
Comparing Graph Databases with Relational Databases

Comparing Graph Databases with Relational Databases

Image 1
Comments
3 min read
SQL Server - Types of System Databases and Tables

SQL Server - Types of System Databases and Tables

Image Image Image 4
Comments
3 min read
Instalar y Configurar Oracle 12c 12.1.0.2 SE en Docker y Ubuntu 20.04 LTS (Single Instace)

Instalar y Configurar Oracle 12c 12.1.0.2 SE en Docker y Ubuntu 20.04 LTS (Single Instace)

Image 1
Comments
4 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?

Image Image Image Image 4
Comments
2 min read
Locks, latches & distributed system coordination

Locks, latches & distributed system coordination

Comments
9 min read
Digging into Marten query sets

Digging into Marten query sets

Image Image Image 4
Comments
8 min read
loading...