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

3
Comments
4 min read
Are you curious about DATABASES?

Are you curious about DATABASES?

Comments
2 min read
Intro to Relational DBMS

Intro to Relational DBMS

6
Comments
4 min read
SQLAlchemy data models relationship

SQLAlchemy data models relationship

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

Understanding PostgreSQL and its Strong Embrace of ACID Properties

2
Comments
3 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
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?

29
Comments 6
7 min read
ClickHouse ReplacingMergeTree Engine: The Airport & Flights Metaphor

ClickHouse ReplacingMergeTree Engine: The Airport & Flights Metaphor

5
Comments
2 min read
Create a stored procedure with Sql Server

Create a stored procedure with Sql Server

3
Comments
10 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).

3
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
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
LiteDB: Um banco de dados NoSQL simples e poderoso para dotnet!

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

14
Comments
9 min read
Speed up your PostgreSQL bulk inserts with COPY

Speed up your PostgreSQL bulk inserts with COPY

93
Comments 5
5 min read
DuckDB: Discovering High-Performance Embedded Database!

DuckDB: Discovering High-Performance Embedded Database!

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

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

2
Comments
10 min read
Connecting Slack To Five Using Webhooks

Connecting Slack To Five Using Webhooks

Comments
27 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
Association Accessors Helpers

Association Accessors Helpers

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

Develop over a full database managed service on your laptop!

3
Comments
3 min read
Log Analysis: How to Digest 15 Billion Logs Per Day and Keep Big Queries Within 1 Second

Log Analysis: How to Digest 15 Billion Logs Per Day and Keep Big Queries Within 1 Second

Comments
6 min read
Deploying ByConity with Kubernetes: A Step-by-Step Guide

Deploying ByConity with Kubernetes: A Step-by-Step Guide

Comments
5 min read
Deep Dive into Citus: Improving Scalability in PostgreSQL

Deep Dive into Citus: Improving Scalability in PostgreSQL

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

Multi-tenant database patterns - through a SaaS lens

1
Comments
7 min read
Introducing pgroll: Zero-downtime, Reversible, Schema Migrations for Postgres

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

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

2
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

3
Comments
4 min read
PostGIS on YugabyteDB Alma8 (workarounds)

PostGIS on YugabyteDB Alma8 (workarounds)

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

How to use PostgreSQL with Haskell: squeal

1
Comments
7 min read
How to use PostgreSQL with Haskell: persistent + esqueleto

How to use PostgreSQL with Haskell: persistent + esqueleto

2
Comments 1
6 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: hasql

How to use PostgreSQL with Haskell: hasql

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

How to use PostgreSQL with Haskell: postgresql-simple

Comments
7 min read
Okay, so which PostgreSQL library should I use with Haskell?

Okay, so which PostgreSQL library should I use with Haskell?

Comments
1 min read
Designing Your Database Schema

Designing Your Database Schema

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

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

9
Comments 8
2 min read
Understanding the MD5 Function

Understanding the MD5 Function

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

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

15
Comments 3
6 min read
Optimizing PostgreSQL Configuration with PgTune

Optimizing PostgreSQL Configuration with PgTune

15
Comments 1
2 min read
AgensSQL vs. Other Relational DBMS

AgensSQL vs. Other Relational DBMS

3
Comments
3 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
Understanding and Comparing Relational and NoSQL Database Management Systems

Understanding and Comparing Relational and NoSQL Database Management Systems

Comments
5 min read
A Guide to PostgreSQL Extensions: Unlocking the Power of pgcrypto, pg_partman, and pg_stat_statements

A Guide to PostgreSQL Extensions: Unlocking the Power of pgcrypto, pg_partman, and pg_stat_statements

Comments
2 min read
Data Science for Beginners: 2023 - 2024 Complete Roadmap

Data Science for Beginners: 2023 - 2024 Complete Roadmap

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

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

SPL computing performance test series: multi-index aggregating

1
Comments
6 min read
Zero-Cost Database Magic 🪄💾

Zero-Cost Database Magic 🪄💾

15
Comments 2
3 min read
Database Keys

Database Keys

Comments
2 min read
Apache AGE: Unique Use Cases

Apache AGE: Unique Use Cases

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