7 ms·

It's amazing how when you focus on proven (but supposedly boring or old) technology that just works, and works very well, you can devote a lot of other resource

by shingen 15y ago

It's amazing how when you focus on proven (but supposedly boring or old) technology that just works, and works very well, you can devote a lot of other resources to the actual product and usability. Maybe it's the 30 year old in me showing, but I'm sticking with the 'it just works' crowd. Until some other approach provides a staggeringly overwhelming reason to switch. I find scaling up with MySQL to be ridiculously easy, allowing me to focus my time elsewhere. Ram, bandwidth, and fast storage have gotten substantially cheaper in the last few years, making it that much easier and cost effective to throw hardware at scaling up. For 99.9% of the Web, those hardware resources are expanding in value much faster than traffic is increasing. (It's understood other developers find it just as easy to take a different approach)

true_religion 15y ago
Er... you seem to be implying that people are using NoSQL solutions like Redis, Toyko Tyrant, Elastic Search, etc. for fun but that's not the case. Sometimes you just pick the simplest thing that works and that can be a key value store, data structures in memory, or a lucrene interface. It's a better solution and less fragile than trying to force everything into a relational model.
- robinwarren 15y ago
  I must admit that I picked mongodb (+ node) for my latest project for fun. But I then discovered that being able to dump json straight into a datastore without having to create tables etc. first was a great benefit in quickly building something out. So something I did for fun turned out to be the simplest thing which worked. Only I didn't know that when I did it. I think developers who don't occasionally pick something new for fun on a side project are doomed not to know when that new thing could actually be applicable on a project that matters.
  - true_religion 15y ago
    MongoDB isn't the best example to use as a genralization of NoSQL. Many NoSQL databases have a structure you have to conform to---its just not a relational structure.
  - karolist 15y ago
    I'd actually like to do that too but have a hard time wrapping my head around the notion of building a website with node + nosql alone. My understanding is that node is best for realtime chat-like apps.. Is your project web related might I ask?
    - grannyg00se 15y ago
      Node is very handy for high transaction, short transfer, high connection count applications like chat. That's because of the non blocking single thread architecture, low overhead connections, and little bloat (small footprint). However, that doesn't mean it isn't well suited for building a website. You'd probably want to include some add-ons for that though (eg: express). Note that even for realtime chat-like apps you'll probably need some kind of datastore and in fact that example sounds like a great use case for nosql as a datastore.
      - karolist 15y ago
        Thank you for mentioning express, I'm now excited to use it in my next project!
    - robinwarren 15y ago
      Hi, sorry for the slow reply. As mentioned express is a good way to go for getting a website up with node. Since you asked, my project is over here http://jobstractor.com http://jobstractor.com if you want to take a look. My email is on the site so feel free to drop me a line if you have any questions. I'm planning on writing up my experience and a bit about how I've structured things so some questions might help me think through that.
- brazzy 15y ago
  No, I think he's implying that people are using NoSQL solutions because they've been hyped a lot and are fashionable. And that's most certainly the case (certainly not the only reason in all cases, but most certainly a reason in many cases).
luigi 15y ago
It's amazing how when you use recent technology that has been designed and engineered from the ground up for the demands of modern web apps, you can devote a lot of other resources to the actual product and usability.
- route66 15y ago
  Is it possible that a) not all code written is for web apps b) that said recent technology also only fits a niche for modern web apps? I think you view on what constitutes modern web apps or software in general is biased in favor of some examples who benefit by using mongo/couch/redis whatever. (And are very vocal about it) [EDIT: spelling, and to add that I have tremendous joy in playing with couch, redis, node lately. But at the same time I try to stay critical: what are the real trade offs when I employ these tools?]
  - deleted 15y ago
    [deleted]
- geophile 15y ago
  Modern web apps are applications. Applications, over time, run into many problems that SQL database systems were designed to address: * The occasional join. * Complex queries. * Reporting. * Schema changes. * Transactions, with options for trading off strictness and performance. * Performance problems that are easily addressed using stored procedures. * Performance tuning with minimal code changes (e.g. adding an index to change the execution plan of a complex query). * Enforcement of invariants regardless of application code. Why would you give these up for scalability problems you won't have, with 99.999999% probability?
  - gizzlon 15y ago
    "Why would you give these up for scalability problems you won't have, with 99.999999% probability?" I'm not saying people shouldn't use RDBMS', but there are many reasons for using something else: - The new databases/stores have different features and use cases. Many include features RDBMS' do not have. - Having to use table/column's for everything can be quite unnatural and tiresome. - RDBMS' are battle-tested and their pros & cons are well known. But they might also be based on legacy models and truths that simply no longer holds. - At least for me, using & learning something new is a big motivation booster :) Use whatever is right for the job. But one should at least have a general knowledge of whats out there: features, pros & cons etc..

