I'm a long time user of ingres, but my day to day involvement stopped at version 2.6. My biggest concern about the transition to open-source is the ability of people outside of ingres corp to take on the development of the database. If that doesn't happen, I'm not sure what the up-side of moving to open-source will be. However I'm sure that the new company will be much more focussed on development than was CA, and I hope to see some dynamic changes in the ability of ingres to inter-operate with external systems and the OS. A good sign of the vitality of the new Ingres would be an upsurge in the provision of 3rd-party tools, and I hope that Ingres Corp will resurrect the funding drive for open-source add-ins that CA initiated.
Nice to see work going on in the ingres/perl world. I had some basic perl/ingres utilities, still have, although day to day I no longer use ingres.
An auditing sytem to report on changes to daatbase structures/compare database structures, plus some shell scripts to generate table upgrade scripts given an old table definition and new table definition. The scripts rebuilt indexes and restored triggers and views after the change.