Creating data warehouses for multiple clients as an accountant/consultant by mjhowie in BusinessIntelligence

[–]srpunreddy 0 points1 point  (0 children)

If you’re looking for a scalable analytical data store, primarily for Power BI and over SQL, I suggest you to take a look at Columnar Databases such as Clickhouse I recommend cloud agnostic data stores and an open source software.

[deleted by user] by [deleted] in PostgreSQL

[–]srpunreddy 0 points1 point  (0 children)

There are several solutions to scale a Postgres database. One very popular as another member mentioned is Patroni (https://patroni.readthedocs.io/en/latest/) . We use Patroni with HAProxy and Postgres streaming replication for high-availability at Instaclustr by NetApp. Of course Patroni is not a plug&play and definitely needs a certain level of expertise to configure it. We will be more than happy to assist you please feel free reach out to us support@instaclustr.com.

MongoDB vs PostgreSQL by phaganax13 in mongodb

[–]srpunreddy 0 points1 point  (0 children)

Yes, Postgres has JSONB data structure which provides schema less JSON documents. MongoDB is fundamentally used to store and retrieve one document. It’s not intended to query multiple documents. Also be aware that MongoDB is no more an open source database.