mirror of
https://github.com/ByteByteGoHq/system-design-101.git
synced 2026-04-06 10:17: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
51 lines
1.7 KiB
Markdown
51 lines
1.7 KiB
Markdown
---
|
|
title: "Is PostgreSQL Eating the Database World?"
|
|
description: "Explore PostgreSQL's versatility and its impact on the database landscape."
|
|
image: "https://assets.bytebytego.com/diagrams/0237-is-postgresql-eating-the-database-world.png"
|
|
createdAt: "2024-02-27"
|
|
draft: false
|
|
categories:
|
|
- database-and-storage
|
|
tags:
|
|
- "PostgreSQL"
|
|
- "Databases"
|
|
---
|
|
|
|
|
|
|
|
It seems that no matter what the use case, PostgreSQL supports it. When in doubt, you can simply use PostgreSQL.
|
|
|
|
## PostgreSQL Capabilities
|
|
|
|
* **TimeSeries**
|
|
|
|
PostgreSQL embraces Timescale, a powerful time-series database extension for efficient handling of time-stamped data.
|
|
|
|
* **Machine Learning**
|
|
|
|
With pgVector and PostgresML, Postgres can support machine learning capabilities and vector similarity searches.
|
|
|
|
* **OLAP**
|
|
|
|
Postgres can support OLAP with tools such as Hydra, Citus, and pg\_analytics.
|
|
|
|
* **Derived**
|
|
|
|
Even derived databases such as DuckDB, FerretDB, CockroachDB, AlloyDB, YugaByte DB, Supabase, etc provide PostgreSQL.
|
|
|
|
* **GeoSpatial**
|
|
|
|
PostGIS extends PostgreSQL with geospatial capabilities, enabling you to easily store, query, and analyze geographic data.
|
|
|
|
* **Search**
|
|
|
|
Postgres extensions like pgroonga, ParadeDB, and ZomboDB provide full-text search, text indexing, and data parsing capabilities.
|
|
|
|
* **Federated**
|
|
|
|
Postgres seamlessly integrates with various data sources such as MongoDB, MySQL, Redis, Oracle, ParquetDB, SQLite, etc, enabling federated querying and data access.
|
|
|
|
* **Graph**
|
|
|
|
Apache AGE and EdgeDB are graph databases built on top of PostgreSQL. Also, pg\_graphql is an extension that provides GraphQL support for Postgres.
|