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.
Your Free and Offline SQL console in a few steps

Your Free and Offline SQL console in a few steps

1
Comments
5 min read
Rust SQLx CLI: database migration with MySQL and PostgreSQL.

Rust SQLx CLI: database migration with MySQL and PostgreSQL.

1
Comments
11 min read
instant distributed database- gun.js

instant distributed database- gun.js

18
Comments
2 min read
MongoDB Quick Start Guide 🍃⚡️

MongoDB Quick Start Guide 🍃⚡️

25
Comments 4
9 min read
Replicating Data from Oracle to PostgreSQL - A Comprehensive Guide

Replicating Data from Oracle to PostgreSQL - A Comprehensive Guide

Comments
3 min read
Optimistic Locking (Rails internals again)

Optimistic Locking (Rails internals again)

6
Comments
4 min read
Understanding PostgreSQL and its Strong Embrace of ACID Properties

Understanding PostgreSQL and its Strong Embrace of ACID Properties

1
Comments
3 min read
SPL computing performance test series: position association

SPL computing performance test series: position association

1
Comments
12 min read
WTH is Prompt Engineering?

WTH is Prompt Engineering?

26
Comments 6
7 min read
Create a stored procedure with Sql Server

Create a stored procedure with Sql Server

2
Comments
10 min read
10 NoSQL databases available as alternatives to MongoDB

10 NoSQL databases available as alternatives to MongoDB

2
Comments
4 min read
ClickHouse ReplacingMergeTree Engine: The Airport & Flights Metaphor

ClickHouse ReplacingMergeTree Engine: The Airport & Flights Metaphor

5
Comments
2 min read
Novice Guide to Securing API and Firebase Key In React Vite using dotenv(Environment Veriable).

Novice Guide to Securing API and Firebase Key In React Vite using dotenv(Environment Veriable).

1
Comments 2
2 min read
Seed different data for the different environment with Sequelize.

Seed different data for the different environment with Sequelize.

Comments
3 min read
Coding the Cloud ☁️: A Deep Dive into AWS Database Migration Magic 🪄

Coding the Cloud ☁️: A Deep Dive into AWS Database Migration Magic 🪄

Comments
11 min read
What If You Only Need One Table for Your Entire Database System?

What If You Only Need One Table for Your Entire Database System?

4
Comments 4
4 min read
How About Ditching the Hype: Do We Really Need a Specialized Vector Database?

How About Ditching the Hype: Do We Really Need a Specialized Vector Database?

3
Comments 1
2 min read
MariaDB, MySQL, and Node.js: Why Using the Right Connector Matters

MariaDB, MySQL, and Node.js: Why Using the Right Connector Matters

8
Comments
4 min read
Introduction to PostgreSQL (Coding Style) Part-2

Introduction to PostgreSQL (Coding Style) Part-2

Comments
3 min read
Speed up your PostgreSQL bulk inserts with COPY

Speed up your PostgreSQL bulk inserts with COPY

33
Comments 5
5 min read
LiteDB: Um banco de dados NoSQL simples e poderoso para dotnet!

LiteDB: Um banco de dados NoSQL simples e poderoso para dotnet!

10
Comments
9 min read
How to Get Started with Xata: Try Our New Getting Started Guides

How to Get Started with Xata: Try Our New Getting Started Guides

8
Comments
4 min read
DuckDB: Discovering High-Performance Embedded Database!

DuckDB: Discovering High-Performance Embedded Database!

Comments
1 min read
NoSQL Databases

NoSQL Databases

Comments 2
2 min read
Building a feature platform guided by your ethos

Building a feature platform guided by your ethos

1
Comments
10 min read
Develop over a full database managed service on your laptop!

Develop over a full database managed service on your laptop!

6
Comments
3 min read
CAP Theorem: Why Perfect Distributed Systems Don't Exist?

CAP Theorem: Why Perfect Distributed Systems Don't Exist?

8
Comments
5 min read
Introducing pgroll: Zero-downtime, Reversible, Schema Migrations for Postgres

Introducing pgroll: Zero-downtime, Reversible, Schema Migrations for Postgres

3
Comments
5 min read
Multi-tenant database patterns - through a SaaS lens

Multi-tenant database patterns - through a SaaS lens

1
Comments
7 min read
Understanding SQL Types of Indexes: A Beginner's Guide

Understanding SQL Types of Indexes: A Beginner's Guide

21
Comments 2
3 min read
Basics of Database Indexing

Basics of Database Indexing

4
Comments
4 min read
How to use PostgreSQL with Haskell: rel8

How to use PostgreSQL with Haskell: rel8

4
Comments
6 min read
How to use PostgreSQL with Haskell: opaleye

How to use PostgreSQL with Haskell: opaleye

Comments
6 min read
Bring (and Take) Your Own Data With CSV Import and Export

Bring (and Take) Your Own Data With CSV Import and Export

5
Comments
4 min read
How to use PostgreSQL with Haskell: squeal

How to use PostgreSQL with Haskell: squeal

2
Comments
7 min read
Building Interactive Snowflake Data Apps with Streamlit

Building Interactive Snowflake Data Apps with Streamlit

1
Comments
3 min read
How to use PostgreSQL with Haskell. Elephantine library review 2023

How to use PostgreSQL with Haskell. Elephantine library review 2023

Comments
4 min read
How to use PostgreSQL with Haskell: postgresql-simple

How to use PostgreSQL with Haskell: postgresql-simple

Comments
7 min read
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
loading...