Is this SQL databases or No-SQL?
Is this SQL databases or No-SQL?
Posted Mar 24, 2014 21:48 UTC (Mon) by Wol (subscriber, #4433)In reply to: Is this SQL databases or No-SQL? by farnz
Parent article: A discussion between database and kernel developers
There's various interesting write-ups there, a mess of source code, etc. Unfortunately, it looks to me to have bitrotted a bit - there have been a couple of ports to new systems and also a bunch of external links have rotted - not surprising since the wiki has been around for ages.
A couple of interesting links from the wiki ...
http://www.pickwiki.com/cgi-bin/wiki.pl?KenSimms
http://www.pickwiki.com/cgi-bin/wiki.pl?MultiValuedDatabases
http://www.pickwiki.com/cgi-bin/wiki.pl?PickDataStructure
http://www.pickwiki.com/cgi-bin/wiki.pl?PhilosophyOfPick
http://www.pickwiki.com/cgi-bin/wiki.pl?Getting_Started
http://www.pickwiki.com/cgi-bin/wiki.pl?MVDefinition
Note that one of the reasons I am a Pick fan is that I think that relational theory is broken. Not that the theory is not mathematically correct, but that empirically it doesn't fit the real world. In particular, C&D's first rule *defines* data as coming in rows and columns. Ime, in the real world, this is the exception not the norm, and as a result most databases that use RDBMSs need to use a sledgehammer to force square pegs into round holes :-) Pick just says "what shape is your data? Here, let me store it for you!"
I hope these pages give you a flavour of things. Oh - and why would you come over "like an indian oursourcer"? Come over as yourself, someone who wants to have a play with Pick. The outsourcers usually come over very obviously as individuals who have been plonked in front of a system, have a job to do, and are clueless as to how to do it. If you come over as someone who's playing on their own dime with the system, that's a very different kettle of fish ... (and we're pretty helpful, even to those indian outsourcers - it's not their fault they're sat in front of an unfamiliar system. We do tend to suggest, however, that if they're being paid, they should hire in some paid expertise :-)
Cheers,
Wol
