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.
Building a headless e-commerce app using OceanBase and Python

Building a headless e-commerce app using OceanBase and Python

1
Comments
13 min read
From Zero to Database Hero: A Beginner's Journey into SQL

From Zero to Database Hero: A Beginner's Journey into SQL

Comments
5 min read
PostgreSQL: Query Optimization With Python and PgBouncer

PostgreSQL: Query Optimization With Python and PgBouncer

4
Comments
5 min read
Why I’m Still Obsessed with the Time Series Database

Why I’m Still Obsessed with the Time Series Database

Comments
10 min read
How ACID is Citus? (compared to YugabyteDB)

How ACID is Citus? (compared to YugabyteDB)

4
Comments
4 min read
3 Free Tools to Start a Local Database Instance on Mac

3 Free Tools to Start a Local Database Instance on Mac

6
Comments 1
2 min read
Protect Production Database from Wrong Migrations

Protect Production Database from Wrong Migrations

1
Comments 2
1 min read
Installing Postgres Extensions with Django Migrations.

Installing Postgres Extensions with Django Migrations.

1
Comments
2 min read
ORM, Prisma, and How You Should Build Your Next Backend Database Project

ORM, Prisma, and How You Should Build Your Next Backend Database Project

25
Comments
6 min read
OOP: Database optimization

OOP: Database optimization

2
Comments
3 min read
RudderStack - The Open Source Alternative to Segment

RudderStack - The Open Source Alternative to Segment

Comments
6 min read
Prisma + ZenStack: An Alternative to PostgREST

Prisma + ZenStack: An Alternative to PostgREST

17
Comments
4 min read
30,000 QPS Per Node: How We Increased Database Query Concurrency by 20 Times

30,000 QPS Per Node: How We Increased Database Query Concurrency by 20 Times

9
Comments
13 min read
Creating Database-Driven Astro Sites with the Tigris Astro Integration

Creating Database-Driven Astro Sites with the Tigris Astro Integration

6
Comments
3 min read
Futuristic Databases

Futuristic Databases

5
Comments 1
7 min read
When To Use SQL vs NoSQL: An Expert Guide to Databases

When To Use SQL vs NoSQL: An Expert Guide to Databases

2
Comments
11 min read
Go and Redis, Better Together 🤝

Go and Redis, Better Together 🤝

2
Comments
9 min read
Installing MongoDB on latest MacOS Intel and M1 base processors with Homebrew

Installing MongoDB on latest MacOS Intel and M1 base processors with Homebrew

5
Comments
2 min read
NoSQL Databases vs Graph Databases: Which one should you use?

NoSQL Databases vs Graph Databases: Which one should you use?

178
Comments 6
14 min read
AI tool to automatically write, optimize, edit, and debug SQL

AI tool to automatically write, optimize, edit, and debug SQL

7
Comments
2 min read
Graph Databases in PostgreSQL: Apache AGE

Graph Databases in PostgreSQL: Apache AGE

2
Comments
2 min read
pl/sql tutorial for beginners

pl/sql tutorial for beginners

5
Comments
1 min read
620. Not Boring Movies leetcode solution

620. Not Boring Movies leetcode solution

5
Comments
1 min read
610. Triangle Judgement

610. Triangle Judgement

4
Comments
1 min read
The Art of Data Validation: A Comprehensive Guide for Database Professionals

The Art of Data Validation: A Comprehensive Guide for Database Professionals

6
Comments
8 min read
PgBouncer. Reduce the load on the PostgreSQL server and improve performance.

PgBouncer. Reduce the load on the PostgreSQL server and improve performance.

4
Comments
6 min read
[PostgreSQL] Installing PostgreSQL through Homebrew on MacOS

[PostgreSQL] Installing PostgreSQL through Homebrew on MacOS

27
Comments 4
2 min read
How to measure performance of PostgreSQL Database Server(s)?

How to measure performance of PostgreSQL Database Server(s)?

4
Comments
5 min read
The script of AGE (ch. 01)

The script of AGE (ch. 01)

