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
1.7 KiB
title, description, image, createdAt, draft, categories, tags
| title | description | image | createdAt | draft | categories | tags | |||
|---|---|---|---|---|---|---|---|---|---|
| Is PostgreSQL Eating the Database World? | Explore PostgreSQL's versatility and its impact on the database landscape. | https://assets.bytebytego.com/diagrams/0237-is-postgresql-eating-the-database-world.png | 2024-02-27 | false |
|
|
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.