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.
The Xata Playground Now Runs Python in the Browser

The Xata Playground Now Runs Python in the Browser

3
Comments
4 min read
Exploring the Power of PostgreSQL: Unique Features and Advanced Capabilities

Exploring the Power of PostgreSQL: Unique Features and Advanced Capabilities

Comments
3 min read
🐣 Step-by-Step Guide to Data Masking 🎭

🐣 Step-by-Step Guide to Data Masking 🎭

6
Comments
4 min read
How to Build a Blog API using MongoDB Aggregation Pipeline Framework

How to Build a Blog API using MongoDB Aggregation Pipeline Framework

15
Comments
24 min read
Streaming Queries for Real-Time Analytics in Spring Boot

Streaming Queries for Real-Time Analytics in Spring Boot

1
Comments
3 min read
PostgreSQL and Temporary Tables

PostgreSQL and Temporary Tables

18
Comments
9 min read
ACID and Transactions in SQL

ACID and Transactions in SQL

6
Comments
6 min read
MarkdownDB: A rich SQL API to your markdown files in seconds.

MarkdownDB: A rich SQL API to your markdown files in seconds.

2
Comments
2 min read
Client-side data storage with IndexedDB

Client-side data storage with IndexedDB

1
Comments 1
2 min read
Redefining ETL: Data Flows Powered by C# (Part I)

Redefining ETL: Data Flows Powered by C# (Part I)

14
Comments
11 min read
Building a Robust Backend in Just 30 Minutes with Outerbase

Building a Robust Backend in Just 30 Minutes with Outerbase

Comments
11 min read
PostgreSQL and its ACID features: A Comprehensive Guide

PostgreSQL and its ACID features: A Comprehensive Guide

Comments
3 min read
ReductStore v1.7.0 has been released with provisioning and batch writing

ReductStore v1.7.0 has been released with provisioning and batch writing

10
Comments
2 min read
Data Analysis of the Titanic with Python!

Data Analysis of the Titanic with Python!

56
Comments 1
6 min read
SQLite Create Table If Not Exists: Conditional Table Creation

SQLite Create Table If Not Exists: Conditional Table Creation

Comments
2 min read
Should you use an enum column or a table to store allowed values in SQL?

Should you use an enum column or a table to store allowed values in SQL?

14
Comments 1
5 min read
CRUD Operations in SQL

CRUD Operations in SQL

2
Comments 1
14 min read
SQLite with Python

SQLite with Python

18
Comments 7
7 min read
Storing Salesforce embeddings with pgvector and OpenAI

Storing Salesforce embeddings with pgvector and OpenAI

1
Comments
10 min read
Using the LangChain Integration with a Serverless Database

Using the LangChain Integration with a Serverless Database

1
Comments
4 min read
Top Firebase Alternatives

Top Firebase Alternatives

4
Comments 3
10 min read
Discover the Xata SDK for Python

Discover the Xata SDK for Python

3
Comments
3 min read
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
Exploring the Power of pgvector as an Open Source Vector Database

Exploring the Power of pgvector as an Open Source Vector Database

1
Comments
12 min read
Best practices for HarperDB projects using TypeScript

Best practices for HarperDB projects using TypeScript

12
Comments
18 min read
Rust SQLx CLI: database migration with MySQL and PostgreSQL.

Rust SQLx CLI: database migration with MySQL and PostgreSQL.

13
Comments
11 min read
6 Cache Strategies to Save Your Database's Performance

6 Cache Strategies to Save Your Database's Performance

5
Comments
9 min read
MongoDB Quick Start Guide 🍃⚡️

MongoDB Quick Start Guide 🍃⚡️

35
Comments 4
9 min read
instant distributed database- gun.js

instant distributed database- gun.js

17
Comments
2 min read
Replicating Data from Oracle to PostgreSQL - A Comprehensive Guide

Replicating Data from Oracle to PostgreSQL - A Comprehensive Guide

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

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

4
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

7
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

96
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

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