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.
UPSERT some columns in YugabyteDB (ON CONFLICT DO UPDATE)

UPSERT some columns in YugabyteDB (ON CONFLICT DO UPDATE)

6
Comments
6 min read
MLOps is 98% Data Engineering

MLOps is 98% Data Engineering

1
Comments
10 min read
Distributed Managed PostgreSQL Database Alternatives in the Cloud

Distributed Managed PostgreSQL Database Alternatives in the Cloud

2
Comments
3 min read
Synchronize Data Between Memgraph Graph Database and Elasticsearch

Synchronize Data Between Memgraph Graph Database and Elasticsearch

Comments
6 min read
Programming is the art of trade-off

Programming is the art of trade-off

25
Comments 4
5 min read
MongoDB vs DynamoDB: Differences between them

MongoDB vs DynamoDB: Differences between them

1
Comments
3 min read
🏺Database Architecture - History Over State

🏺Database Architecture - History Over State

8
Comments 1
8 min read
Understanding SurrealQL and how it is different from PostgreSQL

Understanding SurrealQL and how it is different from PostgreSQL

36
Comments 6
9 min read
Mongoose Cheat Sheet

Mongoose Cheat Sheet

2
Comments
2 min read
Deadlock Handling in Distributed Database

Deadlock Handling in Distributed Database

1
Comments 1
6 min read
Usage of pgpool-II and AGE at PostgeSQL

Usage of pgpool-II and AGE at PostgeSQL

1
Comments
3 min read
Boosting Greenplum security

Boosting Greenplum security

7
Comments
2 min read
How to compose SQL queries based on values from CSV file?

How to compose SQL queries based on values from CSV file?

Comments
2 min read
How to check tables fragmentation in Oracle DB?

How to check tables fragmentation in Oracle DB?

8
Comments
1 min read
IN Subquery Optimization

IN Subquery Optimization

Comments
5 min read
Problem solving with SQL: Case Study #1 — Danny’s Diner

Problem solving with SQL: Case Study #1 — Danny’s Diner

10
Comments 2
10 min read
Insight Findings from A Case Study of Customers Leaving Credit Card Services

Insight Findings from A Case Study of Customers Leaving Credit Card Services

Comments
10 min read
Postgres: The Graph Database You Didn't Know You Had

Postgres: The Graph Database You Didn't Know You Had

7
Comments
6 min read
Database Cluster Layout

Database Cluster Layout

3
Comments
2 min read
Getting Started With Sentiment Analysis

Getting Started With Sentiment Analysis

1
Comments
3 min read
Developer Q&A with JR the Builder, co-creator of Beam Analytics

Developer Q&A with JR the Builder, co-creator of Beam Analytics

Comments
5 min read
MongoDB Sharding Digest

MongoDB Sharding Digest

1
Comments
3 min read
Creating a RESTful API with JSON Server in Node.js: A Comprehensive Guide.

Creating a RESTful API with JSON Server in Node.js: A Comprehensive Guide.

9
Comments
8 min read
Yet another journey to the cloud: User Management

Yet another journey to the cloud: User Management

3
Comments
5 min read
Architecture on a Post-it note: Optimizing AWS Aurora Databases

Architecture on a Post-it note: Optimizing AWS Aurora Databases

2
Comments
7 min read
EF Core 7: Json columns

EF Core 7: Json columns

24
Comments 3
9 min read
Why consistency and availability cannot coexist in distributed systems?

Why consistency and availability cannot coexist in distributed systems?

2
Comments
3 min read
Event-Driven Serverless Data Architecture

Event-Driven Serverless Data Architecture

4
Comments 2
10 min read
Decentralized Databases: ComposeDB

Decentralized Databases: ComposeDB

41
Comments 8
10 min read
SPL: The Open-source Java Library to Process Structured Data

SPL: The Open-source Java Library to Process Structured Data

Comments
12 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

1
Comments
8 min read
Data Warehousing: The Key to Unlocking Insights from Your Data

Data Warehousing: The Key to Unlocking Insights from Your Data

