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.
19 Graph Algorithms You Can Use Right Now

19 Graph Algorithms You Can Use Right Now

6
Comments 1
18 min read
Top 10 Streaming Analytics Tools

Top 10 Streaming Analytics Tools

1
Comments
7 min read
Friendly data modeling & auto-generated, editable migrations for Platformatic with Prisma

Friendly data modeling & auto-generated, editable migrations for Platformatic with Prisma

11
Comments 2
10 min read
Fauna Deep Dive: Architecting a Distributed Serverless Database

Fauna Deep Dive: Architecting a Distributed Serverless Database

4
Comments
10 min read
Why Are SQL Databases Outdated for the Real-Time Recommendation Engines

Why Are SQL Databases Outdated for the Real-Time Recommendation Engines

1
Comments
9 min read
Use AWS CloudFormation to create ShardingSphere HA clusters

Use AWS CloudFormation to create ShardingSphere HA clusters

Comments
6 min read
DynamoDB Go SDK: How to use the Scan and Batch operations efficiently

DynamoDB Go SDK: How to use the Scan and Batch operations efficiently

Comments
8 min read
Introducing the mirror command in ReductStore CLI version 0.3.0

Introducing the mirror command in ReductStore CLI version 0.3.0

2
Comments
1 min read
Create and Seed Your Postgres Database in Minutes with Docker

Create and Seed Your Postgres Database in Minutes with Docker

18
Comments
8 min read
Types of SQL Joins

Types of SQL Joins

1
Comments
4 min read
Why Prisma and Platformatic are a great match

Why Prisma and Platformatic are a great match

19
Comments
4 min read
Core Banking: Complete Guide

Core Banking: Complete Guide

5
Comments
8 min read
Blue/Green Deployments for RDS: How Fast is a Switchover? 

Blue/Green Deployments for RDS: How Fast is a Switchover? 

13
Comments 3
3 min read
How to work with JSON data on SQL Server

How to work with JSON data on SQL Server

11
Comments
4 min read
SQL Macros (aka Parameterized Views) in YugabyteDB with PostgreSQL UDF

SQL Macros (aka Parameterized Views) in YugabyteDB with PostgreSQL UDF

4
Comments
4 min read
Happy Seeding with Faker

Happy Seeding with Faker

1
Comments 1
3 min read
How to handle type conversions with the DynamoDB Go SDK

How to handle type conversions with the DynamoDB Go SDK

7
Comments
10 min read
Introducing Instant GraphQL on Amazon Athena

Introducing Instant GraphQL on Amazon Athena

2
Comments
3 min read
Introducing Instant GraphQL for CockroachDB

Introducing Instant GraphQL for CockroachDB

2
Comments
3 min read
EXPLAIN (ANALYZE, DIST) 🚀 YugabyteDB distributed execution plan

EXPLAIN (ANALYZE, DIST) 🚀 YugabyteDB distributed execution plan

3
Comments
3 min read
Neo4j - From Zero to Newbie

Neo4j - From Zero to Newbie

6
Comments
5 min read
How to improve your Database performance

How to improve your Database performance

5
Comments
7 min read
SQL extensions for time series data in QuestDB part II

SQL extensions for time series data in QuestDB part II

8
Comments
8 min read
How to install MSSQL Server on Ubuntu?

How to install MSSQL Server on Ubuntu?

3
Comments
2 min read
How to add Prisma to a Next.js project

How to add Prisma to a Next.js project

6
Comments
6 min read
How to check if the PostgreSQL tables of the same structure have the identical data using aggregated hash and md5?

How to check if the PostgreSQL tables of the same structure have the identical data using aggregated hash and md5?

4
Comments
2 min read
Graph database plugin for RDBMS

Graph database plugin for RDBMS

4
Comments
1 min read
How sql engine handle join internally - part 2

How sql engine handle join internally - part 2

15
Comments 4
3 min read
InfluxDB - What, When, Why

InfluxDB - What, When, Why

