1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
TODO Items
==========
Essentials
----------
- Recreate views after column type change
- Confirm existing password against the DB when changing the current password.
Refactoring
-----------
- Rewrite cast, operator, operatorclass to use pgDatatype
- Rewrite the grid cell text editor to use wxStyledTextCtrl rather than a
wxTextCtrl. This avoids the need to use the RichEdit control on Windows, thus
eliminating problems with hyperlink formatting creeping into pasted data, as
well as the extra line ends that get appended to RTF text.
Enhancements / wishes
---------------------
- Cache datatypes used by dlgColumn as reloading them when adding multiple
columns to a new table can be slow over WANs.
- Add an option (or change the UI to something more usable with lots of types)
to include table types in the data type combo boxes where appropriate.
- Ability to search a database for objects with a specific name.
- Attempt to reconnect to the server following a connection failure.
- Allow the user to disconnect individual databases
- detect serial columns from pg_depend, not column default (observe deviating
serial name)
- Slony-I failover
- Drop object using replication
- Restrict subscription provider to origin and subscribers
- Extract partially or whole schema/db and edit it with Query Tool
- Track connection usage by property dialogs to prevent closing used
connections
- Allow Sequence to be attached to existing int4/int8 columns
- Sequence: calculate next value to be expected
- Import from CSV
- Create FK: PK/unique detection
- Global object modification logging
- EditGrid: allow editing if unique key existent, but no PK/OID
- EditGrid: better editing (color, validation)
- Updateable View wizard
- Most property dlgs: check for readOnly if no sufficient rights are available
- CREATE TABLE LIKE table
- Operator class property: to implement
- Find solution for dlgProperty::AppendQuoted if schemaname has a dot
- Allow EditGrid to use comboboxes filled from FK tables.
- Add an option to the Query Tool to exclusively lock files whilst they're
being edited.
Major Projects
--------------
- Python scripting engine
- Data Import/Export tool, for file & external database IO. Including data
transformation.
- Index Checker. A tool to check for missing indexes on FK columns.
|