When you have highly structured data with high levels of interdependence, such as lots of numbers that all depend upon one another - i.e bank accounts - you use SQL.
When you have fairly unstructured, loose data that is fairly independent, such as content - i.e you are building a blog or another Pintrest - use NoSQL. Its all about the data. Don't be afraid to use both, however. It doesn't sound like your application has much use for NoSQL, but if you have a blog section or something of that nature, consider it. NoSQL really shines in conditions where you have changing content needs. On Thu, Jul 12, 2012 at 6:30 PM, Dave Clements <[email protected]>wrote: > When it comes to finance, SQL comes out on top - things like MySQL have > been battle tested for decades, accounts information is intrinsicly > relational so relational databases are the right fit, ACID compliance with > nosql is more liberal but with your project you'd need 100% reliability. > > Also theres transactions and atomic operations, which strictly couple two > entries to ensure that if you debit one place, you credit another place. > NoSQL doesn't have the same level of capabilities. > > If you'd asked for something super fast, pleasant and exciting to use, its > nosql all the way. But for finance, SQL. > > -- > Job Board: http://jobs.nodejs.org/ > Posting guidelines: > https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines > You received this message because you are subscribed to the Google > Groups "nodejs" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/nodejs?hl=en?hl=en > -- Job Board: http://jobs.nodejs.org/ Posting guidelines: https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines You received this message because you are subscribed to the Google Groups "nodejs" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nodejs?hl=en?hl=en
