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.
Best Databases for Streaming Analytics

Best Databases for Streaming Analytics

Comments
6 min read
How to Use Every Vector Database in Python with DocArray

How to Use Every Vector Database in Python with DocArray

1
Comments
3 min read
VLOOKUP PostgreSQL Solution

VLOOKUP PostgreSQL Solution

Comments
2 min read
This is what the future looks like - ChatGPT + database 🤯

This is what the future looks like - ChatGPT + database 🤯

3
Comments
1 min read
How to expose PostgreSQL connection in ubuntu

How to expose PostgreSQL connection in ubuntu

5
Comments
2 min read
How Much Money Will You Spend on Hosting a Database

How Much Money Will You Spend on Hosting a Database

Comments
11 min read
Storing currency values: data types, caveats, best practices

Storing currency values: data types, caveats, best practices

3
Comments
9 min read
The Benefits of Using a Graph Database Instead of SQL

The Benefits of Using a Graph Database Instead of SQL

Comments
10 min read
Mongoose ODM Best Practices Part One.

Mongoose ODM Best Practices Part One.

8
Comments 1
5 min read
Modernizing from PostgreSQL to Serverless with Fauna Part 1 (2023 Update)

Modernizing from PostgreSQL to Serverless with Fauna Part 1 (2023 Update)

7
Comments
23 min read
10 study tips for the AWS Certified Database – Specialty Certification

10 study tips for the AWS Certified Database – Specialty Certification

6
Comments
5 min read
Get a Feature-Rich Open-Source Community Edition Graph Database Ready for Production

Get a Feature-Rich Open-Source Community Edition Graph Database Ready for Production

1
Comments
9 min read
What is database transaction?

What is database transaction?

Comments
2 min read
Beginner's Guide to Ruby Methods

Beginner's Guide to Ruby Methods

Comments
5 min read
Flyway Migrations Naming Strategy in a Big Project

Flyway Migrations Naming Strategy in a Big Project

20
Comments
5 min read
Why a SQL Statement Often Consists of Hundreds of Lines, Measured by KBs?

Why a SQL Statement Often Consists of Hundreds of Lines, Measured by KBs?

Comments
13 min read
How to Configure Database Access Control and Data Anonymization for Developer

How to Configure Database Access Control and Data Anonymization for Developer

1
Comments
8 min read
Getting Started with a Web Scraping Project 🕷️🤖

Getting Started with a Web Scraping Project 🕷️🤖

17
Comments 2
14 min read
🚀Batched Nested Loop to reduce read requests to the distributed storage

🚀Batched Nested Loop to reduce read requests to the distributed storage

Comments
8 min read
Scalable Sequence for PostgreSQL

Scalable Sequence for PostgreSQL

3
Comments
6 min read
SQL Commands Cheat Sheet

SQL Commands Cheat Sheet

3
Comments
11 min read
Bitemporality, or how to change the past

Bitemporality, or how to change the past

2
Comments
9 min read
Proactive PostgreSQL Database(s) Performance Scanner

Proactive PostgreSQL Database(s) Performance Scanner

4
Comments
9 min read
How to avoid messing up squash migration in Hasura

How to avoid messing up squash migration in Hasura

5
Comments 2
8 min read
Top 3 Most Popular Databases Among Web Developers and When to Use Them

Top 3 Most Popular Databases Among Web Developers and When to Use Them

10
Comments
3 min read
Graph Database vs Relational Database: What to Choose?

Graph Database vs Relational Database: What to Choose?

1
Comments
11 min read
PostgreSQL 14: Database migration with pg_dump

PostgreSQL 14: Database migration with pg_dump

10
Comments 3
2 min read
ACID properties of Database Explained

ACID properties of Database Explained

4
Comments
3 min read
Auto Vacuum Explained: Postgres Internals

Auto Vacuum Explained: Postgres Internals

1
Comments
2 min read
From Stream to Kotlin and Finally to SPL

From Stream to Kotlin and Finally to SPL

