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?
[ Parent
| on HN ]
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.