Thread: Feature request in pgadmin (tested on Beta 5)
Hi Could I just mention a couple of requests:- 1. The first is to do with the treeview. The use case is where my users just connect to a single database (limited bydatname). Here the treeview shows :- Servers (1) -> Server -> Databases (1) -> Database -> Schemas (n) -> Schema theactually want to look at I wonder if it would be possible to collapse the treeview in this case either using options -> display? In this case the server is acting as a synonym for a database (as far as the users are concerned) so you could imaginehiding the Servers, Databases and Database leaving :- Server -> Schemas (n) -> Schema the actually want to look at 2. Allowing connect to server to specify both user and password. This is another case where I have to create multiple connections to the same database cluster to allow connection bydifferent users (standard user, superuser etc.). It also discourages me from using individual user ids for my users(always bad!). Many thanks Kieran
Kieran McCusker wrote: > Hi > > Could I just mention a couple of requests:- > > 1. The first is to do with the treeview. The use case is where my users > just connect to a single database (limited by datname). Here the > treeview shows :- > > Servers (1) > -> Server > -> Databases (1) > -> Database > -> Schemas (n) > -> Schema the actually want to look at > > I wonder if it would be possible to collapse the treeview in this > case either using options -> display? > > In this case the server is acting as a synonym for a database (as far > as the users are concerned) so you could imagine hiding the Servers, > Databases and Database leaving :- > > Server > -> Schemas (n) > -> Schema the actually want to look at I've been toying with the idea of having the treeview in a tabset in which users can create new treeviews using a node on an existing one as the root on a new one. I just haven't got round too it (too many ideas, too little time :-( ) > 2. Allowing connect to server to specify both user and password. > > This is another case where I have to create multiple connections to > the same database cluster to allow connection by different users > (standard user, superuser etc.). It also discourages me from using > individual user ids for my users (always bad!). That doesn't sound too hard - the dialog already has the required controls on it (albeit hidden in the scenario you're using it in) - we could just display them and default their values to what we currently use. Anyone want a little starter project? Regards, Dave.
I wouldn't mind taking a stab at this (and perhaps eventually other things). Could I ask what others use in terms of development environment? I tried Anjuta and Eclipse + CDT in Ubuntu, but they both had issues properly navigating the code through "Go to {definition,declaration}" (which I use constantly). I tried VS2k5 on Windows, and that seems to work nicely, but I'm confused by the setup instructions for pgAdmin with respect to building wxWidgets: Windows 2000, XP and 2003 A suitable setup.h file. Copy this to the appropriate include/wx/ and include/wx/msw directories in your wxWidgets source tree, and open the wxWidgets project in Visual Studio.... What suitable setup.h file is this talking about? Also, is it necessary to build wxWidgets to build pgAdmin? I hope I'm not asking for too much hand-holding, but it'd be nice to get started without running into the same problems that others have solved before. Thanks, Maciek > > 2. Allowing connect to server to specify both user and password. > > > > This is another case where I have to create multiple connections to > > the same database cluster to allow connection by different users > > (standard user, superuser etc.). It also discourages me from using > > individual user ids for my users (always bad!). > > That doesn't sound too hard - the dialog already has the required > controls on it (albeit hidden in the scenario you're using it in) - we > could just display them and default their values to what we currently use. > > Anyone want a little starter project? > > Regards, Dave. > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
Maciek Sakrejda wrote: > I wouldn't mind taking a stab at this (and perhaps eventually other > things). Cool. > Could I ask what others use in terms of development > environment? I tried Anjuta and Eclipse + CDT in Ubuntu, but they both > had issues properly navigating the code through "Go to > {definition,declaration}" (which I use constantly). I tried VS2k5 on > Windows, and that seems to work nicely, but I'm confused by the setup > instructions for pgAdmin with respect to building wxWidgets: VS2k5 is by far the best option. > Windows 2000, XP and 2003 > > A suitable setup.h file. Copy this to the appropriate include/wx/ and > include/wx/msw directories in your wxWidgets source tree, and open the > wxWidgets project in Visual Studio.... > > > What suitable setup.h file is this talking about? Also, is it necessary > to build wxWidgets to build pgAdmin? We tend to build wxWidgets ourselves because it ensures we get exactly the options we need. There is an easier way to do it though (I need to update that webpage): - Get a checkout of the pgAdmin code from SVN (a snapshot won't work as I just tweaked a file you'll need) - Unzip the wxWidgets source code somewhere, and setup an environment variable (%WXWIN%) to point to it. - Open a Visual Studio command prompt (if you're using Express, it's part of the Platform SDK), and change directory to xtra/wx-build in the pgAdmin source tree. - Run the build-wxmsw.bat file. Setting up the rest of the dependencies is just a case of downloading everything into a directory and setting up the environment variables per the webpage. > I hope I'm not asking for too much > hand-holding, but it'd be nice to get started without running into the > same problems that others have solved before. Feel free - if I spend 10 minutes helping you and you end up contributing even just one new feature it'll be worth it. Cheers, Dave.