Обсуждение: TODO List

Hackers,

Can you please take a minute or two to look at the TODO list:
http://www.pgadmin.org/development/todo.php and note any items that
have been completed already, ones that don't make any sense now
(perhaps because PostgreSQL has implemented a feature we wanted to
emulate), or items that are just plain daft!

A similar pass over the bugs list:
http://www.pgadmin.org/support/issues.php would also be useful - there
are probably some which are no longer relevant or have been fixed in
wx or other places.

Thanks!

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

Hi, Dave in the todo list as major project you can add and an entity relationship model tool with reverse engineering that manage all major features of postgresql (like complex types and others). I hope to help in this item after start to work again in the GQB and finish it :)   I have been busy :(.

- Will be very interesting create a tool (Report tool) that allow dbas to create reports of data inside the databases (probably using the GQB) because this is one of the most tedious work in some organizations  where the dba is developer too (not as part of main pgAdmin but as a plugin or something like that).

- Something very important for me, is the creation of an update wizard that alert users that there is a new version of pgAdmin and allow to install it, or at least inform about the new features of the new version, because  some organizations  are using very old versions of pgAdmin and never remember about update it.

And a list of ideas from commercial applications:
- Blob View/Editor for more common files stored (like images) when navigate througth data
- Help with bussines intelligent applications like OLAP or a data mart / data warehouse design tool
- Interface to use SSH/HTTP tunnel

This are just ideas.

Regards, Luis.

On Tue, Nov 18, 2008 at 2:00 PM, Luis Ochoa <ziul1979@gmail.com> wrote:
> Hi, Dave in the todo list as major project you can add and an entity
> relationship model tool with reverse engineering that manage all major
> features of postgresql (like complex types and others). I hope to help in
> this item after start to work again in the GQB and finish it :)   I have
> been busy :(.
>
> - Will be very interesting create a tool (Report tool) that allow dbas to
> create reports of data inside the databases (probably using the GQB) because
> this is one of the most tedious work in some organizations  where the dba is
> developer too (not as part of main pgAdmin but as a plugin or something like
> that).
>
> - Something very important for me, is the creation of an update wizard that
> alert users that there is a new version of pgAdmin and allow to install it,
> or at least inform about the new features of the new version, because  some
> organizations  are using very old versions of pgAdmin and never remember
> about update it.
>
> And a list of ideas from commercial applications:
> - Blob View/Editor for more common files stored (like images) when navigate
> througth data
> - Help with bussines intelligent applications like OLAP or a data mart /
> data warehouse design tool
> - Interface to use SSH/HTTP tunnel
>
> This are just ideas.

Hi Luis,

I'm trying to remove stuff from the lists, not add to them!

By all means send a patch for concrete ideas to add though - but try
to avoid non-specific ideas.

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

Dave Page a écrit :
> [...]
> Can you please take a minute or two to look at the TODO list:
> http://www.pgadmin.org/development/todo.php and note any items that
> have been completed already, ones that don't make any sense now
> (perhaps because PostgreSQL has implemented a feature we wanted to
> emulate), or items that are just plain daft!
>

Add support for DESC/NULLS FIRST/NULLS LAST when creating indexes.
 ==> Quan Zongliang is working on it (new patch available)

Allow SQL 'macros' to be programmed in the query tool, with a place
holder to be substituted with highlighted text - eg. Ctrl-F1 could run
SELECT relname FROM pg_class WHERE relname like '$PLACEHOLDER$%' to list
matching relations.
 ==> is partly available (PLACEHOLDER stuff is still missing)

Add infrastructure to allow databases to be renamed. This requires that
the SQL be executed in a database other than the current one.
 ==> I did this one a few days ago :)

Columns of Views: show properties
 ==> I think this one is done, but I don't remember by whom.


> A similar pass over the bugs list:
> http://www.pgadmin.org/support/issues.php would also be useful - there
> are probably some which are no longer relevant or have been fixed in
> wx or other places.
>

I don't find something to remove there.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

On Wed, Nov 19, 2008 at 10:33 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
> Dave Page a écrit :
>> [...]
>> Can you please take a minute or two to look at the TODO list:
>> http://www.pgadmin.org/development/todo.php and note any items that
>> have been completed already, ones that don't make any sense now
>> (perhaps because PostgreSQL has implemented a feature we wanted to
>> emulate), or items that are just plain daft!
>>
>
> Add support for DESC/NULLS FIRST/NULLS LAST when creating indexes.
>  ==> Quan Zongliang is working on it (new patch available)

Yup.

> Allow SQL 'macros' to be programmed in the query tool, with a place
> holder to be substituted with highlighted text - eg. Ctrl-F1 could run
> SELECT relname FROM pg_class WHERE relname like '$PLACEHOLDER$%' to list
> matching relations.
>  ==> is partly available (PLACEHOLDER stuff is still missing)

No, we have that :-) We actually use $SELECTION$ though, iirc.

> Add infrastructure to allow databases to be renamed. This requires that
> the SQL be executed in a database other than the current one.
>  ==> I did this one a few days ago :)

:-)

> Columns of Views: show properties
>  ==> I think this one is done, but I don't remember by whom.

That would be me :-)

Thanks - I've removed them, and some other entries that didn't make much sense.

>
>> A similar pass over the bugs list:
>> http://www.pgadmin.org/support/issues.php would also be useful - there
>> are probably some which are no longer relevant or have been fixed in
>> wx or other places.
>>
>
> I don't find something to remove there.

I found one Windows bug, but afaik, everything else is still current.

Thanks!

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com