6
Comments
3 min read
FHIR (Fast Healthcare Interoperability Resources)

FHIR (Fast Healthcare Interoperability Resources)

3
Comments
2 min read
Why DynamoDB Streams is Very Useful

Why DynamoDB Streams is Very Useful

5
Comments
4 min read
The Complete Cypher Cheat Sheet

The Complete Cypher Cheat Sheet

4
Comments
6 min read
How to install MongoDB on Ubuntu 22.0 LTS

How to install MongoDB on Ubuntu 22.0 LTS

3
Comments
3 min read
Database Normalisation

Database Normalisation

27
Comments
4 min read
Neo4j vs Memgraph - How to choose a graph database?

Neo4j vs Memgraph - How to choose a graph database?

3
Comments
6 min read
Announcing native database integrations for CockroachDB and Amazon Athena

Announcing native database integrations for CockroachDB and Amazon Athena

2
Comments
3 min read
How to deploy Apache Druid on AWS EC2 Instance

How to deploy Apache Druid on AWS EC2 Instance

6
Comments
3 min read
Partial Index as an approximate Count(*) Materialized View

Partial Index as an approximate Count(*) Materialized View

2
Comments
3 min read
Match Nodes with One or More Labels

Match Nodes with One or More Labels

3
Comments
2 min read
Arrays in SQL? Yay or Nay?

Arrays in SQL? Yay or Nay?

4
Comments 1
2 min read
Revisiting Postgres

Revisiting Postgres

7
Comments
8 min read
The Easiest Way to Clone a PostgreSQL Database

The Easiest Way to Clone a PostgreSQL Database

2
Comments
1 min read
Checking AWS RDS databases details

Checking AWS RDS databases details

8
Comments
3 min read
My 7 Favorite Announcements from AWS re:Invent 2022

My 7 Favorite Announcements from AWS re:Invent 2022

12
Comments 1
3 min read
How sql engine handle join internally-part 1

How sql engine handle join internally-part 1

38
Comments 5
3 min read
Enum Types in Postgres

Enum Types in Postgres

3
Comments
5 min read
Connecting to remote PostgreSQL DB (database) from a Docker container

Connecting to remote PostgreSQL DB (database) from a Docker container

21
Comments
3 min read
MongoDB sequences (auto-increment) - The Java Way

MongoDB sequences (auto-increment) - The Java Way

3
Comments
2 min read
Exploring Geospatial Data with NebulaGraph Database

Exploring Geospatial Data with NebulaGraph Database

4
Comments
5 min read
Memgraph vs. Neo4j: A Performance Comparison

Memgraph vs. Neo4j: A Performance Comparison

6
Comments
10 min read
SQL Join explained!

SQL Join explained!

7
Comments 1
2 min read
Troubleshooting High CPU Utilization in PostgreSQL Databases: A How-To Guide

Troubleshooting High CPU Utilization in PostgreSQL Databases: A How-To Guide

10
Comments
11 min read
What is Data Management?

What is Data Management?

5
Comments 1
5 min read
What is SQL Injection and How to prevent it?

What is SQL Injection and How to prevent it?

11
Comments 1
10 min read
5 ways to store market data: CSV, SQLite, Postgres, Mongo, Arctic

5 ways to store market data: CSV, SQLite, Postgres, Mongo, Arctic

3
Comments
5 min read
The best indexes for an execution plan that never gets (too) wrong

The best indexes for an execution plan that never gets (too) wrong

2
Comments
15 min read
SolomonDB Weekly Update (#2): Palmon

SolomonDB Weekly Update (#2): Palmon

4
Comments 2
7 min read
React Refactoring - Composition: When don't use it!

React Refactoring - Composition: When don't use it!

4
Comments 4
2 min read
Apps i used daily for my web development work

Apps i used daily for my web development work

2
Comments
5 min read
Save 1.2 million queries per day with Laravel Eager Loading

Save 1.2 million queries per day with Laravel Eager Loading

3
Comments
5 min read
loading...