Thread: The future of pgAdmin...
Hello, We are trying to map out the future of pgAdmin and would like to get feedback from it's users to help us produce software that is beneficial to as many people as possible. We would appreciate any comments or suggestions... Currently we are working on a couple of large projects: 1) pgSchema is an object library that will represent an entire PostgreSQL server, not just a single database. It will provide collections of objects like Databases, Users, Types and Tables. It is a hierarchical object model with methods and events in place to provide a framework for any application (not just pgAdmin) for logging, query execution and browsing/creating/deleting any database object (ACLs allowing of course). The intention is to replace the current Browsers in pgAdmin with a single Treeview Browser similar (though superior :-)) to the one found in the MS SQL Server Enterprise Manager. 2) Full Development Environment - this allows for building of Functions/Views/Triggers etc in a non-production environment. Dependencies are tracked, and when required, the code can be fully or partially built on the server. The intention is to add code repository features as well as facilities to roll out code/object packages to production server(s) as required. We would welcome any comments on these and other possible projects. Regards, Dave Page pgAdmin Project Leader
A graphical schema representation would be useful too (like the one you find in Access or in the SQL Server GUI). Some people prefer to work with text... others (like me) prefer to work with graphical representations (E/R and so on...). I'd also have some idea on how to implement it... but I can't find enough time (I'm already involved in GRASS and in Cypheus projects... my spare time is definitely full :-( ...) Regards Andrea Aime Dave Page wrote: > > Hello, > > We are trying to map out the future of pgAdmin and would like to get > feedback from it's users to help us produce software that is beneficial to > as many people as possible. We would appreciate any comments or > suggestions... > > Currently we are working on a couple of large projects: > > 1) pgSchema is an object library that will represent an entire PostgreSQL > server, not just a single database. It will provide collections of objects > like Databases, Users, Types and Tables. It is a hierarchical object model > with methods and events in place to provide a framework for any application > (not just pgAdmin) for logging, query execution and > browsing/creating/deleting any database object (ACLs allowing of course). > > The intention is to replace the current Browsers in pgAdmin with a single > Treeview Browser similar (though superior :-)) to the one found in the MS > SQL Server Enterprise Manager. > > 2) Full Development Environment - this allows for building of > Functions/Views/Triggers etc in a non-production environment. Dependencies > are tracked, and when required, the code can be fully or partially built on > the server. The intention is to add code repository features as well as > facilities to roll out code/object packages to production server(s) as > required. > > We would welcome any comments on these and other possible projects. > > Regards, > > Dave Page > pgAdmin Project Leader > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl