LWN.net Logo

Cool new Free software

Cool new Free software

Posted Dec 25, 2012 17:56 UTC (Tue) by Wol (guest, #4433)
In reply to: Cool new Free software by man_ls
Parent article: Status.net service to phase out, replaced by pump.io

Which is why it sounds like Pick is a good fit for people who understand both relational and NoSQL.

Your "contorted language" is spot on. Basically, in relational you cannot STORE that most natural of data concepts, the list. You have to MODEL it. At which point your database becomes unnecessarily complex and complicated.

Referring back to the comment in your earlier post about "You can either read everything from many different "tables" or you can just store every piece of data multiple times. With relational databases you can also denormalize data, but they are usually less flexible as to how it is stored."

But that's exactly what Pick does! NFNF is what relational purists would call "denormalised". The fact that it can be mechanically normalised by the DB seems to have passed them by. So in Pick, I don't "read from many tables OR store the data many times", I just store the data ONCE in ONE table. imho it is *relational* that needs to "store the data many times in many tables" - just try to store a list, then ask yourself how many times you have to store the name of the list (or its id, the same thing...) As a system that requires (as part of its definition) that you don't store duplicate data, the relational system is very poor at living up to its own definition!

Cheers,
Wol


(Log in to post comments)

Cool new Free software

Posted Jan 4, 2013 16:56 UTC (Fri) by nix (subscriber, #2304) [Link]

I might note that you can in fact store lists in PostgreSQL. It's had arrays since before it was called PostgreSQL. :)

Copyright © 2013, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds