|
1
|
PHPPGADMIN TODO LIST FOR DEVELOPERS
|
|
2
|
-----------------------------------
|
|
3
|
|
|
4
|
phpPgAdmin is an open source project which means that if you see something on
|
|
5
|
this list that you would like to implement, just send us a patch. You can find
|
|
6
|
our project page here:
|
|
7
|
|
|
8
|
http://sourceforge.net/projects/phppgadmin/
|
|
9
|
|
|
10
|
An item is marked 'claimed' when a username in brackets is put after the TODO
|
|
11
|
item.
|
|
12
|
|
|
13
|
An item is marked with a '-' if it has been completed.
|
|
14
|
|
|
15
|
Export
|
|
16
|
------
|
|
17
|
|
|
18
|
* Switch to SPARQL format:
|
|
19
|
http://www.w3.org/TR/2005/WD-rdf-sparql-XMLres-20050801/
|
|
20
|
|
|
21
|
Actually...SQL/XML is maybe better.
|
|
22
|
|
|
23
|
Misc
|
|
24
|
----
|
|
25
|
|
|
26
|
* Support 8.1 standard compliant strings (E'')
|
|
27
|
|
|
28
|
Users
|
|
29
|
-----
|
|
30
|
|
|
31
|
* 7.3 user variables (eg. ALTER USER SET .. TO ...)
|
|
32
|
|
|
33
|
Groups
|
|
34
|
------
|
|
35
|
|
|
36
|
Roles
|
|
37
|
-----
|
|
38
|
|
|
39
|
* Support for 8.1 roles (removing users and groups)
|
|
40
|
|
|
41
|
Permissions
|
|
42
|
-----------
|
|
43
|
|
|
44
|
* Grant ... on all tables, views, ... to user, group, public
|
|
45
|
|
|
46
|
Databases
|
|
47
|
---------
|
|
48
|
|
|
49
|
* Add alter database variables for 7.3+
|
|
50
|
* Comments on Create and Alter database
|
|
51
|
|
|
52
|
Schemas (7.3)
|
|
53
|
-------------
|
|
54
|
|
|
55
|
* Rename
|
|
56
|
* Alter owner
|
|
57
|
* Alter ... SET SCHEMA support
|
|
58
|
|
|
59
|
Large Objects
|
|
60
|
-------------
|
|
61
|
|
|
62
|
* Add support for large objects
|
|
63
|
|
|
64
|
Tables
|
|
65
|
------
|
|
66
|
|
|
67
|
* Allow PK and UNIQUE and FKs during create table
|
|
68
|
* Vacuum & analyze individual tables
|
|
69
|
* 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.
|
|
70
|
* When browsing a table, clicking on a FK value should jump to the
|
|
71
|
PK row.
|
|
72
|
* When editing a table, turn FK columns into drop-downs based on estimated
|
|
73
|
rows in the foreign table?
|
|
74
|
* Auto-select 'WITHOUT OIDS' if 'default_with_oids' setting is false
|
|
75
|
|
|
76
|
Views
|
|
77
|
-----
|
|
78
|
|
|
79
|
* Allow INSERT and import on views with the appropriate rules.
|
|
80
|
|
|
81
|
Sequences
|
|
82
|
---------
|
|
83
|
|
|
84
|
* Alter sequence
|
|
85
|
* setval & nextval
|
|
86
|
|
|
87
|
Functions
|
|
88
|
---------
|
|
89
|
|
|
90
|
* Support 8.1 IN, OUT and INOUT parameters.
|
|
91
|
* Display owner
|
|
92
|
* Alter owner
|
|
93
|
|
|
94
|
Indexes
|
|
95
|
-------
|
|
96
|
|
|
97
|
* Expressional indexes
|
|
98
|
|
|
99
|
Types
|
|
100
|
-----
|
|
101
|
|
|
102
|
Operators
|
|
103
|
---------
|
|
104
|
|
|
105
|
* Create
|
|
106
|
|
|
107
|
Operator Classes
|
|
108
|
----------------
|
|
109
|
|
|
110
|
* Create
|
|
111
|
|
|
112
|
Triggers
|
|
113
|
--------
|
|
114
|
|
|
115
|
* Allow functions from other schemas.
|
|
116
|
* Support ENABLE/DISABLE trigger in 8.1
|
|
117
|
|
|
118
|
Aggregates
|
|
119
|
----------
|
|
120
|
|
|
121
|
* Properties
|
|
122
|
* Drop
|
|
123
|
* Create
|
|
124
|
|
|
125
|
Languages
|
|
126
|
---------
|
|
127
|
|
|
128
|
* Drop
|
|
129
|
* Create
|
|
130
|
|
|
131
|
Domains (7.3)
|
|
132
|
-------------
|
|
133
|
|
|
134
|
Conversions (7.3)
|
|
135
|
-----------------
|
|
136
|
|
|
137
|
* Properties
|
|
138
|
* Drop
|
|
139
|
* Create
|
|
140
|
|
|
141
|
Casts (7.3)
|
|
142
|
-----------
|
|
143
|
|
|
144
|
* Properties
|
|
145
|
* Drop
|
|
146
|
* Create
|
|
147
|
|
|
148
|
Miscellaneous
|
|
149
|
-------------
|
|
150
|
|
|
151
|
* Allow management of built-in autovacuum in 8.1
|
|
152
|
* Put a 'What's blocking this query' on Processes view
|
|
153
|
* Show locks on database view
|
|
154
|
* Show NOTICES on queries in SQL window/file
|
|
155
|
* Add sslmode to connection variables
|
|
156
|
* Printable view of things
|
|
157
|
* Show comments for all objects (Dan Boren)
|
|
158
|
* Allow setting/dropping comments for all objects (Dan Boren)
|
|
159
|
* Show owner for all objects
|
|
160
|
* Allow changing owner for objects that have this feature (7.4+ generally)
|
|
161
|
* Translated FAQ
|
|
162
|
* Icons for all objects, for use in navigation widgets
|
|
163
|
|
|
164
|
Exotic
|
|
165
|
------
|
|
166
|
|
|
167
|
* Support contrib/tsearch2 for easy full text indexes
|
|
168
|
* Pivot reports (ADODB has a feature for this)
|
|
169
|
* Parameterized reports (use prepared queries)
|
|
170
|
* Full web accessability conformance
|
|
171
|
|
|
172
|
Principles
|
|
173
|
----------
|
|
174
|
|
|
175
|
* register_globals off support
|
|
176
|
* maximum error_reporting support - enforces code quality, reduces bugs and
|
|
177
|
improves security
|
|
178
|
* PHP 4.2 features used
|
|
179
|
* No HTML font, colour, layout tags. Use CSS for everything
|
|
180
|
* One day we should make it all XHTML
|
|
181
|
* everything properly escaped - prevent sql injection and cross-site scripting
|
|
182
|
probs
|
|
183
|
* Support Postgres 7.0 and upwards
|
|
184
|
* psql -E is a cool way of seeing how to do schema queries
|
|
185
|
* Checking out older versions of describe.c in src/bin/psql in the postgres
|
|
186
|
distro is a good way of seeing how to query older versions of postgres for
|
|
187
|
schema information
|
|
188
|
* Put functions in the highest class possible. For instance, simple selects
|
|
189
|
should be in Postgres, whereas something that works for 7.1+ should be in the
|
|
190
|
7.1 class. This will minimise bugs and duplicated code.
|
|
191
|
* Adhere to current coding standards
|
|
192
|
* Avoid using global variables if possible
|
|
193
|
|