postgresql-ecosystem

Overview of the capabilities and tooling directly tied to PostgreSQL

(Click here to view/edit) the diagram with hyperlinks, hosted by draw.io.

1. Why

   1. To facilitate architecture design discussions on capabilities enabled by the PostgreSQL ecosystem.
   2. To increase the viability of PostgreSQL.
   3. To contribute back to the generous and supportive PostgreSQL community.

2. What

   1. A diagram of the key capabilities clustered with hyperlinked entities that enable each capability.

3. How

   1. Open Source
      1. github.com
      2. draw.io
   2. Allow for PRs, collaboration.
   3. With Hyperlinks to other sites.
   4. Feedback to alex at efficiencygeek.com

History:

1. August 2024

   1. Created a category - GenAI.
   2. Added PostgresML, Full GenAI ML stack inside PostgreSQL.
   3. Added postgres.new, In-browser Postgres with an AI interface.
   4. Removed Ottertune, as it shutdown as of 6/14/24.
   5. Removed Optimization category.

2. December 2023

   1. Added Google Cloud Spanner.
   2. Added Azure Data API Builder.
   3. Added Vector Schema Model.
   4. Removed Swarm64 as it was purchased by ServiceNow.
   5. Updated certain links to be more topic specific.
   6. Updated diagram file format to an editable bitmapped image (drawio.png) and simplify edit and display of the drawio file.

3. November 2022

   1. Added Ottertune, Machine learning augmtented tuning for PostgreSQL.
   2. Added a new category Optimization to match.

4. October 2022

   1. Added Neon Serverless.
   2. Added Azure Cosmos DB for PostgreSQL.
   3. Added Google Cloud AlloyDB for PostgreSQL.

5. September 2022

   1. Added Supabase as a Cloud Provider.
   2. Added referrence to original Chicago PUG presentation (see October 2019 below).

6. November 2021

   1. Added Babelfish SQL Server Adapter.

7. Febuary 23, 2021

   1. Referenced by Marco Slot of Microsoft Citus Data in this presentation Citus: Distributed PostgreSQL as an Extension Vaccination Database Talks Carnegie Mellon

8. October 2019 - MMF1

   1. Presented this deck at the Chicago PostgreSQL Users' Group October 2019.
   2. Complete Data on Categories, Nodes with Links
   3. Embed static image into this github repo, and just do a save as image from draw.io.

Backlog:

1. Embed static diagram directly linked to draw.io, avoiding the save as image step.

Thumbnail Link: