Boston Linux & UNIX was originally founded in 1994 as part of The Boston Computer Society. We meet on the third Wednesday of each month at the Massachusetts Institute of Technology, in Building E51.

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Discuss] No-SQL Database Recommendation?



On 1/10/2015 9:49 PM, markw at mohawksoft.com wrote:
> This is so uninformed.  There is *no* difference between a table with
> key/value in a sql database and a no-sql database. Almost every SQL
> database out there has, and has had for several years, JSON, XML, and
> other compound data types.

Which are really just arbitrary data stored in table cells. That's not 
the same thing as complex matrices. These kinds of data don't fit well 
into relational databases. You can make them fit but then you're making 
them fit which indicates that a relational database is the wrong tool.


> Ahh "scale." What can you say about scale? Almost all people get it wrong
> if they have never done it, and if they have done it they know that any
> arbitrary technology is only a tool to build something that gets it right.

Yep. And just so that this isn't a rag on relational databases, ALL 
databases have a point beyond which performance plummets. Where these 
points are for different technologies for given hardware and how the 
system performs under these conditions are factors that should be 
considered before choosing any technology.

-- 
Rich P.



BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org