Comments 2
7 min read
Amazon Neptune Serverless - The Graph DB for Greek Gods

Amazon Neptune Serverless - The Graph DB for Greek Gods

11
Comments 5
6 min read
How To Group Result By A Particular TimeFrame E.g Weeks Using PostgreSQL

How To Group Result By A Particular TimeFrame E.g Weeks Using PostgreSQL

Comments
2 min read
Migraçþes no Django sem Downtime

Migraçþes no Django sem Downtime

Comments
4 min read
Database Comparison - SQL vs. NoSQL (MySQL vs PostgreSQL vs Redis vs MongoDB)

Database Comparison - SQL vs. NoSQL (MySQL vs PostgreSQL vs Redis vs MongoDB)

Comments
5 min read
Boost Your Query Performance with Function-Based Indexes in PostgreSQL

Boost Your Query Performance with Function-Based Indexes in PostgreSQL

3
Comments
1 min read
Database Change Management with Snowflake and GitHub

Database Change Management with Snowflake and GitHub

4
Comments 1
7 min read
Data Engineering Toolset 2023

Data Engineering Toolset 2023

4
Comments
2 min read
Database Change Management with Snowflake

Database Change Management with Snowflake

Comments
7 min read
Data Rollup in YugabyteDB🚀 and PostgreSQL🐘

Data Rollup in YugabyteDB🚀 and PostgreSQL🐘

3
Comments
4 min read
Passwords in SQL-Server C#

Passwords in SQL-Server C#

6
Comments
3 min read
Design considerations for large data import

Design considerations for large data import

1
Comments
3 min read
Track User Online Activity Accurately In Laravel

Track User Online Activity Accurately In Laravel

1
Comments
4 min read
One-page Database cheat sheet

One-page Database cheat sheet

4
Comments
1 min read
chatGPT - building an automated database testing tool

chatGPT - building an automated database testing tool

2
Comments
3 min read
Moving AWS RDS from Single AZ To Multi AZ

Moving AWS RDS from Single AZ To Multi AZ

7
Comments 1
5 min read
Introduction to Streaming Databases

Introduction to Streaming Databases

1
Comments
5 min read
Mermerd - Generate your ERD blazingly fast

Mermerd - Generate your ERD blazingly fast

Comments
2 min read
DBMS with mysql. Without using GUI...

DBMS with mysql. Without using GUI...

1
Comments
1 min read
The basic of the advanced SQL queries: Tuning

The basic of the advanced SQL queries: Tuning

2
Comments
4 min read
How to keep a history of MQTT data with Node.js

How to keep a history of MQTT data with Node.js

8
Comments
4 min read
Side-by-side comparison of serverless databases

Side-by-side comparison of serverless databases

4
Comments 1
4 min read
Build an Intercom clone in Nuxt.js - Part Two

Build an Intercom clone in Nuxt.js - Part Two

5
Comments
4 min read
Using NebulaGraph Importer to Import Data into NebulaGraph Database

Using NebulaGraph Importer to Import Data into NebulaGraph Database

Comments
5 min read
Fuzzy query for CipherColumn | ShardingSphere 5.3.0 Deep Dive

Fuzzy query for CipherColumn | ShardingSphere 5.3.0 Deep Dive

Comments
10 min read
Beyond ORM and Stored Procedures

Beyond ORM and Stored Procedures

2
Comments
12 min read
Use-Cases of the Shortest Path Algorithm

Use-Cases of the Shortest Path Algorithm

Comments
5 min read
Integration Test for Azure Functions and Cosmos DB walkthrough

Integration Test for Azure Functions and Cosmos DB walkthrough

1
Comments
4 min read
The Cypher Query Language - Best Practices

The Cypher Query Language - Best Practices

Comments
6 min read
Tutorial part-3: key-value store - increment and decrement operations

Tutorial part-3: key-value store - increment and decrement operations

2
Comments
3 min read
CLI Client for ReductStore v0.4.0 has been released

CLI Client for ReductStore v0.4.0 has been released

2
Comments
1 min read
loading...