/1 Why is PostgreSQL voted the ๐ฆ๐จ๐ฌ๐ญ ๐ฅ๐จ๐ฏ๐๐ ๐๐๐ญ๐๐๐๐ฌ๐ by Stackoverflow 2022 Developer Survey?
The diagram shows the many use cases by PostgreSQL - one database that includes almost ๐๐ฅ๐ฅ ๐ญ๐ก๐ ๐ฎ๐ฌ๐ ๐๐๐ฌ๐๐ฌ developers need.
The diagram shows the many use cases by PostgreSQL - one database that includes almost ๐๐ฅ๐ฅ ๐ญ๐ก๐ ๐ฎ๐ฌ๐ ๐๐๐ฌ๐๐ฌ developers need.
/2 ๐นOLTP (Online Transaction Processing)
We can use PostgreSQL for CRUD (Create-Read-Update-Delete) operations.
We can use PostgreSQL for CRUD (Create-Read-Update-Delete) operations.
/3 ๐นOLAP (Online Analytical Processing)
We can use PostgreSQL for analytical processing. PostgreSQL is based on ๐๐๐๐ (Hybrid transactional/analytical processing) architecture, so it can handle both OLTP and OLAP well.
We can use PostgreSQL for analytical processing. PostgreSQL is based on ๐๐๐๐ (Hybrid transactional/analytical processing) architecture, so it can handle both OLTP and OLAP well.
/4 ๐น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.
A FDW is an extension available in PostgreSQL that allows us to access a table or schema in one database from another.
/5 ๐นStreaming
PipelineDB is a PostgreSQL extension for high-performance time-series aggregation, designed to power real-time reporting and analytics applications.
PipelineDB is a PostgreSQL extension for high-performance time-series aggregation, designed to power real-time reporting and analytics applications.
/6 ๐น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.
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.
/7 ๐น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.
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.
/8 ๐นDistributed Tables
CitusData scales Postgres by distributing data & queries.
CitusData scales Postgres by distributing data & queries.
/9 ๐ Over to you: Which database do you like the most?
/10 I hope you've found this thread helpful.
Follow me @alexxubyte for more.
Like/Retweet the first tweet below if you can:
Follow me @alexxubyte for more.
Like/Retweet the first tweet below if you can:
https://twitter.com/alexxubyte/status/1585296460072919040
โข โข โข
Missing some Tweet in this thread? You can try to
force a refresh
ใ
