On 1/4/23 06:26, Age Apache wrote:
Dear PG experts,
I am new to postgres, and I am also not a DBA. I am a solo developer
who is trying to evaluate what database to use for my hybrid
multi-tenancy sub-apps i.e. users of the application will be
authorised to use part or whole of the application based on their
authorisation levels. This delineation of user access has to also be
supported by the database, if possible. Also, for audit purposes the
data is append only. And the design is based on just two
tables(vertices and edges) to emulate a document-oriented(jsonb) graph
structure.
Postgres is the database I am leaning towards for this project. But as
I am not a DBA and also a solo developer, I am trying to understand
how I can spend less time managing the DB and more time developing the
application. I would like to have a distributed and fault-tolerant DB
setup with multiple read and write nodes with little to no
configuration on my part, if possible. I am looking for a self-hosted
open source solution.
Is this possible with PG? What is the best way to achieve this for a
non-DBA solo developer like me?
Thanks and kind regards
None of the experts chimed in so I ante up my $0.02.
It won't be possible unless you become a serious DBA _and_ solo (full
stack) developer. Or you pay for db support.
