Be the first to post a text review of zURLManager. Rate and review a project by clicking thumbs up or thumbs down in the right column.

• File released: /zurlman/CollectionDB-0.41/collectionDB-0.4.1.tar.gz

  posted 2858 days ago

• zurlman CollectionDB-0.41 file released: collectionDB-0.4.1.tar.gz

  12.01.2002 Fixed nasty progressive slowness bug in collectionDB/Pg Added object caching (twice the speed for cached objects) Better POD for collectionDB::Pg::collectionDB 06.01.2002 Fixed two nasty bugs in collectionDB/Pg 04.01.2002 Added POD documentation to the collectionDB/Pg modules. 16.12.2001 Still moving to PG All tests that worked with MySQL work. But still testing needs to be done. Finished and tested add_object() function in Pg/funccreate.pgsql Finished and tested add_object function in Pg/dblink.pm Finished and tested delete_object() function in Pg/funccreate.pgsql Finished and tested delete_object function in Pg/dblink.pm Finished and tested query_objects() function in Pg/funccreate.pgsql Finished and tested query function in Pg/dblink.pm Finished and tested get_object_by_id_multiple in Pg/dblink.pm Finished and tested get_object_by_id in Pg/dblink.pm Finished and tested commitchanges in Pg/dblink.pm Finished check_object_update (Pg/dblink.pm) Modified loadedobjects table to contain lastModified column (dbcreate.pgsql). Modified load_object to load lastModified column (funccreate.pgsql) Ran modobj.t for PgSQL and it works fine. 15.12.2001 Still moving to PG Finished query_objects function in funccreate.pgsql. Now need to update perl code to work with the Postgres db. 12.12.2001 Still moving to PG. Added loadedobjects table and load_object function to load an object. There are additional workarounds and ugly/errorprone code due to lacking support of arrays in pl/pgsql assignments (basically arrays are treated as if they were not a native type in pl/pgsql. I could not directly assign to arr[1] and had to construct the whole array as a string and later convert to an array - I am not too proud of the resulting code) 11.12.2001 Still moving to PG. Split dbcreate.pgsql into dbcreate.pgsql and funccreate.pgsql. Finished update_object and add_class_loose in funccreate.pgsql. Moved some functionality out of create_object to be used by both create_object and update_object. Added documentation to functions. 06.12.2001 Moving to PG. First steps of moving to PostgreSQL. Created add_class, query_class and add_object stored procs. Also there but unfinished are update_object and add_class_loose.

  posted 2858 days ago

• File released: /zurlman/zurlback-0.4/zurlback-0.44.tar.gz

  posted 2864 days ago

• File released: /zurlman/CollectionDB-0.41/collectionDB-0.39.tar.gz

  posted 2864 days ago

• zurlman CollectionDB-0.41 file released: collectionDB-0.39.tar.gz

  12.01.2002 Fixed nasty progressive slowness bug in collectionDB/Pg Added object caching (twice the speed for cached objects) Better POD for collectionDB::Pg::collectionDB 06.01.2002 Fixed two nasty bugs in collectionDB/Pg 04.01.2002 Added POD documentation to the collectionDB/Pg modules. 16.12.2001 Still moving to PG All tests that worked with MySQL work. But still testing needs to be done. Finished and tested add_object() function in Pg/funccreate.pgsql Finished and tested add_object function in Pg/dblink.pm Finished and tested delete_object() function in Pg/funccreate.pgsql Finished and tested delete_object function in Pg/dblink.pm Finished and tested query_objects() function in Pg/funccreate.pgsql Finished and tested query function in Pg/dblink.pm Finished and tested get_object_by_id_multiple in Pg/dblink.pm Finished and tested get_object_by_id in Pg/dblink.pm Finished and tested commitchanges in Pg/dblink.pm Finished check_object_update (Pg/dblink.pm) Modified loadedobjects table to contain lastModified column (dbcreate.pgsql). Modified load_object to load lastModified column (funccreate.pgsql) Ran modobj.t for PgSQL and it works fine. 15.12.2001 Still moving to PG Finished query_objects function in funccreate.pgsql. Now need to update perl code to work with the Postgres db. 12.12.2001 Still moving to PG. Added loadedobjects table and load_object function to load an object. There are additional workarounds and ugly/errorprone code due to lacking support of arrays in pl/pgsql assignments (basically arrays are treated as if they were not a native type in pl/pgsql. I could not directly assign to arr[1] and had to construct the whole array as a string and later convert to an array - I am not too proud of the resulting code) 11.12.2001 Still moving to PG. Split dbcreate.pgsql into dbcreate.pgsql and funccreate.pgsql. Finished update_object and add_class_loose in funccreate.pgsql. Moved some functionality out of create_object to be used by both create_object and update_object. Added documentation to functions. 06.12.2001 Moving to PG. First steps of moving to PostgreSQL. Created add_class, query_class and add_object stored procs. Also there but unfinished are update_object and add_class_loose.

  posted 2864 days ago

