/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.
/2 ๐นOLTP (Online Transaction Processing)
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.
/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.
/5 ๐นStreaming
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.
/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.
/8 ๐นDistributed Tables
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:
Share this Scrolly Tale with your friends.
A Scrolly Tale is a new way to read Twitter threads with a more visually immersive experience.
Discover more beautiful Scrolly Tales like this.