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.
Mastering Relational Database Design: A Comprehensive Guide

Mastering Relational Database Design: A Comprehensive Guide

350
Comments 29
20 min read
Mastering SQL: Comprehensive Guide To Structured Query Language

Mastering SQL: Comprehensive Guide To Structured Query Language

64
Comments 6
5 min read
Get SQL-Server Stored Procedures with C#

Get SQL-Server Stored Procedures with C#

32
Comments
9 min read
Vector Databases for generative AI applications

Vector Databases for generative AI applications

24
Comments 2
6 min read
MongoDB vs RabbitMQ: Choosing the Right Data Solution for your project

MongoDB vs RabbitMQ: Choosing the Right Data Solution for your project

12
Comments
5 min read
Why SurrealDB is the Future of Database Technology - An In-Depth Look

Why SurrealDB is the Future of Database Technology - An In-Depth Look

10
Comments
16 min read
I Build libSQL Client for PHP

I Build libSQL Client for PHP

9
Comments 2
3 min read
What to use parquet or CSV?

What to use parquet or CSV?

8
Comments
3 min read
Your Complete Guide to MongoDB: Part One ( Setup and Basics)

Your Complete Guide to MongoDB: Part One ( Setup and Basics)

6
Comments 2
5 min read
Fastest way to become a Software Developer

Fastest way to become a Software Developer

5
Comments
26 min read
Optimizing Relational Databases for Best Performance in MySQL

Optimizing Relational Databases for Best Performance in MySQL

5
Comments 2
8 min read
DynamoDB Query Evaluation Order Differs from SQL

DynamoDB Query Evaluation Order Differs from SQL

4
Comments
2 min read
Handling key-value storage efficiently with Unstorage

Handling key-value storage efficiently with Unstorage

4
Comments
3 min read
Securely connect to an Amazon RDS

Securely connect to an Amazon RDS

3
Comments
3 min read
Common Table Expressions (CTEs) in SQL

Common Table Expressions (CTEs) in SQL

3
Comments
1 min read
Data API for Amazon Aurora Serverless v2 with AWS SDK for Java - Part 6 Comparing cold and warm starts between Data API and JDBC

Data API for Amazon Aurora Serverless v2 with AWS SDK for Java - Part 6 Comparing cold and warm starts between Data API and JDBC

3
Comments
5 min read
How to Process Events Exactly-Once with Kafka and DBOS

How to Process Events Exactly-Once with Kafka and DBOS

3
Comments
4 min read
Say No to SQL 🙅

Say No to SQL 🙅

2
Comments
3 min read
Mantendo seus dados segregados por Padrão

Mantendo seus dados segregados por Padrão

2
Comments 3
6 min read
Top 10 technologies for data engineers.

Top 10 technologies for data engineers.

1
Comments
2 min read
Best Practices for Naming REST API Endpoints

Best Practices for Naming REST API Endpoints

1
Comments
9 min read
Top 10 most asked SQL interview questions along with their answers

Top 10 most asked SQL interview questions along with their answers

1
Comments 2
3 min read
How No-Code API Tools Automatically Generate APIs

How No-Code API Tools Automatically Generate APIs

Comments
7 min read
Best Practices for Enterprise Data Migration: A Comprehensive Guide

Best Practices for Enterprise Data Migration: A Comprehensive Guide

Comments
5 min read
Virtual Private Cloud vs On Premises | Key Differences & How to Choose

Virtual Private Cloud vs On Premises | Key Differences & How to Choose

Comments
7 min read
database conversion

database conversion

Comments
1 min read
Duplicate Detection Rules in Dynamics 365 CRM.

Duplicate Detection Rules in Dynamics 365 CRM.

Comments
1 min read
Journey to modern databases

Journey to modern databases

Comments
9 min read
Nuxt3 x MySQL (& Drizzle ORM)

Nuxt3 x MySQL (& Drizzle ORM)

Comments
2 min read
Using Liquibase with Docker to automate DB changes

