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.
Managing Data with SQL: CRUD Operations Made Simple

Managing Data with SQL: CRUD Operations Made Simple

Comments
4 min read
Database indexing and selectivity

Database indexing and selectivity

Comments
1 min read
How to Choose the Right MQTT Database

How to Choose the Right MQTT Database

1
Comments
12 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
Understanding KeyConditionExpression and FilterExpression in DynamoDB

Understanding KeyConditionExpression and FilterExpression in DynamoDB

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

Unlock your career in data analytics 2024

Comments 1
1 min read
Optimizing MySQL Database Performance: Identifying and Managing Long Queries

Optimizing MySQL Database Performance: Identifying and Managing Long Queries

Comments
4 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 main methods of joining tables in PostgreSQL.

The main methods of joining tables in PostgreSQL.

Comments
3 min read
The ARRAY_TO_STRING() function in PostgreSQL

The ARRAY_TO_STRING() function in PostgreSQL

Comments
2 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
Como criar uma conta gratuita no Microsoft Azure

Como criar uma conta gratuita no Microsoft Azure

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
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
PostgreSQL Cheat Sheet

PostgreSQL Cheat Sheet

4
Comments
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
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
GIS software development dive-in, the essentials

GIS software development dive-in, the essentials

10
Comments
4 min read
Cloud Computing: Some benefits of Cloud Technology

Cloud Computing: Some benefits of Cloud Technology

Comments
2 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
"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
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
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
Reliably syncing database and frontend state: A realtime competitor analysis

Reliably syncing database and frontend state: A realtime competitor analysis

5
Comments 1
12 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
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
Difference between Data Analysts, Data Scientists, and Data Engineers

Difference between Data Analysts, Data Scientists, and Data Engineers

Comments 1
1 min read
Inside SQL Joins

Inside SQL Joins

2
Comments
4 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
loading...