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.
Getting Started with Apache Age and Age Viewer

Getting Started with Apache Age and Age Viewer

2
Comments
3 min read
Designing Your Database Schema

Designing Your Database Schema

Comments
10 min read
Multiple Result Sets for SQL-Server (C#) including Dapper

Multiple Result Sets for SQL-Server (C#) including Dapper

8
Comments 2
6 min read
Optimizing PostgreSQL Configuration with PgTune

Optimizing PostgreSQL Configuration with PgTune

Comments 1
2 min read
AgensSQL vs. Other Relational DBMS

AgensSQL vs. Other Relational DBMS

3
Comments
3 min read
Using Supabase as a database and image store with Strapi CMS.

Using Supabase as a database and image store with Strapi CMS.

4
Comments 5
2 min read
MySQL Database Migration to a Remote Server from a .gz mysqldump file

MySQL Database Migration to a Remote Server from a .gz mysqldump file

Comments
10 min read
Balanced vs Unbalanced

Balanced vs Unbalanced

Comments
5 min read
Auto-Synchronizing an Entire MySQL Database for Data Analysis

Auto-Synchronizing an Entire MySQL Database for Data Analysis

Comments
5 min read
SPL computing performance test series: multi-index aggregating

SPL computing performance test series: multi-index aggregating

1
Comments
6 min read
Revolutionizing Database Scaling with CitusDB

Revolutionizing Database Scaling with CitusDB

Comments
1 min read
Zero-Cost Database Magic 🪄💾

Zero-Cost Database Magic 🪄💾

15
Comments 2
3 min read
How To Build a High-Concurrency Ticket Booking System With Prisma

How To Build a High-Concurrency Ticket Booking System With Prisma

106
Comments 12
5 min read
Optimizing Database Queries - Navigating One-to-Many Relationships with Xata's New Approach

Optimizing Database Queries - Navigating One-to-Many Relationships with Xata's New Approach

Comments
4 min read
Getting started with Xata

Getting started with Xata

Comments
6 min read
Apache AGE: Unique Use Cases

Apache AGE: Unique Use Cases

1
Comments
2 min read
Demystifying Serverless Databases

Demystifying Serverless Databases

Comments
4 min read
Optimizing SQL Performance with Execution Plans

Optimizing SQL Performance with Execution Plans

8
Comments
3 min read
Association Accessors

Association Accessors

1
Comments
2 min read
Introducing MonkeyslegionDB: A Specialized Database Connection Manager for PHP

Introducing MonkeyslegionDB: A Specialized Database Connection Manager for PHP

1
Comments
2 min read
How to update multiple rows based on list of key-val pairs (in MySQL, MariaDB, & PostgreSQL)

How to update multiple rows based on list of key-val pairs (in MySQL, MariaDB, & PostgreSQL)

Comments
2 min read
Active record vs Object mapper ORM

Active record vs Object mapper ORM

13
Comments
2 min read
How Modern SQL Databases Are Changing Web Development - #2 New Ways to Program

How Modern SQL Databases Are Changing Web Development - #2 New Ways to Program

38
Comments 1
5 min read
SurrealDB: Version 1.0 🥇 Just Released! Next Gen SQL Database?

SurrealDB: Version 1.0 🥇 Just Released! Next Gen SQL Database?

1
Comments
3 min read
Picking the Perfect Database for Your Microservices

Picking the Perfect Database for Your Microservices

7
Comments
8 min read
Revolutionizing Database Services: An Inside Look at Sealos and KubeBlocks

Revolutionizing Database Services: An Inside Look at Sealos and KubeBlocks

1
Comments
4 min read
Web Scraping Car Sites to Help Me Shop Better

Web Scraping Car Sites to Help Me Shop Better

3
Comments 1
7 min read
Setting the Stage: Unraveling MongoDB Query Performance

Setting the Stage: Unraveling MongoDB Query Performance

1
Comments
7 min read
An Honest Question: Do you put relational data in Google Firestore?

An Honest Question: Do you put relational data in Google Firestore?

Comments
2 min read
Simple API CRUD done with ExpressoTS and Postgres

Simple API CRUD done with ExpressoTS and Postgres

24
Comments
4 min read
Resolving PostgreSQL Database Connection Issues with dblink on Amazon RDS

Resolving PostgreSQL Database Connection Issues with dblink on Amazon RDS

1
Comments
3 min read
Is MongoDB Good For Data Analytics? Let's Find Out!

Is MongoDB Good For Data Analytics? Let's Find Out!

10
Comments
4 min read
Detailed Introduction To Prisma ORM

Detailed Introduction To Prisma ORM

18
Comments
5 min read
PostgreSQL 16 Installation on Ubuntu 22.04

PostgreSQL 16 Installation on Ubuntu 22.04

8
Comments 9
2 min read
Auto-scaling DynamoDB Streams applications on Kubernetes

Auto-scaling DynamoDB Streams applications on Kubernetes

5
Comments
12 min read
How Apache AGE Works on Top of PostgreSQL

How Apache AGE Works on Top of PostgreSQL

Comments
3 min read
Fortify Your Database: Supabase's Row Level Security

Fortify Your Database: Supabase's Row Level Security

2
Comments
3 min read
Fazendo Comandos SQL

Fazendo Comandos SQL

5
Comments
4 min read
My Database History

My Database History

6
Comments
4 min read
Comparison of Search and Information Retrieval Technologies

Comparison of Search and Information Retrieval Technologies

1
Comments
2 min read
Seeding Database With Drizzle ORM

Seeding Database With Drizzle ORM

6
Comments 1
2 min read
File attachment in Xata Database: How to build an Online Library.

File attachment in Xata Database: How to build an Online Library.

7
Comments
6 min read
Meet Five: A Popular FileMaker Alternative

Meet Five: A Popular FileMaker Alternative

Comments
13 min read
Query Like a Pro: Active Record for Database Queries

Query Like a Pro: Active Record for Database Queries

4
Comments
4 min read
Comparison between Apache AGE and other popular graph databases.

Comparison between Apache AGE and other popular graph databases.

1
Comments
3 min read
Understanding Joins in SQL

Understanding Joins in SQL

4
Comments 2
3 min read
Optimizing Pagination: Range-Based Queries with Cursors and Happy Databases 🚀

Optimizing Pagination: Range-Based Queries with Cursors and Happy Databases 🚀

3
Comments
4 min read
Comparing SQL and Cypher Query Language

Comparing SQL and Cypher Query Language

Comments
2 min read
How We Achieved Minimal Downtime During Our PostgreSQL Database Upgrade

How We Achieved Minimal Downtime During Our PostgreSQL Database Upgrade

1
Comments
1 min read
How to use IndexedDB to store images and other files in your browser

How to use IndexedDB to store images and other files in your browser

1
Comments 1
7 min read
🚀Remove by query API in API Maker

🚀Remove by query API in API Maker

10
Comments
2 min read
Exploring PostgreSQL Extensions: Enhance Your Database Capabilities

Exploring PostgreSQL Extensions: Enhance Your Database Capabilities

2
Comments
2 min read
🐘Top Postgres GUI Clients to Master Postgres☄️🦖

🐘Top Postgres GUI Clients to Master Postgres☄️🦖

29
Comments 3
3 min read
Discover the Hidden Powers of PostgreSQL: Lateral Joins and JSON Columns Decoded!

Discover the Hidden Powers of PostgreSQL: Lateral Joins and JSON Columns Decoded!

Comments
2 min read
Automatically Provision AWS Resources with Terraform

Automatically Provision AWS Resources with Terraform

2
Comments
6 min read
Data migrations in regular migrations and why you (probably) should not do that

Data migrations in regular migrations and why you (probably) should not do that

12
Comments 1
3 min read
Beyond the Basics:Custom Data Types and Functions in Postgresql

Beyond the Basics:Custom Data Types and Functions in Postgresql

3
Comments
3 min read
Troubleshooting PostgreSQL High CPU Usage - Part 2

Troubleshooting PostgreSQL High CPU Usage - Part 2

3
Comments
5 min read
Effective Data Modeling in PostgreSQL for Java Backend Developers

Effective Data Modeling in PostgreSQL for Java Backend Developers

Comments
3 min read
Efficient Representation of Relationships with Graph Databases

Efficient Representation of Relationships with Graph Databases

2
Comments
2 min read
loading...