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.
How to Connect Your Nest.js App to AWS DocumentDB: A Step-by-Step Guide

How to Connect Your Nest.js App to AWS DocumentDB: A Step-by-Step Guide

3
Comments
4 min read
Help! I Think I Broke DynamoDB – A Tale of Three Wishes 🧞‍♂️

Help! I Think I Broke DynamoDB – A Tale of Three Wishes 🧞‍♂️

Comments
12 min read
Graphs as methods of implication

Graphs as methods of implication

Comments
1 min read
How Pipe Syntax Fix SQL Design Problems

How Pipe Syntax Fix SQL Design Problems

Comments
5 min read
The Power of OUTER APPLY: A SQL Weapon to Expand Legacy Database

The Power of OUTER APPLY: A SQL Weapon to Expand Legacy Database

7
Comments 1
6 min read
Fixing Turso Read-After-Write Consistency in Serverless

Fixing Turso Read-After-Write Consistency in Serverless

1
Comments
3 min read
Improve Your MySQL Database Design and Management with DbSchema

Improve Your MySQL Database Design and Management with DbSchema

8
Comments 1
6 min read
How to Choose the Right Database for Your Full Stack Project

How to Choose the Right Database for Your Full Stack Project

17
Comments 2
5 min read
Why should you use Docker

Why should you use Docker

2
Comments
3 min read
Aurora Limitless - Reference Tables

Aurora Limitless - Reference Tables

1
Comments
6 min read
ACID Properties in Databases: What Happens Without Them?

ACID Properties in Databases: What Happens Without Them?

5
Comments
6 min read
DynamoDB Architecture: A Comprehensive Guide to Building Scalable Applications in 2025

DynamoDB Architecture: A Comprehensive Guide to Building Scalable Applications in 2025

Comments
3 min read
🕵️ OSINT: link company acronyms to Standard Occupation Classification w. Open Source LLMs

🕵️ OSINT: link company acronyms to Standard Occupation Classification w. Open Source LLMs

1
Comments 8
6 min read
Data Cleaning

Data Cleaning

66
Comments 4
2 min read
Working with PostgreSQL Date and Time Functions

Working with PostgreSQL Date and Time Functions

Comments
3 min read
đź“›Stop Hardcoding Database Calls: Simplify with a Config Manager

đź“›Stop Hardcoding Database Calls: Simplify with a Config Manager

1
Comments
4 min read
PyQt5 isn't only for frontend

PyQt5 isn't only for frontend

Comments
1 min read
DBMS_SQL package | Dynamic SQL

DBMS_SQL package | Dynamic SQL

1
Comments 1
3 min read
Aurora Limitless - SQL Limitations

Aurora Limitless - SQL Limitations

9
Comments
6 min read
🗂️ Master SQL Review with GUI 🎛️, GitOps 🖇️ and API 🔌

🗂️ Master SQL Review with GUI 🎛️, GitOps 🖇️ and API 🔌

10
Comments
6 min read
Why Doesn't Postgres Use My Index

Why Doesn't Postgres Use My Index

Comments
16 min read
Connecting to a MySQL Database in PHP

Connecting to a MySQL Database in PHP

Comments
4 min read
Laravel Custom Query Builders Over Scopes

Laravel Custom Query Builders Over Scopes

8
Comments 2
3 min read
No Gap Ordered Numbering in SQL: A Unique Index to Serialize In Read Committed

No Gap Ordered Numbering in SQL: A Unique Index to Serialize In Read Committed

Comments
5 min read
Aurora Limitless - Single and Multi-Shard Scan

Aurora Limitless - Single and Multi-Shard Scan

2
Comments
5 min read
How to Query CSV Files with SQLite

How to Query CSV Files with SQLite

Comments
8 min read
Statement Level Trigger vs Row Level Trigger

Statement Level Trigger vs Row Level Trigger

9
Comments
2 min read
What Are Stored Procedures?

What Are Stored Procedures?

Comments
8 min read
What is Real-Time Data Processing?

What is Real-Time Data Processing?

Comments
7 min read
Aurora Limitless - Sharded Table

Aurora Limitless - Sharded Table

2
Comments
9 min read
Congrats to the Winners of the Open Source AI Challenge with pgai and Ollama!

