Thread: What's the best front end/client under MS Windows?
Kindly list the advantages/disadvantages for me, THX!
I'm partial to the ZEOS Database Explorer myself. I don't have experience with a multitude of tools, so the best I can offer is that I have no problems with the latest version :) Actually, I can tell you that it has the advantage of a native interface (rather than relying on ODBC). And it's free, that's always an advantage. Oh, and it does have the disadvantage of not showing NOTICEs, which is a pain in the ass when doing benchmarking via EXPLAIN, for which I'm forced to use psql. There were some problems in older versions (specifically it was having trouble stripping out spaces on newlines and with quoting on triggers), but those problems seem to be resolved with the latest version. It's not the most stable program, but most people don't use Windows for stability... Address is http://www.zeoslib.org/ but it appears to be down at the moment. Greg ----- Original Message ----- From: "Walter Chong" <mail2walter@yahoo.com> To: <pgsql-general@postgresql.org> Sent: Friday, May 11, 2001 11:03 PM Subject: What's the best front end/client under MS Windows? > Kindly list the advantages/disadvantages for me, THX! > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
On Mon, 14 May 2001, Gregory Wood wrote: > I'm partial to the ZEOS Database Explorer myself. I don't have experience > with a multitude of tools, so the best I can offer is that I have no > problems with the latest version :) Actually, I can tell you that it has the > advantage of a native interface (rather than relying on ODBC). And it's > free, that's always an advantage. > > Oh, and it does have the disadvantage of not showing NOTICEs, which is a > pain in the ass when doing benchmarking via EXPLAIN, for which I'm forced to > use psql. There were some problems in older versions (specifically it was > having trouble stripping out spaces on newlines and with quoting on > triggers), but those problems seem to be resolved with the latest version. > It's not the most stable program, but most people don't use Windows for > stability... > > Address is http://www.zeoslib.org/ but it appears to be down at the moment. Actually I found them at http://www.marms.com/zeos/eng/ regards, thalis > > Greg > > ----- Original Message ----- > From: "Walter Chong" <mail2walter@yahoo.com> > To: <pgsql-general@postgresql.org> > Sent: Friday, May 11, 2001 11:03 PM > Subject: What's the best front end/client under MS Windows? > > > > Kindly list the advantages/disadvantages for me, THX! > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
Hi Greg, Instead of using psql to get the NOTICES, when I program in PL/pgSQL, I start the database with -d 2 (debug level of 2) and this forces the NOTICES into the PostgreSQL log file. Then, I just have a telnet/ssh/etc session on the server running : tail -f postgresql.log So I constantly have access to the NOTICES which PostgreSQL generates, regardless of how I'm hitting it. Would this be useful to you? :-) Regards and best wishes, Justin Clift Gregory Wood wrote: > > I'm partial to the ZEOS Database Explorer myself. I don't have experience > with a multitude of tools, so the best I can offer is that I have no > problems with the latest version :) Actually, I can tell you that it has the > advantage of a native interface (rather than relying on ODBC). And it's > free, that's always an advantage. > > Oh, and it does have the disadvantage of not showing NOTICEs, which is a > pain in the ass when doing benchmarking via EXPLAIN, for which I'm forced to > use psql. There were some problems in older versions (specifically it was > having trouble stripping out spaces on newlines and with quoting on > triggers), but those problems seem to be resolved with the latest version. > It's not the most stable program, but most people don't use Windows for > stability... > > Address is http://www.zeoslib.org/ but it appears to be down at the moment. > > Greg > > ----- Original Message ----- > From: "Walter Chong" <mail2walter@yahoo.com> > To: <pgsql-general@postgresql.org> > Sent: Friday, May 11, 2001 11:03 PM > Subject: What's the best front end/client under MS Windows? > > > Kindly list the advantages/disadvantages for me, THX! > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
> Then, I just have a telnet/ssh/etc session on the server running : > Would this be useful to you? Seem just as easy to run psql to me. In fact a bit easier as I don't have to switch back and forth between windows. I guess it goes back to the days when I was first learning SQL on a MySQL web database... I didn't have telnet access so I had to do everything via PHP or their WebAdmin tool (which used... PHP). So anytime I see something that requires some sort of shell access I don't like it. EXPLAIN is one of those things. Greg
"Gregory Wood" <gregw@com-stock.com> writes:
> ... So anytime I see something that requires some sort of shell access
> I don't like it. EXPLAIN is one of those things.
Huh? EXPLAIN doesn't require shell access ... it merely requires a
client that doesn't drop NOTICE messages into the bit bucket.
Clients that drop NOTICEs are broken for a number of reasons besides
EXPLAIN, anyway.
regards, tom lane
> > ... So anytime I see something that requires some sort of shell access > > I don't like it. EXPLAIN is one of those things. > > Huh? EXPLAIN doesn't require shell access ... it merely requires a > client that doesn't drop NOTICE messages into the bit bucket. > > Clients that drop NOTICEs are broken for a number of reasons besides > EXPLAIN, anyway. Very poor choice of wording on my part... my apologies. How are clients that drop NOTICEs broken though? Greg
"Gregory Wood" <gregw@com-stock.com> writes:
> How are clients that drop NOTICEs broken though?
Because you want to be able to see NOTICEs ... at least if you are doing
SQL development. (I don't object to optionally dropping them, but I
think the default should be to show 'em, at least in interactive work.)
regards, tom lane
Hi I like WinSQL LITE. There you get all messages. You can get it from: http://www.indus-soft.com/ It uses ODBC to connect. Best regards Per-Olof Pettersson >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2001-05-14, 16:33:08, gregw@com-stock.com ("Gregory Wood") wrote regarding Re: What's the best front end/client under MS Windows?: > I'm partial to the ZEOS Database Explorer myself. I don't have experience > with a multitude of tools, so the best I can offer is that I have no > problems with the latest version :) Actually, I can tell you that it has the > advantage of a native interface (rather than relying on ODBC). And it's > free, that's always an advantage. > Oh, and it does have the disadvantage of not showing NOTICEs, which is a > pain in the ass when doing benchmarking via EXPLAIN, for which I'm forced to > use psql. There were some problems in older versions (specifically it was > having trouble stripping out spaces on newlines and with quoting on > triggers), but those problems seem to be resolved with the latest version. > It's not the most stable program, but most people don't use Windows for > stability... > Address is http://www.zeoslib.org/ but it appears to be down at the moment. > Greg > ----- Original Message ----- > From: "Walter Chong" <mail2walter@yahoo.com> > To: <pgsql-general@postgresql.org> > Sent: Friday, May 11, 2001 11:03 PM > Subject: What's the best front end/client under MS Windows? > > Kindly list the advantages/disadvantages for me, THX! > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
> Hi I like WinSQL LITE. > There you get all messages. You can get it from: > http://www.indus-soft.com/ > It uses ODBC to connect. > > Best regards > Per-Olof Pettersson I tried WinSQL Lite with the newest PsqlODBC driver on Postgres 7.0.3 and I didn't get the NOTICE messages when I ran a query using EXPLAIN. How then did you manage get them? Thanks much, Brent __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/