Re:HSBC moves from 65 relational databases into one global M...
by mushi on Saturday June 13, 2020 @11:55AM
(#23510301)
> what is your user id
I don’t think you actually tried it. It returns user who’s id is “{$ne: null}” (string)
Re:HSBC moves from 65 relational databases into one global M...
by 29athrowaway on Saturday June 13, 2020 @03:59PM
(#23512213)
It depends. Sometimes you can trick an application to parse that as an object.
1) mongoDB does not offer the guarantees required by a bank.
2) Application developers using mongoDB rarely protect themselves against NoSQL injections. Most of them are unsuspecting that they even exist.
e.g.: What is your user id? {$ne: null}... whoops, now every user record is returned.
3) They better make sure they use the Decimal128 type for their currency fields, and make sure that the value is not being casted to float on the client. e.g.: on a JS client, every number is a float.
Unless they've taken the necessary precautions this is a disaster waiting to happen. Hopefully other banks do not do the same.