News for hackers. Stuff that matters.
Re:HSBC moves from 65 relational databases into one global M... by murukesh_s on Saturday June 13, 2020 @05:22AM (#23508095)
From the article, it looks like they are replacing separate DBs used for each country.

"Local requirements for each country will be built into the application, but there's no need to maintain separate data models or separate databases anymore. We could easily design the global data model and database using the MongoDB JSON schema model. That brings data from all operating countries into one database and the application can run on just one database. Which is a lot of reduction in resource and maintenance cost. "

Are there any other schema-less databases out there that is better than MongoDB? If not I believe it's time for someone to build it.

Re:HSBC moves from 65 relational databases into one global M... by kogepathic on Saturday June 13, 2020 @05:40AM (#23508208)
> Are there any other schema-less databases out there that is better than MongoDB? If not I believe it's time for someone to build it.

Yes, PostgreSQL supports JSON and won't lose your data: https://www.postgresql.org/docs/current/datatype-json.html

Benchmarks:

* https://portavita.github.io/2018-10-31-blog_A_JSON_use_case_...

* https://www.postgresql.eu/events/fosdem2018/sessions/session...

Re:HSBC moves from 65 relational databases into one global M... by murukesh_s on Saturday June 13, 2020 @06:15AM (#23508373)
From the second link, summary:

Summary - PostgreSQL ● PostgreSQL has poor performance out of the box ○ Requires a decent amount of tuning to get good performance out of it ● Does not scale well with large number of connections ○ pgBouncer is a must ● Combines ACID compliance with schemaless JSON ● Queries not really intuitive

Summary - MongoDB ● MongoDB has decent performance out of the box. ● Unstable throughput and latency ● Scale well with large number of connections ● Strong horizontal scalability ● Throughput bug is annoying ● MongoDB rolling upgrades are ridiculously easy ● Developer friendly - easy to use!

Re:HSBC moves from 65 relational databases into one global M... by riku_iki on Saturday June 13, 2020 @11:39AM (#23510180)
> PostgreSQL has poor performance out of the box

This is actually a valid point. They should start distributing typical configs for typical AWS-alike machines, current default config is for some underpowered machine from 90s..

Re:HSBC moves from 65 relational databases into one global M... by isatty on Saturday June 13, 2020 @07:59AM (#23508806)
> Queries not really intuitive

ISHYGDDT

Re:HSBC moves from 65 relational databases into one global M... by sinni800 on Saturday June 13, 2020 @10:04AM (#23509411)
I would argue that MongoDB queries aren't intuitive but I've known SQL for at least 10 years
Re:HSBC moves from 65 relational databases into one global M... by willcipriano on Saturday June 13, 2020 @11:19AM (#23510029)
For MongoDB in Python I once had to construct a list of two dictionaries containing dictionaries themselves with various two and three character magical key and value names (eg. $gt) in order to query a collection by date. If that's intuitive I'd hate to use something unintuitive.

Oh and MongoDB Compass is a dumpster fire. Query takes too long? Too bad it will time out with no option to let it complete. Also I get to write my query in JSON in compass then I have to convert that to native Python objects if I want to use it from there. With SQL I copy my query from datagrip, inject my parameters and call it a day.

I forgot the best bit, if your query has a subtitle mistake most often you simply get no records back where a similar mistake in SQL throws a helpful exception.

Re:HSBC moves from 65 relational databases into one global M... by john_ghandi on Sunday June 14, 2020 @02:39PM (#23520085)
really? best of luck with that. single node, and no faiures - and it still messed its pants: http://jepsen.io/analyses/postgresql-12.3
Re:HSBC moves from 65 relational databases into one global M... by mathattack on Saturday June 13, 2020 @09:54AM (#23509367)
MSFT is trying with Cosmos.