This folder has no visible items. To add content, press the 'Add New Item' button, or paste content from another location.
ZDatabaseTool takes advantage of the amazing features of Zope. It extends it's built-in objects so you can manage databases more comfortable. At the moment only PostgreSQL RDBMS is supported. The code is not yet released I want you to have a look at it. Database administration show database connection settings show available databases show database owners show database users show database diagram show tables with it's owner, indexes, rules, triggers and constraints show fields with it's type, lenght, modifier and references show database views with it's owner and definition do test queries (no SQL skills needed) Database Query Wizard create komplex database queries (no SQL skills needed) object methods for query input forms, query results (HTML and PDF), single records, insert update and delete records multi language support much more ... see screen shots and online demo Requirements Zope 2.1.6+ ZPyGreSQLDA or ZPoPyDA PostgreSQL 7+ ReportLab suggested for PDF database reports Python Imaging Library (PIL) suggested for full PDF imaging functionality Browser (NS,IE JavaScript enabled)
ZDatabaseTool takes advantage of the amazing features of Zope. It extends it's built-in objects so you can manage databases more comfortable. At the moment only PostgreSQL RDBMS is supported. The code is not yet released I want you to have a look at it.
Two new Zope objects are provided.
ZDatabaseDiagram shows the structure and relations between tables of your database based on referential integrity definitions. So you get a quick view over tables views and column definitions.
A ZDatabaseExplore shows all entities of your database.
Features:
The Query Wizards you can see at the online demo are NOT included but it is on the TODO list for this week :-)