2
Comments
4 min read
How to choose AWS Database

How to choose AWS Database

9
Comments 2
4 min read
607. Sales Person leetcode solution

607. Sales Person leetcode solution

4
Comments
1 min read
The ultimate beginners guide to databases

The ultimate beginners guide to databases

17
Comments
7 min read
Setup MongoDB replica set locally in docker or with Atlas for Prisma ORM

Setup MongoDB replica set locally in docker or with Atlas for Prisma ORM

7
Comments 3
3 min read
SQL Versus NoSQL Databases: Which to Use, When, and Why

SQL Versus NoSQL Databases: Which to Use, When, and Why

16
Comments
9 min read
Getting Started with AGE and PostgreSQL: Setting Up and Modifying the Source Code 😊

Getting Started with AGE and PostgreSQL: Setting Up and Modifying the Source Code 😊

4
Comments
2 min read
Apache AGE & Python(Pt. 2)

Apache AGE & Python(Pt. 2)

1
Comments
2 min read
What Is a Time-Series Database (TSDB) and Why Do I Need One?

What Is a Time-Series Database (TSDB) and Why Do I Need One?

Comments
6 min read
Recommender System with Apache AGE

Recommender System with Apache AGE

6
Comments
4 min read
Exploring Apache-AGE Hybrid Queries

Exploring Apache-AGE Hybrid Queries

4
Comments 1
5 min read
Setup HarperDB on Equinix Bare Metal Server

Setup HarperDB on Equinix Bare Metal Server

15
Comments 2
8 min read
Supercharge your geolocalized DynamoDB Queries with Z-Order Indexing 🚀

Supercharge your geolocalized DynamoDB Queries with Z-Order Indexing 🚀

53
Comments
3 min read
Stored Procedures in SQL database

Stored Procedures in SQL database

2
Comments
2 min read
Deno's New Built-In Key-value Database "KV"

Deno's New Built-In Key-value Database "KV"

1
Comments 2
1 min read
Top 10 Best Vector Databases & Libraries

Top 10 Best Vector Databases & Libraries

24
Comments 1
4 min read
DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB

DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB

8
Comments
5 min read
Optimizing Server Resources using Uniform Balance

Optimizing Server Resources using Uniform Balance

1
Comments
6 min read
Zero Trust Approach to Cloud Data Security through Software-Defined Perimeter (SDP)

Zero Trust Approach to Cloud Data Security through Software-Defined Perimeter (SDP)

2
Comments
4 min read
Add More Flexibility To Your PostgreSQL Queries With Apache AGE

Add More Flexibility To Your PostgreSQL Queries With Apache AGE

2
Comments
2 min read
Using Axios In React JS....

Using Axios In React JS....

Comments
3 min read
Why are relational databases useful🤷🏻‍♂️

Why are relational databases useful🤷🏻‍♂️

13
Comments 2
9 min read
How to create a PostgreSQL Database on Azure

How to create a PostgreSQL Database on Azure

11
Comments
5 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
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
Introducing Vector Search on Rockset: How to run semantic search with OpenAI and Rockset

Introducing Vector Search on Rockset: How to run semantic search with OpenAI and Rockset

1
Comments
9 min read
This week at Dozer #5

This week at Dozer #5

1
Comments
3 min read
Relational Databases vs Graph Databases: A Comparison

Relational Databases vs Graph Databases: A Comparison

2
Comments
3 min read
How to install OceanBase on an AWS EC2 instance [Step-by-step guide]

How to install OceanBase on an AWS EC2 instance [Step-by-step guide]

Comments
6 min read
Business Logic Inside Database - How Evil Is It?

Business Logic Inside Database - How Evil Is It?

13
Comments
4 min read
Cluster table in Your HD

Cluster table in Your HD

3
Comments
3 min read
Scaling Apache AGE for Large Datasets: A Guide on How to Scale Apache AGE for Processing Large Datasets

Scaling Apache AGE for Large Datasets: A Guide on How to Scale Apache AGE for Processing Large Datasets

2
Comments
2 min read
loading...