3 mar. 2012

From an article about NoSQL:

First, we should note that SQL and relational model in general were designed long time ago to interact with the end user. This user-oriented nature had vast implications: […] No one can expect human users to explicitly control concurrency, integrity, consistency, or data types validity. That’s why SQL pays a lot of attention to transactional guaranties, schemas, and referential integrity.

I had always wondered about that, and it never occurred to me that SQL could have been designed primarily for end users. So it does make sense that, when accessing my database from PHP, I feel no need to use stuff like foreign keys constraints in the schema itself, for instance.

(Can’t vouch for the rest of the article, still haven’t read it. It’s long, and I have to be in a more open and productive state of mind to appreciate what it’s offering.)

 

Archives

2001   01   02   03   04   05   06   07   08   09   10   11   12  

2002   01   02   03   04   05   06   07   08   09   10   11   12  

2003   01   02   03   04   05   06   07   08   09   10   11   12  

2004   01   02   03   04   05   06   07   08   09   10   11   12  

2005   01   02   03   04   05   06   07   08   09   10   11   12  

2006   01   02   03   04   05   06   07   08   09   10   11   12  

2007   01   02   03   04   05   06   07   08   09   10   11   12  

2008   01   02   03   04   05   06   07   08   09   10   11   12  

2009   01   02   03   04   05   06   07   08   09   10   11   12  

2010   01   02   03   04   05   06   07   08   09   10   11   12  

2011   01   02   03   04   05   06   07   08   09   10   11   12  

2012   01   02   03   04   05   06   07   08   09   10   11   12  

2013   01   02   03   04   05   06   07   08   09   10   11   12  

2014   01   02   03   04   05   06   07   08   09   10   11   12