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.
Supabase: The Open-Source Superhero That Saves You From Firebase

Supabase: The Open-Source Superhero That Saves You From Firebase

2
Comments
5 min read
Percona XtraDB Multi-Master Replication cluster setup between 3 nodes

Percona XtraDB Multi-Master Replication cluster setup between 3 nodes

Comments
1 min read
A Comprehensive Guide to Multiple Database Configuration for Microservices in Spring Boot

A Comprehensive Guide to Multiple Database Configuration for Microservices in Spring Boot

Comments
4 min read
How to Use the 'LIKE' Operator in SQL

How to Use the 'LIKE' Operator in SQL

Comments
4 min read
Comprehensive Guide to SQL Operators

Comprehensive Guide to SQL Operators

Comments
4 min read
Difference Between Factories and Seeders in Laravel: Purpose and Usage

Difference Between Factories and Seeders in Laravel: Purpose and Usage

Comments
2 min read
Professional Java Developer Ready to Elevate Your Projects

Professional Java Developer Ready to Elevate Your Projects

Comments
1 min read
Advanced Use Cases and Complex Queries with the SQL LIKE Operator

Advanced Use Cases and Complex Queries with the SQL LIKE Operator

1
Comments
3 min read
introducing op (pouchlite) pure js json storage engine

introducing op (pouchlite) pure js json storage engine

2
Comments
1 min read
Database design

Database design

1
Comments
1 min read
Advanced MongoDB: Mastering Query Optimization and Complex Aggregations

Advanced MongoDB: Mastering Query Optimization and Complex Aggregations

6
Comments
5 min read
Como añadir una columna a varias tablas de golpe con Laravel

Como añadir una columna a varias tablas de golpe con Laravel

1
Comments
1 min read
Revolutionize Your Unit Testing with Testcontainers and Docker

Revolutionize Your Unit Testing with Testcontainers and Docker

3
Comments
2 min read
The No PLAN-B Mindset & How Champions Win

The No PLAN-B Mindset & How Champions Win

Comments
13 min read
YB-Master, the YugabyteDB Universe control plane

YB-Master, the YugabyteDB Universe control plane

Comments
5 min read
Constraints in SQL: Enforcing Data Integrity

Constraints in SQL: Enforcing Data Integrity

Comments
3 min read
I got the need for speed...

I got the need for speed...

Comments
3 min read
Mind Your Tasks: A React Native To-Do App with Firebase

Mind Your Tasks: A React Native To-Do App with Firebase

Comments
2 min read
Meet Three New Python Connectors: Microsoft Access, Snowflake, and MongoDB

Meet Three New Python Connectors: Microsoft Access, Snowflake, and MongoDB

Comments
2 min read
How to build a fully-fledged telegram bot in Python

How to build a fully-fledged telegram bot in Python

3
Comments
25 min read
Advanced SQL: Mastering Query Optimization and Complex Joins

Advanced SQL: Mastering Query Optimization and Complex Joins

182
Comments 13
7 min read
Get Rid of Migration Files

Get Rid of Migration Files

5
Comments
6 min read
Database indexing and selectivity

Database indexing and selectivity

Comments
1 min read
Why You Should Use AWS DynamoDB For Your Applications At Scale

Why You Should Use AWS DynamoDB For Your Applications At Scale

2
Comments
5 min read
Using Indexing To Optimize MongoDB Performance

Using Indexing To Optimize MongoDB Performance

3
Comments
5 min read
Unified Stream and Batch Processing of WorldQuant 101 Alphas in DolphinDB

Unified Stream and Batch Processing of WorldQuant 101 Alphas in DolphinDB

Comments
6 min read
Does Centos 6.9 support postgres 14 ?

Does Centos 6.9 support postgres 14 ?

4
Comments
1 min read
How Enabling Slow Query Log Enhances Postgres Observability

How Enabling Slow Query Log Enhances Postgres Observability

6
Comments
5 min read
Simplify RAG application with MongoDB Atlas and Amazon Bedrock

Simplify RAG application with MongoDB Atlas and Amazon Bedrock

7
Comments
4 min read
Apache Iceberg and Data Lakehouse Partitioning

Apache Iceberg and Data Lakehouse Partitioning

2
Comments 1
7 min read
Unlock your career in data analytics 2024

Unlock your career in data analytics 2024

Comments 1
1 min read
How to setup MySql on MacOS using Brew.

How to setup MySql on MacOS using Brew.

Comments
1 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 ARRAY_TO_STRING() function in PostgreSQL

The ARRAY_TO_STRING() function in PostgreSQL

Comments
2 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
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
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
The fastest local database ever!!!!

The fastest local database ever!!!!

Comments
1 min read
How do SQL interprets nulls?

How do SQL interprets nulls?

Comments
2 min read
Simplifying Database Optimization: A Beginner's Guide

Simplifying Database Optimization: A Beginner's Guide

4
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
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
"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
SQL's LIKE, ILIKE, and NOT LIKE: Beginner's Breakdown

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

Comments
2 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
Mastering Data Management: Designing a Database for an FMCG Alcoholic Beverages Company

Mastering Data Management: Designing a Database for an FMCG Alcoholic Beverages Company

3
Comments
4 min read
How to Source Test Data

How to Source Test Data

3
Comments
5 min read
Most popular Postgres ORMs

Most popular Postgres ORMs

3
Comments
5 min read
Understanding database indexes - A simple analogy

Understanding database indexes - A simple analogy

4
Comments
6 min read
loading...