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.
Architecture on a Post-it note: Optimizing AWS Aurora Databases

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

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

Yet another journey to the cloud: User Management

1
Comments
5 min read
OOP: Database optimization

OOP: Database optimization

2
Comments
3 min read
Tigris MongoDB compatibility now in beta

Tigris MongoDB compatibility now in beta

Comments
5 min read
Graph Databases in PostgreSQL: Apache AGE

Graph Databases in PostgreSQL: Apache AGE

2
Comments
2 min read
How to choose the right streaming database

How to choose the right streaming database

12
Comments
7 min read
Apache-age: A Powerful and Open Source Graph Database Solution. [Part # 2]

Apache-age: A Powerful and Open Source Graph Database Solution. [Part # 2]

Comments
2 min read
"Building a Social Network App with Apache-age: A Beginner's Guide"

"Building a Social Network App with Apache-age: A Beginner's Guide"

Comments
3 min read
Essential SQL Commands For Data Science

Essential SQL Commands For Data Science

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

DynamoDB Basic - Part 1: Introduction DynamoDB

4
Comments
5 min read
Databases: Why Does It Matter What We Choose?

Databases: Why Does It Matter What We Choose?

5
Comments 2
6 min read
Query Real Time Data in Kafka Using SQL

Query Real Time Data in Kafka Using SQL

6
Comments
9 min read
CLI Client for ReductStore v0.8.0 has been released

CLI Client for ReductStore v0.8.0 has been released

6
Comments
1 min read
Data Breaches and Healthcare: Is India Lacking in Healthcare Data Security?

Data Breaches and Healthcare: Is India Lacking in Healthcare Data Security?

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

How to effectively store and ANALYSE logs in AWS CLOUD

5
Comments
8 min read
Understanding Foreign Data Wrappers (FDW) in PostgreSQL 4.1

Understanding Foreign Data Wrappers (FDW) in PostgreSQL 4.1

2
Comments
2 min read
Uncovering Hidden Gems: PostgreSQL Window Functions You May Not Know About

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

1
Comments
2 min read
Apache-age: The best Open Source Graph Database Solution

Apache-age: The best Open Source Graph Database Solution

1
Comments
3 min read
Revisiting SQL composition in JavaScript and TypeScript

Revisiting SQL composition in JavaScript and TypeScript

1
Comments
4 min read
How to write an anonymous PL/SQL function and use it in your SQL statement

How to write an anonymous PL/SQL function and use it in your SQL statement

Comments
3 min read
Clustered and Foreign Tables in PostgreSQL

Clustered and Foreign Tables in PostgreSQL

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

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

1
Comments
1 min read
How to Encrypt an Unencrypted RDS DB Instance

How to Encrypt an Unencrypted RDS DB Instance

2
Comments
4 min read
Saving your data

Saving your data

Comments
3 min read
What is the best way to structure my database?

What is the best way to structure my database?

1
Comments
5 min read
Designing A Key Value Store

Designing A Key Value Store

Comments 4
4 min read
EF Core 7: Json columns

EF Core 7: Json columns

10
Comments
9 min read
Database Change Management with ClickHouse

Database Change Management with ClickHouse

Comments
7 min read
Event-Driven Serverless Data Architecture

Event-Driven Serverless Data Architecture

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

24
Comments 1
10 min read
A Complete Guide to Database Security Testing

A Complete Guide to Database Security Testing

5
Comments 1
3 min read
Making sure our database queries are fast

Making sure our database queries are fast

17
Comments
3 min read
Create a Word Guessing Game With Apache AGE

Create a Word Guessing Game With Apache AGE

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

Building real-time analytics into your next project

1
Comments
9 min read
Maximizing PostgreSQL Cluster Performance with Pgpool-II Load Balancing and Scaling Techniques

Maximizing PostgreSQL Cluster Performance with Pgpool-II Load Balancing and Scaling Techniques

3
Comments
3 min read
Easy CRUD backend development with Zod and codehooks-crudlify

Easy CRUD backend development with Zod and codehooks-crudlify

1
Comments
3 min read
SQL 101:INTRODUCTION TO SQL FOR DATA ANALYSIS

SQL 101:INTRODUCTION TO SQL FOR DATA ANALYSIS

1
Comments 1
7 min read
Aumentando a performance do Dapper

Aumentando a performance do Dapper

Comments 2
3 min read
Outer Join Optimization

Outer Join Optimization

2
Comments
5 min read
Multi-tenant implementation approaches with Prisma and ZenStack

Multi-tenant implementation approaches with Prisma and ZenStack

14
Comments 2
8 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
Using uuid in Knex.js and PostgreSQL

Using uuid in Knex.js and PostgreSQL

Comments
2 min read
Use Prisma with an SQLite DATETIME datatype

Use Prisma with an SQLite DATETIME datatype

1
Comments
4 min read
Unleashing the Power of Data Mining: Unlocking Hidden Insights in Your Database

Unleashing the Power of Data Mining: Unlocking Hidden Insights in Your Database

1
Comments
2 min read
A Practical Guide to SQL Dates with DuckDB.

A Practical Guide to SQL Dates with DuckDB.

Comments 2
9 min read
Streamline your edge computing workflows with ReductStore, now available on Snap

Streamline your edge computing workflows with ReductStore, now available on Snap

3
Comments
1 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
Hacking 101: Common Attacks and How to Stop Them

Hacking 101: Common Attacks and How to Stop Them

1
Comments
5 min read
Create a MySQL RDS Database Instance with Terraform and connect with MySQL Workbench

Create a MySQL RDS Database Instance with Terraform and connect with MySQL Workbench

9
Comments
4 min read
PostgreSQL Process and Memory Architecture: (CHAPTER 2: THE INTERNALS OF PostgreSQL)

PostgreSQL Process and Memory Architecture: (CHAPTER 2: THE INTERNALS OF PostgreSQL)

2
Comments
2 min read
SQL Server and Flyway: a Docker approach

SQL Server and Flyway: a Docker approach

3
Comments
4 min read
Decentralized Databases: ComposeDB

Decentralized Databases: ComposeDB

25
Comments 4
10 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
What is a database Foreign Key? A beginner's tutorial

What is a database Foreign Key? A beginner's tutorial

3
Comments
7 min read
Database Change Management with Amazon Aurora

Database Change Management with Amazon Aurora

Comments
9 min read
How This BaaS Platform Is Pushing the Boundaries of Scalable Data Storage

How This BaaS Platform Is Pushing the Boundaries of Scalable Data Storage

3
Comments 1
5 min read
Database Design 101: An Introduction

Database Design 101: An Introduction

2
Comments
2 min read
Don't Break the Bank on SQL Queries: BigQuery On-Demand vs Flat-Rate prices. Which Saves You More? 💰😎

Don't Break the Bank on SQL Queries: BigQuery On-Demand vs Flat-Rate prices. Which Saves You More? 💰😎

3
Comments 1
5 min read
Prisma Client Extensions: Use Cases and Pitfalls

Prisma Client Extensions: Use Cases and Pitfalls

8
Comments
5 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
loading...