4 ms·
What's the best current alternative database for storing financial transactions? Just use a SQL over a NoSQL?
by aero- 8y ago
What's the best current alternative database for storing financial transactions? Just use a SQL over a NoSQL?
- m0j0e 8y agoProbably OneTick.
- simonebrunozzi 8y agoPostgreSQL all the way down. I know I'm in the minority here.
- lawn 8y agoI doubt you're the minority TBH.
- manigandham 8y agoNoSQL is a meaningless term, and SQL is a query language. The actual database types are relational, key-value/wide-column, document store, graph, search, OLAP/column-oriented, etc. Any of them will work as long as you can durably store your data. Relational databases have always implemented ACID and SQL which makes them easy to work with, and they can support almost any data model with decades of updates and tooling which is why they are the default choice unless you specifically have other needs. Newer relational databases can also scale horizontally by applying the same sharding techniques as the other database types, so even that issue is no longer relevant.