PHPPGADMIN TODO LIST FOR DEVELOPERS
-----------------------------------
phpPgAdmin is an open source project which means that if you see something on
this list that you would like to implement, just send us a patch. You can find
our project page here:
http://sourceforge.net/projects/phppgadmin/
An item is marked 'claimed' when a username in brackets is put after the TODO
item.
An item is marked with a '-' if it has been completed.
Users
-----
* 7.3 user variables (eg. ALTER USER SET .. TO ...)
Groups
------
Permissions
-----------
* Grant ... on all tables, views, ... to user, group, public
Databases
---------
* Add alter database for 7.3+
* Comments on databases
* Alter owner
* -Vacuum & analyze (bryan)
Tables
------
* Allow PK and UNIQUE and FKs during create table
* Vacuum & analyze individual tables
* -ORDER BY in Select function (can do so after the fact now - chriskl)
* Add option for showing table size counts
Views
-----
Sequences
---------
Functions
---------
* Syntax highlighting?
Indexes
-------
* Expressional indexes
Types
-----
Operators
---------
* Create
Operator Classes
----------------
* Create
Triggers
--------
Aggregates
----------
* Properties
* Drop
* Create
Languages
---------
* Drop
* Create
Domains (7.3)
-------------
Conversions (7.3)
-----------------
* Properties
* Drop
* Create
Casts (7.3)
-----------
* Properties
* Drop
* Create
Miscellaneous
-------------
* Printable view of things
* Allow simultaneous logins to different clusters
* Show comments for all objects (Dan Boren)
* Allow setting/dropping comments for all objects (Dan Boren)
* Show owner for all objects
* Allow changing owner for objects that have this feature (7.4+ generally)
* Translated FAQ
Exotic
------
* Support contrib/tsearch2 for easy full text indexes
* Pivot reports (ADODB has a feature for this)
* Parameratised reports (use prepared queries)
* Full web accessability conformance
Principles
----------
* register_globals off support
* maximum error_reporting support - enforces code quality, reduces bugs and
improves security
* PHP 4.2 features used
* No HTML font, colour, layout tags. Use CSS for everything
* One day we should make it all XHTML
* everything properly escaped - prevent sql injection and cross-site scripting
probs
* Support Postgres 7.0 and upwards
* psql -E is a cool way of seeing how to do schema queries
* Checking out older versions of describe.c in src/bin/psql in the postgres
distro is a good way of seeing how to query older versions of postgres for
schema information
* Put functions in the highest class possible. For instance, simple selects
should be in Postgres, whereas something that works for 7.1+ should be in the
7.1 class. This will minimise bugs and duplicated code.
* Adhere to current coding standards
* Avoid using global variables if possible
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
