mirror of
https://github.com/ByteByteGoHq/system-design-101.git
synced 2026-04-11 12:27:24 -04:00
ee4b7305a2
This PR adds all the guides from [Visual Guides](https://bytebytego.com/guides/) section on bytebytego to the repository with proper links. - [x] Markdown files for guides and categories are placed inside `data/guides` and `data/categories` - [x] Guide links in readme are auto-generated using `scripts/readme.ts`. Everytime you run the script `npm run update-readme`, it reads the categories and guides from the above mentioned folders, generate production links for guides and categories and populate the table of content in the readme. This ensures that any future guides and categories will automatically get added to the readme. - [x] Sorting inside the readme matches the actual category and guides sorting on production
47 lines
1.7 KiB
Markdown
47 lines
1.7 KiB
Markdown
---
|
|
title: "Why PostgreSQL is the Most Loved Database"
|
|
description: "Explore why PostgreSQL was voted the most loved database in the 2022 survey."
|
|
image: "https://assets.bytebytego.com/diagrams/0303-postgres.png"
|
|
createdAt: "2024-02-25"
|
|
draft: false
|
|
categories:
|
|
- database-and-storage
|
|
tags:
|
|
- "PostgreSQL"
|
|
- "Database"
|
|
---
|
|
|
|
|
|
|
|
The diagram shows the many use cases of PostgreSQL - one database that includes almost **all the use cases** developers need.
|
|
|
|
## Use Cases of PostgreSQL
|
|
|
|
* **OLTP (Online Transaction Processing)**
|
|
|
|
We can use PostgreSQL for CRUD (Create-Read-Update-Delete) operations.
|
|
|
|
* **OLAP (Online Analytical Processing)**
|
|
|
|
We can use PostgreSQL for analytical processing. PostgreSQL is based on **HTAP**(Hybrid transactional/analytical processing) architecture, so it can handle both OLTP and OLAP well.
|
|
|
|
* **FDW (Foreign Data Wrapper)**
|
|
|
|
A FDW is an extension available in PostgreSQL that allows us to access a table or schema in one database from another.
|
|
|
|
* **Streaming**
|
|
|
|
PipelineDB is a PostgreSQL extension for high-performance time-series aggregation, designed to power real-time reporting and analytics applications.
|
|
|
|
* **Geospatial**
|
|
|
|
PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects, allowing location queries to be run in SQL.
|
|
|
|
* **Time Series**
|
|
|
|
Timescale extends PostgreSQL for time series and analytics. For example, developers can combine relentless streams of financial and tick data with other business data to build new apps and uncover unique insights.
|
|
|
|
* **Distributed Tables**
|
|
|
|
CitusData scales Postgres by distributing data & queries.
|