2
Comments
2 min read
DynamoDB Basic - Part 1: Introduction DynamoDB

DynamoDB Basic - Part 1: Introduction DynamoDB

4
Comments
5 min read
An ETL Job using AWS Glue Studio to inner join DynamoDB tables, Apply Queries and Store the result in S3

An ETL Job using AWS Glue Studio to inner join DynamoDB tables, Apply Queries and Store the result in S3

28
Comments 1
11 min read
Query Real Time Data in Kafka Using SQL

Query Real Time Data in Kafka Using SQL

7
Comments
9 min read
Making sure our database queries are fast

Making sure our database queries are fast

18
Comments
3 min read
2 Ways to Build & Deploy Apps on a MySQL Database

2 Ways to Build & Deploy Apps on a MySQL Database

1
Comments
13 min read
Building real-time analytics into your next project

Building real-time analytics into your next project

7
Comments
9 min read
Create a Word Guessing Game With Apache AGE

Create a Word Guessing Game With Apache AGE

5
Comments 1
3 min read
Challenges when building real-time analytics

Challenges when building real-time analytics

Comments 2
5 min read
How to effectively store and ANALYSE logs in AWS CLOUD

How to effectively store and ANALYSE logs in AWS CLOUD

7
Comments
8 min read
The Power of Graph Databases: Unlocking the Potential of Connected Data

The Power of Graph Databases: Unlocking the Potential of Connected Data

3
Comments
2 min read
What is real-time analytics?

What is real-time analytics?

1
Comments
5 min read
The essential components of real-time analytics

The essential components of real-time analytics

2
Comments
3 min read
The leading real-time analytics platform in 2023

The leading real-time analytics platform in 2023

Comments
4 min read
SQL JOIN explained

SQL JOIN explained

74
Comments 4
13 min read
Uncovering Hidden Gems: PostgreSQL Window Functions You May Not Know About

Uncovering Hidden Gems: PostgreSQL Window Functions You May Not Know About

3
Comments
2 min read
Understanding The Process and Memory Architecture of PostgreSQL

Understanding The Process and Memory Architecture of PostgreSQL

6
Comments
2 min read
Create An EVM Compatible Blockchain Bridge——DB3 Network build in public weekly update (20230213-20230218)

Create An EVM Compatible Blockchain Bridge——DB3 Network build in public weekly update (20230213-20230218)

2
Comments
2 min read
TiDB hackathon 2023 idea

TiDB hackathon 2023 idea

2
Comments
1 min read
Tigris MongoDB compatibility now in beta

Tigris MongoDB compatibility now in beta

Comments
5 min read
Understanding the Basics of ACID Principles in Database Management

Understanding the Basics of ACID Principles in Database Management

8
Comments
3 min read
CONNECTING TO A POSTGRESQL DATABASE WITH NODE.JS: A STEP-BY-STEP GUIDE

CONNECTING TO A POSTGRESQL DATABASE WITH NODE.JS: A STEP-BY-STEP GUIDE

18
Comments 1
5 min read
Como adicionar banco de dados em uma aplicação .NET 7 [PT-BR]

Como adicionar banco de dados em uma aplicação .NET 7 [PT-BR]

9
Comments 4
2 min read
Building a Secure Database-Centric OpenAPI in 15 Minutes

Building a Secure Database-Centric OpenAPI in 15 Minutes

16
Comments
13 min read
Multi-tenant implementation approaches with Prisma and ZenStack

Multi-tenant implementation approaches with Prisma and ZenStack

21
Comments 2
8 min read
How to install postgresql-server-dev-11 on ubuntu

How to install postgresql-server-dev-11 on ubuntu

2
Comments
1 min read
A Tutorial on SQL Window Functions.

A Tutorial on SQL Window Functions.

1
Comments
15 min read
Analyzing Wikipedia's Articles Classification Chain With Apache AGE

Analyzing Wikipedia's Articles Classification Chain With Apache AGE

8
Comments
3 min read
Is Redis merely caching system?

Is Redis merely caching system?

1
Comments
5 min read
loading...