We are happy to announce the release of the Database Manager.
Authors: Michael Rieker, Nima Mazloumi
General
This package is a port of PhPMyAdmin, PhPPgAdmin and PgAdmin to
OpenACS. Currently only PostgreSQL is supported. All PostgreSQL specific stuff
has been sourced out though we have to say that still the code right now only
will work for PostgreSQL as we use PostgreSQL API. There is some work in the
community going on to write an db abstractional layer that might be used in
future to support several other database management systems.
Installation
The package is fully internationalized and will be auto-mounted under
/dbm.
Restrictions
Please note that due to the AOLServer only the main database pool can be
accessed currently. You are able to create or remove other databases depending
on the permissions the user has under which the AOLServer is running but only
the main database is accessible right now.
Warning
Please note that only site-wide admins are permitted to
access it since
THIS PACKAGE CAN SEVERELY HARM YOUR
OPENACS INSTALLATION. Be therefore warned and do not use it on a production
sytems and also if you don't know what you are doing.
Features
- coverage of the most relevant features like management of tables, views,
functions, sequences, domains, databases, schemas, variables, privileges, db
management features, import and exports
- full i18n
- full list builder support (sorting, pagination)
- full form builder support
- graphical representation - If you have GraphViz installed. Set the correct path to a GraphViz command
like dot in the parameters. This will enable you to get a graphical
representation of the relationships between the tables and even allows you to navigate.
- Also along with this package comes two new templates for form and list
builder. Due to restrictions in acs-templating the templates are copied to
acs-templating when the package is installed and removed later on. While the
forms template is a full rewrite to support
div-Tags (XHTML,CSS2)
and allows the vertical and horizontal positioning of form elements within a
given section (new form builder attributes) the lists template basically
provides support for vertical table headers (only for IE).
Future Work
Future work will
- provide more import and export formats and
- allow the management of all databases and not only the main pool defined in the
AOLServer configuration file
- provide a SQL Shell
License
This work is published under the
GPL.
Copyright (C) 2006 Michael Rieker, Nima Mazloumi
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a link to the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301
USA
