sql - DynamoDB for bank transactions -


i thinking simulate bank account transaction in dynamodb being nosql type database, use case suited dynamodb? or should stick sql based database?

does know how banks handles this? use dynamodb or keep our transaction in separate table?

a sql based system allows transactions across multiple tables, while dynamodb allows transactions @ individual item. however, there dynamodb transaction library java allows atomic transactions across multiple items @ expense of speed , substantially more writes per request.

dynamodb support atomic counters, bank-account-like (the example on documentation page along line).

dynamodb provides conditional writes can avoid type of race conditions when item attempted updated concurrently.

could build suitable system on top of dynamodb? maybe, depends on specific requirements , how go implementing such system. said, dynamodb provide functionality outlined above address types of concerns arise when building such system.


Comments

Popular posts from this blog

python - pip install -U PySide error -

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -