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.
MySQL or Top Alternatives in 2024 and How to Choose One

MySQL or Top Alternatives in 2024 and How to Choose One

Comments
5 min read
Inside SQL Joins

Inside SQL Joins

Comments
4 min read
Choose the right database for your needs: BASE vs ACID model

Choose the right database for your needs: BASE vs ACID model

Comments
3 min read
Building a Retrieval-Augmented Generation Chatbot with SvelteKit and Xata Vector Search

Building a Retrieval-Augmented Generation Chatbot with SvelteKit and Xata Vector Search

Comments
10 min read
The main methods of joining tables in PostgreSQL.

The main methods of joining tables in PostgreSQL.

Comments
3 min read
Populating a table in PostgreSQL with one million records of random data.

Populating a table in PostgreSQL with one million records of random data.

Comments
1 min read
The ARRAY_TO_STRING() function in PostgreSQL

The ARRAY_TO_STRING() function in PostgreSQL

Comments
2 min read
Python code that inserts a large number of records into a MySQL table.

Python code that inserts a large number of records into a MySQL table.

Comments
2 min read
Como criar uma conta gratuita no Microsoft Azure

Como criar uma conta gratuita no Microsoft Azure

Comments
2 min read
Python. Automating creation backups of MySQL database.

Python. Automating creation backups of MySQL database.

Comments
4 min read
How the presence of indexes and the size of tables affect the choice of execution plan when joining tables in PostgreSQL?

How the presence of indexes and the size of tables affect the choice of execution plan when joining tables in PostgreSQL?

1
Comments
7 min read
How do you check a distribution of values that PostgreSQL has collected on some column of a table?

How do you check a distribution of values that PostgreSQL has collected on some column of a table?

1
Comments
2 min read
Oracle SQL vs MySQL: A Comprehensive Comparison

Oracle SQL vs MySQL: A Comprehensive Comparison

Comments
3 min read
Building Dynamic Forms with PHP: A Comprehensive Tutorial

Building Dynamic Forms with PHP: A Comprehensive Tutorial

Comments 1
5 min read
RDS Database Migration Series - Facing The Giant: How we migrated 11 TB database

RDS Database Migration Series - Facing The Giant: How we migrated 11 TB database

1
Comments
10 min read
How do SQL interprets nulls?

How do SQL interprets nulls?

Comments
2 min read
Overcoming Prometheus's Single-Value Data Model Limitations - A New Approach by GreptimeDB

Overcoming Prometheus's Single-Value Data Model Limitations - A New Approach by GreptimeDB

Comments
5 min read
The Intricacies of Null Values in MySQL

The Intricacies of Null Values in MySQL

Comments
5 min read
Crash on clock skew: performance vs availability

Crash on clock skew: performance vs availability

Comments
7 min read
Cloud Computing: Some benefits of Cloud Technology

Cloud Computing: Some benefits of Cloud Technology

Comments
2 min read
GIS software development dive-in, the essentials

GIS software development dive-in, the essentials

10
Comments
4 min read
From ETL to Modern Integration Platforms

From ETL to Modern Integration Platforms

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
Duplicate Detection Rules in Dynamics 365 CRM.

Duplicate Detection Rules in Dynamics 365 CRM.

Comments
1 min read
Top 10 technologies for data engineers.

Top 10 technologies for data engineers.

1
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
"Inside DuckDB" series articles

"Inside DuckDB" series articles

Comments
1 min read
"Inside DuckDB" series articles

"Inside DuckDB" series articles

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

OLAP: CUBE, ROLLUP, AND GROUPING SETS

Comments
4 min read
Create a Product Database In 3 Steps

Create a Product Database In 3 Steps

Comments
10 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
Modern Data Quality at Scale using Digna

Modern Data Quality at Scale using Digna

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

How to Perform Upsert Operations in MongoDB with Java

Comments
2 min read
SAP Basis snippets #4

SAP Basis snippets #4

Comments
1 min read
Say No to SQL 🙅

Say No to SQL 🙅

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

Decoding Fauna: ABAC vs. RBAC Explained

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

How I built and designed MyWishlist - Part One

7
Comments
4 min read
11 API Trends to Watch for in 2024

11 API Trends to Watch for in 2024

Comments
7 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
Using Liquibase with Docker to automate DB changes

Using Liquibase with Docker to automate DB changes

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

Common Table Expressions (CTEs) in SQL

3
Comments
1 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
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
Best Practices for Enterprise Data Migration: A Comprehensive Guide

Best Practices for Enterprise Data Migration: A Comprehensive Guide

Comments
5 min read
Weekly Updates - May 3, 2024

Weekly Updates - May 3, 2024

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

Instant API for databases adds automatic TSID primary keys

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

How No-Code API Tools Automatically Generate APIs

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

Simplified SQL: Harnessing the Power of Aliases

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

🗺️ Neo4J #GraphSummits as data!

Comments 3
1 min read
A glimpse into the future of data processing infrastructure.

A glimpse into the future of data processing infrastructure.

Comments
9 min read
The Essential Guide to Database Backup: Tips & Strategies

The Essential Guide to Database Backup: Tips & Strategies

Comments
11 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
Setup Azure Cosmos DB for Gremlin in Spring Boot Java

Setup Azure Cosmos DB for Gremlin in Spring Boot Java

1
Comments
3 min read
How to ditch Neon

How to ditch Neon

Comments
3 min read
System Design: Databases and DBMS

System Design: Databases and DBMS

Comments
6 min read
Exploring the Landscape of Database Paradigms - A Comprehensive Guide - Key-Value Databases

Exploring the Landscape of Database Paradigms - A Comprehensive Guide - Key-Value Databases

Comments
10 min read
Caching OpenAI Chat API Responses with LangChain and Xata

Caching OpenAI Chat API Responses with LangChain and Xata

Comments
11 min read
Arrow Flight SQL in Apache Doris for 10X faster data transfer

Arrow Flight SQL in Apache Doris for 10X faster data transfer

2
Comments
10 min read
SAP Basis snippets #3

SAP Basis snippets #3

Comments
1 min read
Modern Data Quality (MDQ): Everything You Need to Know

Modern Data Quality (MDQ): Everything You Need to Know

Comments
5 min read
loading...