Using Liquibase with Docker to automate DB changes

Comments
2 min read
Advisory/Custom/Application Lock with YugabyteDB

Advisory/Custom/Application Lock with YugabyteDB

Comments
5 min read
From ETL to Modern Integration Platforms

From ETL to Modern Integration Platforms

Comments
4 min read
OLAP: CUBE, ROLLUP, AND GROUPING SETS

OLAP: CUBE, ROLLUP, AND GROUPING SETS

Comments
4 min read
Building a Dynamic Contact Form with Firebase Realtime Database

Building a Dynamic Contact Form with Firebase Realtime Database

Comments
4 min read
How I built and designed MyWishlist - Part One

How I built and designed MyWishlist - Part One

Comments
4 min read
Everyone knows that you can have relations in MongoDB, right?

Everyone knows that you can have relations in MongoDB, right?

Comments
1 min read
11 API Trends to Watch for in 2024

11 API Trends to Watch for in 2024

Comments
7 min read
Simplified SQL: Harnessing the Power of Aliases

Simplified SQL: Harnessing the Power of Aliases

Comments
2 min read
Decoding Fauna: ABAC vs. RBAC Explained

Decoding Fauna: ABAC vs. RBAC Explained

Comments
3 min read
Weekly Updates - May 3, 2024

Weekly Updates - May 3, 2024

Comments
1 min read
Exploring SQL Functions: Harnessing the Power of Built-in Functions

Exploring SQL Functions: Harnessing the Power of Built-in Functions

Comments
3 min read
Why Choose ULIDs Over Traditional UUIDs or IDs for Database Identification?

Why Choose ULIDs Over Traditional UUIDs or IDs for Database Identification?

Comments
3 min read
Instant API for databases adds automatic TSID primary keys

Instant API for databases adds automatic TSID primary keys

Comments
3 min read
Your Complete Guide to MongoDB: Part Two (Advanced Query Filtering)

Your Complete Guide to MongoDB: Part Two (Advanced Query Filtering)

Comments 2
5 min read
single API multiple databases

single API multiple databases

Comments
1 min read
Complete Guide To Transaction Isolation Levels in SQL

Complete Guide To Transaction Isolation Levels in SQL

Comments
7 min read
Difference between Data Analysts, Data Scientists, and Data Engineers

Difference between Data Analysts, Data Scientists, and Data Engineers

Comments 1
1 min read
SAP Basis snippets #4

SAP Basis snippets #4

Comments
1 min read
🗺️ Neo4J #GraphSummits as data!

🗺️ Neo4J #GraphSummits as data!

Comments 3
1 min read
How to Perform Upsert Operations in MongoDB with Java

How to Perform Upsert Operations in MongoDB with Java

Comments
2 min read
Flexibility Meets Excellence: Online Data Science Course

Flexibility Meets Excellence: Online Data Science Course

Comments
3 min read
Modern Data Quality at Scale using Digna

Modern Data Quality at Scale using Digna

Comments
6 min read
SQL's LIKE, ILIKE, and NOT LIKE: Beginner's Breakdown

SQL's LIKE, ILIKE, and NOT LIKE: Beginner's Breakdown

Comments
2 min read
Create a Product Database In 3 Steps

Create a Product Database In 3 Steps

Comments
10 min read
Auto-increment columns in Apache Doris

Auto-increment columns in Apache Doris

Comments
11 min read
"Inside DuckDB" series articles

"Inside DuckDB" series articles

Comments
1 min read
"Inside DuckDB" series articles

"Inside DuckDB" series articles

Comments
1 min read
Optimistic lock & Pessimistic lock

Optimistic lock & Pessimistic lock

Comments
1 min read
SQL Join Types Explained: Inner, Outer, and More in 2024

SQL Join Types Explained: Inner, Outer, and More in 2024

Comments
2 min read
Build authenticated and paywall pages with Stripe and Xata

Build authenticated and paywall pages with Stripe and Xata

Comments
18 min read
loading...