Linked by MOS6510 on Fri 2nd Aug 2013 18:06 UTC
Databases
Let’s say you’ve decided to set up a website or an application. You'll obviously need something to manage the data. Yes, that's right, a database. So, what is it going to be? MySQL, MS-SQL, Oracle or PostgreSQL? After all, nothing can be as amazing as a good old RDBMS that employs SQL to manage the data.

Well, allow me to introduce to you an entirely unique and unconventional Database model - NoSQL.

Permalink for comment 568737
To read all comments associated with this story, please click here.
Comment by Kroc
by Kroc on Fri 2nd Aug 2013 19:22 UTC
Kroc
Member since:
2005-11-10

Assess the tools available to you and use the right one for the job. If you're comfortable with SQL then that's no excuse to ignore NoSQL methods.

IMO SQL databases are heavily overused on the web. If you don't need to do highly selective data cherry-picking (such as filtering of a result set), or mashing of two sets of data together (analytics), then often a flat data store is simpler, faster and more reliable. For the web, you don't need an SQL database to serve static content, and where you need to index and search content you have offline systems like Syphinx that give you a database for searching but you can keep the fast static caches for the content. (i.e. use flat files for what they're good for and SQL for what it's good for)

Because I didn't like the downsides of SQL databases for web content (portability / maintenance / security / setup&config time) I created a forum system that has no database, just RSS feeds -- each discussion thread is itself an RSS feed. This means that setup is a matter of seconds (unzip and run) and the data is portable, easy to parse, transform, manage, convert and generally process without the need of specialised / my software. Google for NoNonsense Forum should you be interested.Google for NoNonsense Forum should you be interested.

The benefits for my use case made NoSQL the right choice, but I wouldn't think twice about using an SQL database if a project needed those kind of requirements. My point is: learn what's possible with each approach (benefits / drawbacks) and use each to its full potential, and don't be afraid of mixing methods!

Reply Score: 5