• zurlman zurlback-0.4 file released: zurlback-0.44.tar.gz

  This is the first release with Postgres. Hurray! If you are looking for the mysql version, use zurlback-2.0. This verions is probably much more robust now since everything is calling stored procedures which are transactions-enclosed. Still would be so much cooler if Pg.7.1.3 had rowset returning from stored procs.. The multiple object loading is still slower than mysql. Do not know how to fix this. PostgreSQL gurus, anyone? Update: after caching was implemented, the speed is the same as mySQL without caching.

  posted 2864 days ago

• PostgreSQL optimization tips needed

  If anyone has any tips on whether it is worth moving PL/PgSQL code to native C code, please write to botik32@yahoo.com. Also, I need pointers to general scalability tips for a backend... The PL/PgSQL code I am pondering is used to build objects from different field tables, and it is slow when asked to return many objects. One solution to that is to create a temporary table to cache returned objects, are there any other techniques? Would rewriting the whole thing to native C using libpq provide a speed tradeoff? Much thanks.

  posted by botik32 2877 days ago

• File released: /zurlman/CollectionDB-0.41/collectionDB-0.37.tar.gz

  posted 2881 days ago

• zurlman CollectionDB-0.41 file released: collectionDB-0.37.tar.gz

  12.01.2002 Fixed nasty progressive slowness bug in collectionDB/Pg Added object caching (twice the speed for cached objects) Better POD for collectionDB::Pg::collectionDB 06.01.2002 Fixed two nasty bugs in collectionDB/Pg 04.01.2002 Added POD documentation to the collectionDB/Pg modules. 16.12.2001 Still moving to PG All tests that worked with MySQL work. But still testing needs to be done. Finished and tested add_object() function in Pg/funccreate.pgsql Finished and tested add_object function in Pg/dblink.pm Finished and tested delete_object() function in Pg/funccreate.pgsql Finished and tested delete_object function in Pg/dblink.pm Finished and tested query_objects() function in Pg/funccreate.pgsql Finished and tested query function in Pg/dblink.pm Finished and tested get_object_by_id_multiple in Pg/dblink.pm Finished and tested get_object_by_id in Pg/dblink.pm Finished and tested commitchanges in Pg/dblink.pm Finished check_object_update (Pg/dblink.pm) Modified loadedobjects table to contain lastModified column (dbcreate.pgsql). Modified load_object to load lastModified column (funccreate.pgsql) Ran modobj.t for PgSQL and it works fine. 15.12.2001 Still moving to PG Finished query_objects function in funccreate.pgsql. Now need to update perl code to work with the Postgres db. 12.12.2001 Still moving to PG. Added loadedobjects table and load_object function to load an object. There are additional workarounds and ugly/errorprone code due to lacking support of arrays in pl/pgsql assignments (basically arrays are treated as if they were not a native type in pl/pgsql. I could not directly assign to arr[1] and had to construct the whole array as a string and later convert to an array - I am not too proud of the resulting code) 11.12.2001 Still moving to PG. Split dbcreate.pgsql into dbcreate.pgsql and funccreate.pgsql. Finished update_object and add_class_loose in funccreate.pgsql. Moved some functionality out of create_object to be used by both create_object and update_object. Added documentation to functions. 06.12.2001 Moving to PG. First steps of moving to PostgreSQL. Created add_class, query_class and add_object stored procs. Also there but unfinished are update_object and add_class_loose.

  posted 2881 days ago

• File released: /zurlman/zurlback-0.4/zurlback-0.41.tar.gz

  posted 2883 days ago