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.
Understanding File Structure for Backend API development using NodeJS, Express, and PostgreSQL

Understanding File Structure for Backend API development using NodeJS, Express, and PostgreSQL

4
Comments
2 min read
The impasse of SQL performance optimizing

The impasse of SQL performance optimizing

1
Comments
9 min read
Perform What-if Analysis of Your Network Directly in Storage Without Compromising Data Integrity

Perform What-if Analysis of Your Network Directly in Storage Without Compromising Data Integrity

1
Comments
9 min read
Best Database for C++ Development

Best Database for C++ Development

3
Comments
2 min read
When are PostgreSQL prepared statements fully prepared for execution?

When are PostgreSQL prepared statements fully prepared for execution?

4
Comments
5 min read
Redis: What It Is, What It Does, and Why You Should Care

Redis: What It Is, What It Does, and Why You Should Care

3
Comments
10 min read
MySQL: How to create One-to-Many Relationship

MySQL: How to create One-to-Many Relationship

6
Comments
6 min read
How to Improve the Performance of Your Rails App by Eliminating N+1 Database Queries

How to Improve the Performance of Your Rails App by Eliminating N+1 Database Queries

12
Comments
4 min read
Easy backend for React

Easy backend for React

2
Comments
5 min read
Get the count of affected rows with ease: The power of the RETURNING clause in Postgres

Get the count of affected rows with ease: The power of the RETURNING clause in Postgres

6
Comments 1
2 min read
PostgreSQL vs MySQL: Which Best Suits Your Business?

PostgreSQL vs MySQL: Which Best Suits Your Business?

1
Comments
3 min read
How to Build a Spotify Recommendation Engine Using Kafka and Memgraph

How to Build a Spotify Recommendation Engine Using Kafka and Memgraph

1
Comments
5 min read
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

2
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

1
Comments
9 min read
Mongoose ODM Best Practices Part One.

Mongoose ODM Best Practices Part One.

3
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

12
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 🕷️🤖

13
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

3
Comments
8 min read
Scalable Sequence for PostgreSQL

Scalable Sequence for PostgreSQL

2
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

1
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: Introduction

Graph Database: Introduction

2
Comments
2 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

8
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
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
Amazon Neptune Serverless - The Graph DB for Greek Gods

Amazon Neptune Serverless - The Graph DB for Greek Gods

9
Comments 4
6 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
Passwords in SQL-Server C#

Passwords in SQL-Server C#

5
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
What is key_buffer_size in MySQL?

What is key_buffer_size in MySQL?

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