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

6
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#)

19
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

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

[SQL Performance Killers] Individual inserts vs. Bulk inserts

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

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

18
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

3
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
TypeORM - remove children with orphanedRowAction

TypeORM - remove children with orphanedRowAction

7
Comments
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
Power of Database Transactions in PHP: Ensuring Data Integrity

Power of Database Transactions in PHP: Ensuring Data Integrity

2
Comments
2 min read
Using Dapper - C# Part 1-A

Using Dapper - C# Part 1-A

20
Comments
6 min read
Deleting a cluster in Big Animal

Deleting a cluster in Big Animal

Comments
2 min read
Redis: A Comparison with Other Databases (Bite-size Article)

Redis: A Comparison with Other Databases (Bite-size Article)

4
Comments
4 min read
MongoDB Aggregation In-Depth: Fundamentals and Pipeline Mastery

MongoDB Aggregation In-Depth: Fundamentals and Pipeline Mastery

14
Comments 1
4 min read
Proxy Servers, Redundancy, and Replication: A Deep Dive into System Design 🌐🔐🚀

Proxy Servers, Redundancy, and Replication: A Deep Dive into System Design 🌐🔐🚀

9
Comments
3 min read
Java Class Libraries that Boost Application Development Efficiency

Java Class Libraries that Boost Application Development Efficiency

5
Comments
5 min read
Restore your MySQL Database on PlanetScale

Restore your MySQL Database on PlanetScale

5
Comments
2 min read
Restore or Migrate your MySQL Database to Railway

Restore or Migrate your MySQL Database to Railway

4
Comments
3 min read
PostGraphile — The Gateway Drug To GraphQL

PostGraphile — The Gateway Drug To GraphQL

Comments
10 min read
Recommendation Engines with Graph Databases using Apache AGE

Recommendation Engines with Graph Databases using Apache AGE

Comments
3 min read
Supercharge Your Rails App: Inserting 1 Million Records in 15s

Supercharge Your Rails App: Inserting 1 Million Records in 15s

12
Comments 3
6 min read
My Takeaways from "How Query Engines Work"

My Takeaways from "How Query Engines Work"

Comments
1 min read
What is System Design?

What is System Design?

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

1
Comments
7 min read
Designing Database for a Flight Ticket Booking System in a Startup: A Tale of MVP and Scalability

Designing Database for a Flight Ticket Booking System in a Startup: A Tale of MVP and Scalability

8
Comments 1
3 min read
Testing a Data Science Model [Testμ 2023]

Testing a Data Science Model [Testμ 2023]

1
Comments
4 min read
How to use PostgreSQL with Haskell: beam

How to use PostgreSQL with Haskell: beam

1
Comments
7 min read
The Best ORMs for Node.js App Development in 2023

The Best ORMs for Node.js App Development in 2023

5
Comments 1
5 min read
Say hello to the new "System design series by @mukeshkuiry"

Say hello to the new "System design series by @mukeshkuiry"

10
Comments 1
1 min read
How to use PostgreSQL with Haskell: selda

How to use PostgreSQL with Haskell: selda

Comments
5 min read
Top 10 tips for instrumenting Golang with New Relic, part 3

Top 10 tips for instrumenting Golang with New Relic, part 3

Comments
7 min read
Taking Backup of your Kubernetes etcd Data: A step-by-step guide

Taking Backup of your Kubernetes etcd Data: A step-by-step guide

7
Comments
6 min read
Postgres Order By: the resultset is sorted differently

Postgres Order By: the resultset is sorted differently

1
Comments
1 min read
A Comprehensive Dive into the New Time-Series Storage Engine - Mito

A Comprehensive Dive into the New Time-Series Storage Engine - Mito

2
Comments
5 min read
Database GitOps with Bytebase for PostgreSQL

Database GitOps with Bytebase for PostgreSQL

12
Comments 1
3 min read
loading...