vote

Hierarchical database structures and Firebird PSQL

The Programming Works – The idea of storing a hierarchical data in a relational database is very simple, but effective work with such a data requires some knowledge of server-side programming using procedural SQL (PSQL). So the hierarchical data structures are a good chance to get acquainted with PSQL. For demonstration purposes I created a simple database with single table TCLASS containing Delphi class hierarchy. Here is a SQL script that creates an empty database (I used Firebird version 2.1.4 and Firebird ISQL Tool to execute SQL scripts and single SQL statements): SET SQL DIALECT 3; SET NAMES WIN1251; CREATE ...

Favorite? Off-Topic? Serg @ 2011-12-09 13:34