ABN TechWeek: Why is PostgreSQL voted as the most loved database by developers?

ABN Tech Week trains engineers on the most important issues in building highly scalable software systems. The topic today is: Why is PostgreSQL voted as the most loved database by developers?

The diagram shows the many use cases by PostgreSQL – one database that includes almost all the use cases developers need.

OLTP (Online Transaction Processing)
We can use PostgreSQL for CRUD (Create-Read-Update-Delete) operations.

OLAP (Online Analytical Processing)
We can use PostgreSQL for analytical processing. PostgreSQL is based on HTAP (Hybrid transactional/analytical processing) architecture, so it can handle both OLTP and OLAP well.

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.

Streaming
PipelineDB is a PostgreSQL extension for high-performance time-series aggregation, designed to power real-time reporting and analytics applications.

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.

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.

Distributed Tables
CitusData scales Postgres by distributing data & queries.

About ABN Asia: ABN Asia was founded by people with deep roots in academia, with work experience in the US, Holland, Hungary, Japan, South Korea, Singapore, and Vietnam. ABN Asia is where academy and technology meet opportunity. We’re the software maker with academy origins that’s shaking up the SME game in Asia. With our cutting-edge solutions and competent software development services, we’re helping small and medium-sized businesses level up and take on the big players.

AbnAsia.org Software. Faster. Better. More Reliable. +84945924877 (Asia# Mobile, WhatsApp, Telegram, Viber, Zalo); +16699996606 (US# Mobile, WhatsApp, Telegram) [email protected]