PostgreSQL - A multi purpose underrated open source database capable of handling RDMS and NoSQL functionalties

Bharat Dwarkani | May 28, 2020 | Database

Postgres 13.1 beta released — https://www.postgresql.org/about/news/2040/

PgConf 2020 on going — https://www.pgcon.org/2020/

Some advanced not known features which PostgreSQL is capable of . Links accumulated from different sources

RDMS — as like other Database with Full Advanced ACID compliant

NoSQL — Using jsonb — provides native jsonB advanced operations

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 Database

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

TimeScaleDB — Timeseries Database

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/

Indexes

https://severalnines.com/database-blog/postgresql-index-vs-innodb-index-understanding-differences

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?page=1

bookmarks
share
visibility34
visibility34 share bookmarks
add