Download

Download:
Cybercluster Source Packages

Cybercluster
Cybercluster 1.0 für Debian Sarge (32 bit / 64 bit)
Cybercluster 1.2 für Debian Etch (32 bit / 64 bit)

Windows Installer — International Installer (32 bit)
Windows Installer — Base Installer (32 bit)

NOTE: The Windows version of Cybercluster is still based on PostgreSQL 8.1. Please don’t use it for production purposes. Also, make sure that all other versions of PostgreSQL are removed from your machine before installing Cybercluster.

Dokumentation:
Cybercluster Dokumentation als PDF

—————————————————————–

Many people from around the globe have been asking for a method to perform recursive queries with PostgreSQL.
Here is an example:

SELECT METIER_ID||'|'||ORGANISATION_ID AS JOBORG
FROM INTRA_METIER,INTRA_ORGANISATION
WHERE METIER_ID IN(
       SELECT METIER_ID
       FROM INTRA_METIER
       START WITH METIER_ID= '99533220-e8b2-4121-998c-808ea8ca2da7'
       CONNECT BY METIER_ID= PRIOR PARENT_METIER_ID
     ) AND ORGANISATION_ID IN (
       SELECT ORGANISATION_ID
       FROM INTRA_ORGANISATION
       START WITH ORGANISATION_ID='025ee58f-35a3-4183-8679-01472838f753'
       CONNECT BY ORGANISATION_ID= PRIOR PARENT_ORGANISATION_ID
    );

CONNECT BY will help you to query trees fast and efficiently.

A PostgreSQL 8.3 RC2 based tarball can be downloaded here: postgresql-8.3RC2_recursive_edition.tar.gz