by shingen 15y ago

true_religion 15y ago

Er... you seem to be implying that people are using NoSQL solutions like Redis, Toyko Tyrant, Elastic Search, etc. for fun but that's not the case. Sometimes you just pick the simplest thing that works and that can be a key value store, data structures in memory, or a lucrene interface. It's a better solution and less fragile than trying to force everything into a relational model.

robinwarren 15y ago
I must admit that I picked mongodb (+ node) for my latest project for fun. But I then discovered that being able to dump json straight into a datastore without having to create tables etc. first was a great benefit in quickly building something out. So something I did for fun turned out to be the simplest thing which worked. Only I didn't know that when I did it. I think developers who don't occasionally pick something new for fun on a side project are doomed not to know when that new thing could actually be applicable on a project that matters.
- true_religion 15y ago
  MongoDB isn't the best example to use as a genralization of NoSQL. Many NoSQL databases have a structure you have to conform to---its just not a relational structure.
- karolist 15y ago
  I'd actually like to do that too but have a hard time wrapping my head around the notion of building a website with node + nosql alone. My understanding is that node is best for realtime chat-like apps.. Is your project web related might I ask?
  - grannyg00se 15y ago
    Node is very handy for high transaction, short transfer, high connection count applications like chat. That's because of the non blocking single thread architecture, low overhead connections, and little bloat (small footprint). However, that doesn't mean it isn't well suited for building a website. You'd probably want to include some add-ons for that though (eg: express). Note that even for realtime chat-like apps you'll probably need some kind of datastore and in fact that example sounds like a great use case for nosql as a datastore.
    - karolist 15y ago
      Thank you for mentioning express, I'm now excited to use it in my next project!
  - robinwarren 15y ago
    Hi, sorry for the slow reply. As mentioned express is a good way to go for getting a website up with node. Since you asked, my project is over here http://jobstractor.com http://jobstractor.com if you want to take a look. My email is on the site so feel free to drop me a line if you have any questions. I'm planning on writing up my experience and a bit about how I've structured things so some questions might help me think through that.
brazzy 15y ago
No, I think he's implying that people are using NoSQL solutions because they've been hyped a lot and are fashionable. And that's most certainly the case (certainly not the only reason in all cases, but most certainly a reason in many cases).

luigi 15y ago

It's amazing how when you use recent technology that has been designed and engineered from the ground up for the demands of modern web apps, you can devote a lot of other resources to the actual product and usability.

route66 15y ago
Is it possible that a) not all code written is for web apps b) that said recent technology also only fits a niche for modern web apps? I think you view on what constitutes modern web apps or software in general is biased in favor of some examples who benefit by using mongo/couch/redis whatever. (And are very vocal about it) [EDIT: spelling, and to add that I have tremendous joy in playing with couch, redis, node lately. But at the same time I try to stay critical: what are the real trade offs when I employ these tools?]
- deleted 15y ago
  [deleted]
geophile 15y ago
Modern web apps are applications. Applications, over time, run into many problems that SQL database systems were designed to address: * The occasional join. * Complex queries. * Reporting. * Schema changes. * Transactions, with options for trading off strictness and performance. * Performance problems that are easily addressed using stored procedures. * Performance tuning with minimal code changes (e.g. adding an index to change the execution plan of a complex query). * Enforcement of invariants regardless of application code. Why would you give these up for scalability problems you won't have, with 99.999999% probability?
- gizzlon 15y ago
  "Why would you give these up for scalability problems you won't have, with 99.999999% probability?" I'm not saying people shouldn't use RDBMS', but there are many reasons for using something else: - The new databases/stores have different features and use cases. Many include features RDBMS' do not have. - Having to use table/column's for everything can be quite unnatural and tiresome. - RDBMS' are battle-tested and their pros & cons are well known. But they might also be based on legacy models and truths that simply no longer holds. - At least for me, using & learning something new is a big motivation booster :) Use whatever is right for the job. But one should at least have a general knowledge of whats out there: features, pros & cons etc..