• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
What DB and Why?

#14
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, 04:29 AM
RE: What DB and Why? - by dmyers - 11-20-2014, 09:17 AM
RE: What DB and Why? - by Rufnex - 11-20-2014, 10:32 AM
RE: What DB and Why? - by alroker - 11-27-2014, 02:37 AM
RE: What DB and Why? - by no1youknowz - 11-30-2014, 08:42 AM
RE: What DB and Why? - by popcorner - 12-04-2014, 08:55 AM
RE: What DB and Why? - by no1 - 12-08-2014, 07:06 AM
RE: What DB and Why? - by Chroma - 12-09-2014, 11:56 AM
RE: What DB and Why? - by SunDi3yansyah - 01-19-2015, 07:10 AM
RE: What DB and Why? - by Hobbes - 01-20-2015, 08:00 AM
RE: What DB and Why? - by sv3tli0 - 01-20-2015, 08:52 AM
RE: What DB and Why? - by kilishan - 01-20-2015, 09:50 PM
RE: What DB and Why? - by Oscar165 - 03-14-2015, 04:21 PM
RE: What DB and Why? - by spjonez - 03-15-2015, 08:29 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.