Congrats to the Winners of the Open Source AI Challenge with pgai and Ollama!

68
Comments 9
2 min read
System Design 01 - Data Storage: Pick Your Poison Wisely

System Design 01 - Data Storage: Pick Your Poison Wisely

1
Comments
2 min read
Graph Databases Are So Cool, Use neo4j

Graph Databases Are So Cool, Use neo4j

Comments
3 min read
Aurora Limitless - Connection

Aurora Limitless - Connection

2
Comments
4 min read
Simple Ways to Identify the MySQL Port

Simple Ways to Identify the MySQL Port

1
Comments
2 min read
A Playground for SQL RDBMS, custom Ollama API Interaction with RAG on Timescale DB and download of query plus result

A Playground for SQL RDBMS, custom Ollama API Interaction with RAG on Timescale DB and download of query plus result

9
Comments
5 min read
Why is Hamiltonian graph?

Why is Hamiltonian graph?

Comments
2 min read
Cloning PostgreSQL Databases: A Developer's Guide to Local Replication

Cloning PostgreSQL Databases: A Developer's Guide to Local Replication

1
Comments
4 min read
The Last Saree: Connoisseurship in the Age of AI

The Last Saree: Connoisseurship in the Age of AI

10
Comments 2
9 min read
DynamoDB and the Art of Knowing Your Limits 💥When Database Bites Back 🧛‍♂️

DynamoDB and the Art of Knowing Your Limits 💥When Database Bites Back 🧛‍♂️

2
Comments 4
13 min read
The Strength of Vertica DB: A Case Study in Sales Analytics

The Strength of Vertica DB: A Case Study in Sales Analytics

Comments
3 min read
Populating a Vertica Database with Random Data

Populating a Vertica Database with Random Data

Comments
4 min read
How to Install Vertica DB Client (vsql) on Ubuntu 24.04

How to Install Vertica DB Client (vsql) on Ubuntu 24.04

Comments
2 min read
CTE | Common Table Expression | Real world scenarios examples

CTE | Common Table Expression | Real world scenarios examples

8
Comments 2
2 min read
Git. Universary DB

Git. Universary DB

1
Comments
1 min read
Using DuckDB for Ad-Hoc Analysis: A SQL-Lover's Alternative to Pandas

Using DuckDB for Ad-Hoc Analysis: A SQL-Lover's Alternative to Pandas

1
Comments
3 min read
Built with Timescale: Cook This App

Built with Timescale: Cook This App

6
Comments 1
3 min read
GBase数据库 | GBase 8c Distributed Scenario Typical Fault Management

GBase数据库 | GBase 8c Distributed Scenario Typical Fault Management

5
Comments
2 min read
AI Writing Assistant for Sci-fi Authors

AI Writing Assistant for Sci-fi Authors

8
Comments
2 min read
RAG Web Scraping

RAG Web Scraping

1
Comments
2 min read
lowCalAlt_update1

lowCalAlt_update1

Comments
1 min read
Day 1 SQL Series || Introduction to SQL

Day 1 SQL Series || Introduction to SQL

16
Comments 1
3 min read
Smart Bookmark Manager

Smart Bookmark Manager

15
Comments
2 min read
GBASE数据库 | GBase 8c Compatibility Analysis with Distributed Databases

GBASE数据库 | GBase 8c Compatibility Analysis with Distributed Databases

6
Comments
3 min read
Resolving MongoDB Error When Starting with Homebrew on macOS

Resolving MongoDB Error When Starting with Homebrew on macOS

Comments
2 min read
How to connect and query multiple databases with a single REST API

How to connect and query multiple databases with a single REST API

Comments
3 min read
Docker configurations for relational and non-relational databases

Docker configurations for relational and non-relational databases

Comments
1 min read
The Medallion Architecture: Refining Data from Bronze to Gold 🏅

The Medallion Architecture: Refining Data from Bronze to Gold 🏅

10
Comments 1
4 min read
Designing robust and scalable relational databases: A series of best practices.

Designing robust and scalable relational databases: A series of best practices.

10
Comments 5
17 min read
Database Replication NLogN🔄

Database Replication NLogN🔄

Comments
2 min read
loading...