/usr/portage

Relational data 0

I concede that the relational model is the worst form of DBMS except for all those other forms that have been tried from time to time.
Bill Karvin – In Support of the Relational Model

I can’t agree more with that statement. Also I find software like CouchDb really interesting, it will not be the way to go. Beneath modeling, the main advantage of relational models is the flexible question startpoint (in terms of SQL it means the basic information you have beforehand to get the rest of what you need). If you know just a little about tree structure, the start point problem will be self-explaining. Accessing an upper node from a sub node just can’t be implemented as fast as accessing a flat structure and there relations.

Filed on 30-11-2007, 07:07 under , , & no comments & no trackbacks

Things I didn’t know 1

That’s something I did not know before: PostgreSQL is extendable via TCL, Perl and Python. The latter is the interesting one. Don’t want to stuck with archaic languages. Extendable means, that it is possible to write SQL-functions in one of this language, which creates the opportunity to put much more logic in the database as it is normally possible.

Update:
Astro pointed to PL/Ruby, which introduces the possibility to create SQL-functions in Ruby.

Filed on 01-04-2006, 03:03 under , , & one comment & no trackbacks