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 Use MySQL Database in Total.js with QueryBuilderMySQL?

How to Use MySQL Database in Total.js with QueryBuilderMySQL?

Comments
5 min read
Announcing Dragonfly Kubernetes Operator General Availability

Announcing Dragonfly Kubernetes Operator General Availability

Comments
5 min read
Building a Real-Time Ad Server with Dragonfly

Building a Real-Time Ad Server with Dragonfly

Comments
9 min read
Simplifying architecture for a hotel management SaaS solution

Simplifying architecture for a hotel management SaaS solution

1
Comments
4 min read
What Are ORMs & Should You Use Them

What Are ORMs & Should You Use Them

Comments
7 min read
Unlocking the Power of Python: The Vital Role of SQLAlchemy

Unlocking the Power of Python: The Vital Role of SQLAlchemy

3
Comments 2
3 min read
Database in System Design | Relational & Non-relational Database

Database in System Design | Relational & Non-relational Database

6
Comments
4 min read
TableSpace ;

TableSpace ;

5
Comments
5 min read
Dominando JOINs no SQL: Guia Completo

Dominando JOINs no SQL: Guia Completo

2
Comments
4 min read
Super Easy Database Documentation Tool - "Prisma Markdown"

Super Easy Database Documentation Tool - "Prisma Markdown"

31
Comments 4
4 min read
What is the CASE Statement in sql?

What is the CASE Statement in sql?

5
Comments
2 min read
Modern Database Management Explained

Modern Database Management Explained

1
Comments
13 min read
SQL 📊 challenge_3 ⚔️

SQL 📊 challenge_3 ⚔️

Comments
1 min read
Spring JDBC: Where Java Meets the Database, with a Dash of Humor!

Spring JDBC: Where Java Meets the Database, with a Dash of Humor!

6
Comments
3 min read
PostgreSQL Internals: A Deep Dive into the Inner Workings of a Powerful Relational Database

PostgreSQL Internals: A Deep Dive into the Inner Workings of a Powerful Relational Database

8
Comments
3 min read
Easy tips to reduce MongoDB database size in no time

Easy tips to reduce MongoDB database size in no time

1
Comments
4 min read
Unleashing the Power of Indexes in PostgreSQL

Unleashing the Power of Indexes in PostgreSQL

Comments 1
2 min read
How to prevent database problems from hitting production?

How to prevent database problems from hitting production?

Comments
10 min read
Foreign Keys on Distributed SQL: don't worry, it scales

Foreign Keys on Distributed SQL: don't worry, it scales

1
Comments
6 min read
7 Tips to Optimise Postgres query performance

7 Tips to Optimise Postgres query performance

1
Comments
1 min read
Indexes 101: What They Are, Why They Matter, and How to Use Them in PostgreSQL

Indexes 101: What They Are, Why They Matter, and How to Use Them in PostgreSQL

2
Comments
6 min read
Data Modelling In AGE:Common Data Modelling Mistakes To Avoid

Data Modelling In AGE:Common Data Modelling Mistakes To Avoid

Comments
2 min read
PostgreSQL Extension: ApacheAGE

PostgreSQL Extension: ApacheAGE

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

1
Comments
5 min read
CAP Theorem

CAP Theorem

3
Comments 1
2 min read
How To Write SQL Statements That Are Migratable Between Databases

How To Write SQL Statements That Are Migratable Between Databases

5
Comments
4 min read
PostgreSQL's Emerging Role in Decentralized Applications(DApps)

PostgreSQL's Emerging Role in Decentralized Applications(DApps)

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

PostgreSQL and NoSQL: Bridging the Gap with JSON and Hstore

1
Comments
3 min read
Backing up and restoring in EDB BigAnimal

Backing up and restoring in EDB BigAnimal

Comments
2 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
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.

1
Comments 1
2 min read
Easily Generate Mock Data with PostgreSQL

Easily Generate Mock Data with PostgreSQL

5
Comments
4 min read
SQLite OR Operator: A Comprehensive Guide for Beginners

SQLite OR Operator: A Comprehensive Guide for Beginners

Comments
3 min read
From MS-Access to EF Core (C#)

From MS-Access to EF Core (C#)

21
Comments
5 min read
Lets Explore LSM Tree

Lets Explore LSM Tree

21
Comments 2
2 min read
DynamoDB Transactions: An E-Commerce with Amazon DynamoDB

DynamoDB Transactions: An E-Commerce with Amazon DynamoDB

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

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

6
Comments
1 min read
🚛 Deploy Database Schema Migrations with Bytebase

🚛 Deploy Database Schema Migrations with Bytebase

14
Comments
5 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)

5
Comments
4 min read
[SQL Performance Killers] Individual inserts vs. Bulk inserts

[SQL Performance Killers] Individual inserts vs. Bulk inserts

2
Comments
2 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
PostgreSQL. How to list the most IOPs-intensive queries?

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

3
Comments
1 min read
PostgreSQL - Change The Type Of A Column, A Walkthrough With Examples

PostgreSQL - Change The Type Of A Column, A Walkthrough With Examples

Comments
5 min read
Mastering Graph Queries with Cypher in Apache Age

Mastering Graph Queries with Cypher in Apache Age

Comments
3 min read
AutoGPT gives up vector databases, Do we still need them?

AutoGPT gives up vector databases, Do we still need them?

Comments
3 min read
Database to go! The perfect database for developer

Database to go! The perfect database for developer

1
Comments
6 min read
Explicando ORM (Object Relational Mapping)

Explicando ORM (Object Relational Mapping)

2
Comments 3
2 min read
Demystifying Materialized Views in PostgreSQL

Demystifying Materialized Views in PostgreSQL

11
Comments 2
7 min read
Data Engineering For Beginners: A Step-By-Step Guide

Data Engineering For Beginners: A Step-By-Step Guide

20
Comments
8 min read
The Easy MySQL Security In-Depth Guide to Best Practices

The Easy MySQL Security In-Depth Guide to Best Practices

Comments
13 min read
Uncovering Inventory Insights:Mintclassics (Coursera)

Uncovering Inventory Insights:Mintclassics (Coursera)

Comments
2 min read
How to reduce MongoDB database size just by changing json structure

How to reduce MongoDB database size just by changing json structure

15
Comments
4 min read
How to Create a Database for Small Business

How to Create a Database for Small Business

Comments
12 min read
Ruby Dive in the C: Make a Ruby-Pg lite extension

Ruby Dive in the C: Make a Ruby-Pg lite extension

4
Comments
4 min read
💾 Automatiser le « backup » d'une base de donnée MySQL avec NestJS et TypeORM

💾 Automatiser le « backup » d'une base de donnée MySQL avec NestJS et TypeORM

1
Comments
12 min read
Lessons Learned from Accidentally Deleting a Production Database

Lessons Learned from Accidentally Deleting a Production Database

2
Comments
5 min read
Various storage techniques in data storage 🗄️

Various storage techniques in data storage 🗄️

6
Comments
2 min read
Import data from a database with Dapper and SpreadsheetLight to Excel in C#

Import data from a database with Dapper and SpreadsheetLight to Excel in C#

7
Comments
4 min read
Ubuntu 20.x, 22.x PostgreSQL 15 Yedekli Yapı - Patroni, ETCD, HA - Patroni Yeni Node Ekleme

Ubuntu 20.x, 22.x PostgreSQL 15 Yedekli Yapı - Patroni, ETCD, HA - Patroni Yeni Node Ekleme

4
Comments
5 min read
Is co-partition or interleave necessary in Distributed SQL?

Is co-partition or interleave necessary in Distributed SQL?

Comments
8 min read
loading...