Tuesday, August 19, 2014

Math and SQL Part 5: Projection and Selection

›
The SELECT statement is the workhorse of SQL.  Updates and inserts are necessary, but selects are where the power is.  One of the significan...
Thursday, August 14, 2014

Math and SQL part 4: Basic Data Types. Sets, Tuples, and Bags

›
A reasonable understanding of the relational model requires understanding the basic data types which make it up, both in the idealized model...
2 comments:
Monday, August 11, 2014

Math and SQL part 3: MVCC, Immutability, and Functional Programming

›
While first normal form is pretty much restricted to relational operations, this piece is more general.  It looks at the basic promise of fu...
2 comments:
Wednesday, August 6, 2014

Math and SQL, part 2: Functions and First Normal Form

›
There is probably no piece of relational database theory which is so poorly understood in professional literature than first normal form.  T...
13 comments:
Saturday, August 2, 2014

Math and SQL, part 1: Introduction: Relations and Functions

›
There are two goals I have in this series.  The first is to heavily ground database thinking in mathematics thinking.  The second is to conn...
1 comment:
Thursday, March 6, 2014

In Defence of Microsoft

›
Ok, so the next post was going to be on why PostgreSQL is really great.  But this is going to be a different and unusual post for this blog....
2 comments:
Thursday, February 27, 2014

In Praise of Perl 5

›
I have decided to do a two-part series here praising Perl in part 1 and PostgreSQL in part 2.  I expect that PostgreSQL folks will get a l...
4 comments: