Welcome Guest, Not a member yet? Register   Sign In
What DB and Why?
#14

(This post was last modified: 03-15-2015, 07:47 AM by spjonez.)

Heavy relational data, full text searching: My/MSSQL
Frequent read, infrequent writes: noSQL (CouchDB)

PouchDB is going to change the face of web development forever. Offline apps cannot be done any other way and since My/MSSQL offer no form of native conflict resolution I don't see this changing in the near future.

Really what it comes down to is your data requirements. If you have a lot of relationships, need painless full text searching, or frequently write changes My/MSSQL are always going to be favoured. If you have frequent reads and infrequent writes (Twitter, FB, etc) Node/noSQL will destroy traditional systems in terms of performance by a very wide margin.

Node/IO.js uses OS threads to manage requests all of which are non-blocking. You can easily handle ten's of thousands of concurrent requests on a simple box as each request uses KB of RAM. Compare that with Apache/IIS which allocate several MB per request and you'll quickly see why a lot of dev's are using it for certain types of apps.

During the last World Cup Twitter set a new record of 618,725 tweets per minute. I'd love to see Apache + My/MSSQL handle that!

Learn both. Each has their use case and frameworks like Ember/Angular are here to stay.
Reply


Messages In This Thread
What DB and Why? - by haneez - 11-20-2014, 03:29 AM
RE: What DB and Why? - by dmyers - 11-20-2014, 08:17 AM
RE: What DB and Why? - by Rufnex - 11-20-2014, 09:32 AM
RE: What DB and Why? - by alroker - 11-27-2014, 01:37 AM
RE: What DB and Why? - by no1youknowz - 11-30-2014, 07:42 AM
RE: What DB and Why? - by popcorner - 12-04-2014, 07:55 AM
RE: What DB and Why? - by no1 - 12-08-2014, 06:06 AM
RE: What DB and Why? - by Chroma - 12-09-2014, 10:56 AM
RE: What DB and Why? - by SunDi3yansyah - 01-19-2015, 06:10 AM
RE: What DB and Why? - by Hobbes - 01-20-2015, 07:00 AM
RE: What DB and Why? - by sv3tli0 - 01-20-2015, 07:52 AM
RE: What DB and Why? - by kilishan - 01-20-2015, 08:50 PM
RE: What DB and Why? - by Oscar165 - 03-14-2015, 03:21 PM
RE: What DB and Why? - by spjonez - 03-15-2015, 07:29 AM



Theme © iAndrew 2016 - Forum software by © MyBB