question = require("comments");
// which one is better ?
DATABASES ? SQL : NoSQL;
exit;

SQL is relational data
NoSQL is generally blobs of data.

Both are useful depending on the data you are storing and how you plan to use it.

@C0D4 so lets suppose i'm migrating from sql to nosql. what is the replacement of sql table relations in a nosql database

@moolsbytheway depends on what you are doing. Like rather than relating two tables via a foreign key, you make relationships hierarchical.

So if you have a model say user that can have posts.

Then you would nest the posts in the user schema as oppose to assigning a user_id to them.

NoSQL, way cleaner.

@moolsbytheway don't. Use nosql when using relational is not needed. They both have use cases.

@asosnovsky ok lets say. i have a field location cant i just give the location_id and then access the location data from Location document ?

@iam13islucky "nosql is way faster and scalable", they say.

@moolsbytheway meh. Good indexes, caching, and generally paying attention to what is slowing it down works wonders. "Scalable" is a buzzword to kill all buzzwords.

Also, mongoDB's own website says it isn't for everything. Sometimes a mix of the two is best.

@moolsbytheway depending on the implementation of the db (nosql does not just mean document databases like mongodb). Generally thats not how document databases work.

mongodb ? i'm trying it with node js.

@wolt of course. and masssssive web apps tunning with php. but i'm trying the javascript way of doing that. us there sql for Node ?