Thread: graphical interface - admin
What's the best open source GUI for DB administration? (postgres)
On Thu, Jun 27, 2002 at 07:50:09PM +0800, q u a d r a wrote: > > What's the best open source GUI for DB administration? (postgres) Emacs. ;) -- Ron Peterson -o) 87 Taylor Street /\\ Granby, MA 01033 _\_v https://www.yellowbank.com/ ----
Le Jeudi 27 Juin 2002 13:50, q u a d r a a écrit : > What's the best open source GUI for DB administration? (postgres) Why ? Mine of course ! Noway for this stupid answer ! Well, I would say that you have at least two choices amongst those I know : phpPgAdmin, which works as it's name says with php, and one that is called pgaccess and which is brought along with the sources of postgreSQL, and which is written in tcl/tk (as far as I know). Anyway, neither of them fits my needs. You also have commercial solutions, like creating a linked db with msAccess (using ODBC), or BO (orientated for editions). Anyway, you've got many choices. As for what I first said in this mail, I'll launch the development of a Kde application (I think called KPostgreSQL...), which will have to fit the following : -Ability to open as many DB connections as possible in one MDI frame (as you can open many documents in KAte). -Graphical interface for all the administrative tasks (tables creations, permissions...) nearly as Access does. -Intelligent queries (at requests), which are able to do autimatic joins (as far as they are created at table creation time). -Nice editions made with LaTeX, providing there are classes made. -etc... In the future, when I get a full comprention of KParts, it may be integrated with KWords and all the Koffice suite (I mean, you could embed a query in KSpread, and so on...). That's what I plan to do, all in C++, and only for Kde. When the project will be far enough, I'll open the sources, using CVS I think, and enjoy my time coding and maybe recieving help. Whatever happens in the future, I WANT to code this, and will work on it since I need it. > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- David BOURIAUD ---------------------------------------------------------- In a world without walls or fences, what use do we have for windows or gates ? ---------------------------------------------------------- ICQ#102562021
David, > As for what I first said in this mail, I'll launch the development of > a Kde > application (I think called KPostgreSQL...), which will have to fit > the > following : Listen, the PGAdminII "team" (i.e. David Page) is planning to port PGAdmin to a more OS-independant platform, such as C++ or Java. Instead of striking out on your own, how about you get togetherwith them? Or, in the short term, you could do the community a huge service just by ressurecting KPSQL, which died with KDE 1.1. It just needs a KDE expert to dust it off and make it compatible with KDE 3.0. Just my thoughts. I'd just really hate to see another 50% complete PostgreSQL interface -- we have too many, already. -Josh Berkus
I'd love to see this as much as anyone, but if you're going to do it imo the main feature most people would be interested in is some type of ERD diagramming that can also be used for database administration (yes, basically a clone of M$ Access, but with more native support). This is the one thing I'd really like to add to phpPgAdmin, but the web isn't the best medium for those types of things, and quite frankly I haven't had the time to really look into it. OpenOffice comes close with it's graphical query builder, but afaik it doesn't quite have the ability to layout tables/relationships as well. Last time I checked PGAccess was lacking in this area as well. If your serious about starting another project I'd strongly recommend you search on sourceforge first as there are several projects there than can help you out. You should definitely take a look at dbdesigner, which is a KDE based (and I'd assume C++) admin tool that has postgres support. Stand on the shoulders of others right? Robert Treat On Fri, 2002-06-28 at 02:38, David BOURIAUD wrote: > Le Jeudi 27 Juin 2002 13:50, q u a d r a a écrit : > > What's the best open source GUI for DB administration? (postgres) > Why ? Mine of course ! > > Noway for this stupid answer ! > Well, I would say that you have at least two choices amongst those I know : > phpPgAdmin, which works as it's name says with php, and one that is called > pgaccess and which is brought along with the sources of postgreSQL, and which > is written in tcl/tk (as far as I know). > > Anyway, neither of them fits my needs. You also have commercial solutions, > like creating a linked db with msAccess (using ODBC), or BO (orientated for > editions). Anyway, you've got many choices. > > As for what I first said in this mail, I'll launch the development of a Kde > application (I think called KPostgreSQL...), which will have to fit the > following : > > -Ability to open as many DB connections as possible in one MDI frame (as you > can open many documents in KAte). > -Graphical interface for all the administrative tasks (tables creations, > permissions...) nearly as Access does. > -Intelligent queries (at requests), which are able to do autimatic joins (as > far as they are created at table creation time). > -Nice editions made with LaTeX, providing there are classes made. > -etc... > In the future, when I get a full comprention of KParts, it may be integrated > with KWords and all the Koffice suite (I mean, you could embed a query in > KSpread, and so on...). > That's what I plan to do, all in C++, and only for Kde. When the project will > be far enough, I'll open the sources, using CVS I think, and enjoy my time > coding and maybe recieving help. Whatever happens in the future, I WANT to > code this, and will work on it since I need it. > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > -- > David BOURIAUD > ---------------------------------------------------------- > In a world without walls or fences, what use do we have > for windows or gates ? > ---------------------------------------------------------- > ICQ#102562021 > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: 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 >
Has anyone had any experience with rekall? It doesn't do ERDs, but looks a lot like Access/pgaccess. terry
Terry, > Has anyone had any experience with rekall? It doesn't do ERDs, > but looks a lot like Access/pgaccess. Yes :-( Rekall is really set up to work with MySQL, and only provides indifferent support of PostgreSQL. And, IMHO, the OpenOffice.org Data Source navigator offers more functionality without the license fee. (I'm on the OpenOffice.org project, so take that as you wish). Give Rekall another year, and it may be the MS Access replacement people are looking for. But not today. -- -Josh Berkus
On Friday 28 June 2002 17:30, Josh Berkus wrote: > David, > > > As for what I first said in this mail, I'll launch the development of > > a Kde > > application (I think called KPostgreSQL...), which will have to fit > > the > > following : > > Listen, the PGAdminII "team" (i.e. David Page) is planning to port > PGAdmin to a more OS-independant platform, such as C++ or Java. > Instead of striking out on your own, how about you get together with > them? > > Or, in the short term, you could do the community a huge service just > by ressurecting KPSQL, which died with KDE 1.1. It just needs a KDE > expert to dust it off and make it compatible with KDE 3.0. > > Just my thoughts. I'd just really hate to see another 50% complete > PostgreSQL interface -- we have too many, already. > > -Josh Berkus Take a look at TOra - Toolkit For Oracle: http://www.globecom.se/tora/ It has excellent PostgreSQL support. -- Andreas Joseph Krogh (Senior Software Developer) <andreak@officenet.no> "Everything should be made as simple as possible, but not simpler" - Albert Einstein
On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote: > > Take a look at TOra - Toolkit For Oracle: http://www.globecom.se/tora/ > > It has excellent PostgreSQL support. I tried 1.2.4 but didn't found how to configure tora to work with postgresql. > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
On Monday 01 July 2002 13:29, you wrote: > On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote: > > Take a look at TOra - Toolkit For Oracle: http://www.globecom.se/tora/ > > > > It has excellent PostgreSQL support. > > I tried 1.2.4 but didn't found how to configure tora to work > with postgresql. I have a version here which works for me: http://www.officenet.no/~andreak/tora-alpha-1.3.4-1static.i686.rpm If you get a core-dump, try temporarily to remove your $HOME/.qt dir. I have not gotten the newer version(1.3.5.1) to work with PostgreSQL(I only get Oracle and MySQL in the combo-box even though its staticly linked with pgsql). -- Andreas Joseph Krogh (Senior Software Developer) <andreak@officenet.no> "Everything should be made as simple as possible, but not simpler" - Albert Einstein
On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote: > On Monday 01 July 2002 13:29, you wrote: > > On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote: > > > Take a look at TOra - Toolkit For Oracle: http://www.globecom.se/tora/ > > > > > > It has excellent PostgreSQL support. > > > > I tried 1.2.4 but didn't found how to configure tora to work > > with postgresql. > > I have a version here which works for me: > http://www.officenet.no/~andreak/tora-alpha-1.3.4-1static.i686.rpm > > If you get a core-dump, try temporarily to remove your $HOME/.qt dir. > > I have not gotten the newer version(1.3.5.1) to work with PostgreSQL(I only > get Oracle and MySQL in the combo-box even though its staticly linked with > pgsql). How did you configure sources ? There is no --with-pgsql option > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
On Monday 01 July 2002 15:00, Oleg Bartunov wrote: > On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote: > > On Monday 01 July 2002 13:29, you wrote: > > > On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote: > > > > Take a look at TOra - Toolkit For Oracle: > > > > http://www.globecom.se/tora/ > > > > > > > > It has excellent PostgreSQL support. > > > > > > I tried 1.2.4 but didn't found how to configure tora to work > > > with postgresql. > > > > I have a version here which works for me: > > http://www.officenet.no/~andreak/tora-alpha-1.3.4-1static.i686.rpm > > > > If you get a core-dump, try temporarily to remove your $HOME/.qt dir. > > > > I have not gotten the newer version(1.3.5.1) to work with PostgreSQL(I > > only get Oracle and MySQL in the combo-box even though its staticly > > linked with pgsql). > > How did you configure sources ? There is no --with-pgsql option I didn't:-) I downloaded the precompiled static binary. -- Andreas Joseph Krogh (Senior Software Developer) <andreak@officenet.no> "Everything should be made as simple as possible, but not simpler" - Albert Einstein
On Mon, Jul 01, 2002 at 02:29:27PM +0300, Oleg Bartunov wrote: > > I tried 1.2.4 but didn't found how to configure tora to work > with postgresql. Tora is very nice. I'm using 1.3.5 with PG 7.2 (Debian). I had to compile the PostgreSQL Qt 3 module for it to work. -Roberto -- +----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer * * * <- Tribbles § § § <- teenage mutant ninja tribbles