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