5 ms·

> There is absolutely NO reason whatsoever to use a NoSQL database for a financial services company Yes there is. PostgreSQL doesn't support multi master repli

> There is absolutely NO reason whatsoever to use a NoSQL database for a financial services company Yes there is. PostgreSQL doesn't support multi master replication which makes it a terrible choice if you really want to make sure every transaction gets written. I really wonder at what point people that keep recommending PostgreSQL are going to wake up and realise what is happening in the industry. People are scaling OUT not UP. Especially startups.

nirvdrum 14y ago
In all fairness, you could use something other than Postgres that's also ACID.
shawn-butler 14y ago
I'm sorry, postgres-xc doesn't work for you needs? [0] It has worked for me in the past. [0] http://postgres-xc.sourceforge.net/ http://postgres-xc.sourceforge.net/
knightni 14y ago
I would imagine that for your average startup, using solutions that don't even support transactionality will cause greater complexity issues. Especially given the enormous window before db scale out/up becomes an issue on well-designed applications.
- taligent 14y ago
  Enormous window ? Many startups would be using AWS and it is not inconceivable that you would have Multi-AZ/Multi-Region VPSs. Scaling out != Expensive.
j-kidd 14y ago
> People are scaling OUT not UP. Especially startups. Startups need to scale out because many of them like to deploy on mediocre EC2 instances with the slowest SAN storage ever. People that keep recommending PostgreSQL are rightfully ignoring this industry.
- taligent 14y ago
  > Startups need to scale out because many of them like to deploy on mediocre EC2 instances. No. They need to scale out because providers like AWS have outages. And so startups et al need to deploy in multiple AZ/regions in order to have as close to 100% uptime as possible. You can't do that with a well considered multi master style replication strategy which PostgreSQL frankly doesn't have. >People that keep recommending PostgreSQL are rightfully ignoring this industry. Sure. And soon enough they will be relegated to the dustbins of history. The trends don't lie.
  - gbog 14y ago
    "The trends don't lie" Wah. And you do not even seem to be ironic. Trends always lie, there is always a next thing that will take the opposite direction, in philosophy, in science, and particularly so in computing stuff.

nirvdrum 14y ago

In all fairness, you could use something other than Postgres that's also ACID.

shawn-butler 14y ago

I'm sorry, postgres-xc doesn't work for you needs? [0] It has worked for me in the past. [0] http://postgres-xc.sourceforge.net/ http://postgres-xc.sourceforge.net/

knightni 14y ago

I would imagine that for your average startup, using solutions that don't even support transactionality will cause greater complexity issues. Especially given the enormous window before db scale out/up becomes an issue on well-designed applications.

taligent 14y ago
Enormous window ? Many startups would be using AWS and it is not inconceivable that you would have Multi-AZ/Multi-Region VPSs. Scaling out != Expensive.

j-kidd 14y ago

> People are scaling OUT not UP. Especially startups. Startups need to scale out because many of them like to deploy on mediocre EC2 instances with the slowest SAN storage ever. People that keep recommending PostgreSQL are rightfully ignoring this industry.

taligent 14y ago
> Startups need to scale out because many of them like to deploy on mediocre EC2 instances. No. They need to scale out because providers like AWS have outages. And so startups et al need to deploy in multiple AZ/regions in order to have as close to 100% uptime as possible. You can't do that with a well considered multi master style replication strategy which PostgreSQL frankly doesn't have. >People that keep recommending PostgreSQL are rightfully ignoring this industry. Sure. And soon enough they will be relegated to the dustbins of history. The trends don't lie.
- gbog 14y ago
  "The trends don't lie" Wah. And you do not even seem to be ironic. Trends always lie, there is always a next thing that will take the opposite direction, in philosophy, in science, and particularly so in computing stuff.