✏️ 编辑：TODO
路径：
/virtual/bigbrother/public_html/log/phppgadmin/TODO
大小：5.28 KB · 修改：2007-01-20 18:06:06 · 权限：0705 · 可写
← 返回目录
👁 查看
⬇ 下载
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. Cluster ------- * Allow reading of postgresql.conf and pg_hba.conf per pg_read_file() in 8.1 * Support pg_reload_conf(), pg_rotate_logfile() 8.1 commands Export ------ * Switch to SPARQL format: http://www.w3.org/TR/2005/WD-rdf-sparql-XMLres-20050801/ Actually...SQL/XML is maybe better. Misc ---- * Support 8.1 standard compliant strings (E'') Users ----- * 7.3 user variables (eg. ALTER USER SET .. TO ...) Groups ------ Roles ----- * -Support for 8.1 roles (removing users and groups) (chriskl,javier) * Support for ALTER ROLE Permissions ----------- * Grant ... on all tables, views, ... to user, group, public * Grant connect on database [8.2] Databases --------- * Add alter database variables for 7.3+ * -Comments on Create and Alter database [8.2] Schemas (7.3) ------------- * -Rename (xzilla) * Alter owner * Alter ... SET SCHEMA support per 8.1 Large Objects ------------- * Add support for large objects Tables ------ * Allow PK and UNIQUE and FKs during create table (Jawed) * Vacuum & analyze individual tables * When adding a column or creating a table, prevent size on non-size types (eg. integer(2)). You can find these by looking at format_type in the postgresql source code. * When browsing a table, clicking on a FK value should jump to the PK row. * When editing a table, turn FK columns into drop-downs based on estimated rows in the foreign table? (Jawed) * -Auto-select 'WITHOUT OIDS' if 'default_with_oids' setting is false (Guillaume LELARGE) * Add WITH storage_parameter option to create table [8.2] * Add last vacuum and analyze information from statistics tables [8.2] Views ----- * Support temporary views per 8.1? * Allow INSERT and import on views with the appropriate rules. * Allow altering of comments Sequences --------- * -Alter sequence (Guillaume LELARGE) * -setval & nextval (Guillaume LELARGE) * change schema * rename (done using alter table) Functions --------- * -Support 8.1 IN, OUT and INOUT parameters.(Jawed) * Remove options for OUT/INOUT params in older servers * Clean up javascript html spec warnings * Display owner * Alter owner Indexes ------- * Support 8.1 Reindex [Database|System] commands * Expressional indexes * Allow indexes to be built concurrently [8.2] Types ----- * Suppres psuedo-type options in type list for creating composite types. Operators --------- * Create Operator Classes ---------------- * Create Triggers -------- * Allow functions from other schemas. * -Support ENABLE/DISABLE trigger in 8.1 (Jawed) Aggregates ---------- * -Properties (Javier) * -Drop (Javier) * -Create (Javier) * Allow for multi-column aggregates [8.2] Languages --------- * Drop * Create Domains (7.3) ------------- Conversions (7.3) ----------------- * Properties * Drop * Create Casts (7.3) ----------- * Properties * Drop * Create Miscellaneous ------------- * -Allow management of built-in autovacuum in 8.1 (xzilla) * Support per-user and per-database connection limits per 8.1 * Put a 'What's blocking this query' on Processes view * -Show locks on database view (Javier) * Show prepared statements on database view [8.2] * Show cursors on database view [8.2] * Show NOTICES on queries in SQL window/file * -Add sslmode to connection variables (Eric Kinolik) * Printable view of things * 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 * -Icons for all objects, for use in navigation widgets Most objects are now covered thanks to those provided by Niko, but we still need icons for: Introduction, Variables, Admin, Privileges, Reports * Add CASCADE option to Truncate [8.2] * Add information about synch tool to TRANSLATORS Exotic ------ * Support contrib/tsearch2 for easy full text indexes * Pivot reports (ADODB has a feature for this) * Parameterized 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
💾 保存
取消
保存为 UTF-8，换行统一为 LF