News for hackers. Stuff that matters.
Re:HSBC moves from 65 relational databases into one global M... by sohamsankaran on Saturday June 13, 2020 @05:15AM (#23508052)
What's wild about this is that Mongo isn't even in fashion anymore! NoSQL has been supplanted by NewSQL, and relational dbs are in season again. Even if they were trying to follow the trend, they'd be a half-decade behind.
Re:HSBC moves from 65 relational databases into one global M... by pydry on Saturday June 13, 2020 @06:45AM (#23508517)
I work at another big corp in London and mongo has been doing a major sales push on us in the last 18 months (which wasn't pleasant to push back on).

I'm fairly sure that this was driven by a similar sales push.

Mongo has always been a sales and marketing company first and technology company second.

I'd love to see a tear down of their sales and marketing strategy coz its clearly top notch.

Re:HSBC moves from 65 relational databases into one global M... by mathattack on Saturday June 13, 2020 @09:54AM (#23509364)
The strategy is called “Lie, Overwhelm, and Raise Rates on Renewal”
Re:HSBC moves from 65 relational databases into one global M... by rgoulter on Saturday June 13, 2020 @07:36AM (#23508720)
I've never heard the term "NewSQL" before.

Google Trends comparing "NewSQL" with "NoSQL" https://trends.google.com/trends/explore?date=all&geo=US&q=N... (Peaking with its introduction in 2011).

It doesn't seem like a more fashionable term than NoSQL.

Re:HSBC moves from 65 relational databases into one global M... by catmanjan on Saturday June 13, 2020 @05:33AM (#23508161)
Interesting, what is considered newsql? Postgres?
Re:HSBC moves from 65 relational databases into one global M... by sohamsankaran on Saturday June 13, 2020 @05:44AM (#23508227)
I am not a fan of this buzzword (and indeed buzzwords in general, the comment above was intending to make fun of HSBC IT for even failing at the buzzword game), but the notion of NewSQL was roughly to keep the relational model and consistency guarantees of traditional SQL databases, but also have horizontal scalability in line with NoSQL databases. DBs like VoltDB and Spanner come to mind as examples -- here are two relevant blog posts from those teams:

VoltDB: https://www.voltdb.com/blog/2016/09/nosql-vs-newsql-whats-di...

Spanner: https://cloud.google.com/blog/products/gcp/from-nosql-to-new...

Re:HSBC moves from 65 relational databases into one global M... by AsyncAwait on Saturday June 13, 2020 @06:16AM (#23508379)
No."Horizontally-scalable" SQL like CockroachDB, TiDB, Google's Spanner or YugabyteDB are examples of NewSQL, Postgres would be "OldSQL" if you will.
Re:HSBC moves from 65 relational databases into one global M... by jtms on Saturday June 13, 2020 @09:24AM (#23509192)
PostgreSQL still the best sql though :-)
Re:HSBC moves from 65 relational databases into one global M... by bob1029 on Saturday June 13, 2020 @05:40AM (#23508201)
SQLite is the hottest new thing on the block.
Re:HSBC moves from 65 relational databases into one global M... by mkl on Saturday June 13, 2020 @05:43AM (#23508221)
Huh? SQLite is nearly 20 years old, and is only intended for small scale use.
Re:HSBC moves from 65 relational databases into one global M... by bob1029 on Saturday June 13, 2020 @06:06AM (#23508335)
It was intended as a joke in context, but I believe SQLite is far more capable than most will give it credit for. This is especially true for applications which you only ever intend to run on a single logical machine. But, even for those applications requiring multiple nodes, it can still be a powerful tool if you assume clustering & replication duty in your application logic.

For any use case, SQLite is one of the best ways to persist structured data to local disk.

Re:HSBC moves from 65 relational databases into one global M... by waheoo on Saturday June 13, 2020 @08:06AM (#23508831)
I try to use sqlite for all projects until i cant.

Its a little scary how much it can actually handle, and how lazy and sub optimal it is to reach for a "real" sql server before you need it.

Having the database as a simple file right next to yoyr application is incredibly convenient not to mention how brain dead things like backups are to grok.

Re:HSBC moves from 65 relational databases into one global M... by sohamsankaran on Saturday June 13, 2020 @06:29AM (#23508445)
SQLite is incredible, especially for embedded applications. It's one of those perfectly-scoped tiny pieces of software that consistently makes my heart sing.
Re:HSBC moves from 65 relational databases into one global M... by mkl on Saturday June 13, 2020 @06:13AM (#23508364)
Oh, I agree about its utility, and use it myself. It seems like a different category of tool than the other DBs under discussion, though.
Re:HSBC moves from 65 relational databases into one global M... by geoah on Saturday June 13, 2020 @06:01AM (#23508308)
Tidb, cockroachdb maybe?