PostgreSQL — A multi purpose underrated open source database capable of handling RDMS, Analytics and NoSQL functionalities

Bharat Dwarkani
1 min readMay 28, 2020

--

Postgres 13.1 beta releasedhttps://www.postgresql.org/about/news/2040/

PgConf 2020 on going https://www.pgcon.org/2020/
PgConf 2020 Indiahttps://pgconf.in/conferences/pgconfin2020/schedule/events

Some advanced not known features which PostgreSQL is capable of

RDMS — as like other Database ACID compliant

NoSQL — Using jsonb — provides native json querying functionalities

https://www.pgcon.org/events/pgcon_2020/schedule/speaker/84-oleg-bartunov/

http://www.sai.msu.su/~megera/postgres/talks/jsonb-roadmap-pgcon-2020.pdf

https://www.compose.com/articles/faster-operations-with-the-jsonb-data-type-in-postgresql/

ZedStore — Columnar Storage — as like Cassandra

https://www.pgcon.org/events/pgcon_2020/schedule/session/44-zedstore-in-core-column-store-for-postgres/

TimeScaleDB — Timeseries Database
https://blog.timescale.com/blog/building-a-distributed-time-series-database-on-postgresql/

https://www.pgcon.org/events/pgcon_2020/schedule/session/58-time-series-databases-a-deeper-look/

DB for Analytics

http://www.silota.com/docs/getting-started/postgres-vs-mysql-database-analytics.html

Virtual Computed Columns

https://rob.conery.io/2019/10/24/virtual-computed-columns-in-postgresql-12/

Advanced Indexing

https://sharetechlinks.com/tags/98/postgre-sql?page=1

Advanced Full Text Search

https://rob.conery.io/2019/10/29/fine-tuning-full-text-search-with-postgresql-12/

Materialized Views

https://www.postgresql.org/docs/9.3/rules-materializedviews.html

Using Postgres as a Queue — 10,000 jobs per second

https://gist.github.com/chanks/7585810

Some more links accumulated here

https://sharetechlinks.com/tags/98/postgre-sql

--

--

Bharat Dwarkani

Tech Enthusiast, Full Stack Software Engineer, Product Manager, Engineering Enterprise SaaS product