Re:Ask HN: What database should I use, and how should I choose?
by kluck on Friday July 10, 2015 @03:24AM
(#9862698)
> I have experience with Mongodb (although possible loss of data is alarming) and a lot of experience with MySQL/Postgres.
Use PostgreSQL then, because experience is key. Also: more time to work on the hard stuff.
> I would like to support real time interactions
What do you mean by that?
> I would like it to be easily scalable and maintainable (possibly hosted/maintained by a third party) as I am working solo
Nothing is easy to scale (across a network) if you do not want to lose data safety. So either pay someone to maintain such a beast (costly) or maintain it yourself (time-consuming, error-prone unless you are experienced).
I know there are ways to scale across a network using PostgreSQL but I suggest thinking about the scaling problem when it actually occurs. Or has it already?
Use PostgreSQL then, because experience is key. Also: more time to work on the hard stuff.
> I would like to support real time interactions
What do you mean by that?
> I would like it to be easily scalable and maintainable (possibly hosted/maintained by a third party) as I am working solo
Nothing is easy to scale (across a network) if you do not want to lose data safety. So either pay someone to maintain such a beast (costly) or maintain it yourself (time-consuming, error-prone unless you are experienced).
I know there are ways to scale across a network using PostgreSQL but I suggest thinking about the scaling problem when it actually occurs. Or has it already?