Proposed Feature
I'm using PG on windows for the first time (as of about 6 minutes ago).
I was thinking that it would be great to have a system tray icon with a
running indicator, kind of like the way Apache2.x for windows has, or
even MSSQL. Perhaps the PG logo with a small white circle with a red
square or a green triangle in the same fashion.
Just a thought.
- Naz.
Naz Gassiep wrote:
I'm using PG on windows for the first time (as of about 6 minutes ago).
I was thinking that it would be great to have a system tray icon with a
running indicator, kind of like the way Apache2.x for windows has, or
even MSSQL. Perhaps the PG logo with a small white circle with a red
square or a green triangle in the same fashion.
Just a thought.
And what does the icon show or do?
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Bruce Momjian wrote:
Naz Gassiep wrote:
I'm using PG on windows for the first time (as of about 6 minutes ago).
I was thinking that it would be great to have a system tray icon with a
running indicator, kind of like the way Apache2.x for windows has, or
even MSSQL. Perhaps the PG logo with a small white circle with a red
square or a green triangle in the same fashion.
Just a thought.And what does the icon show or do?
We had this for the win32 version of replicator. Ours allowed:
Viewing Eventlog
Start/Stop
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Bruce Momjian wrote:
Naz Gassiep wrote:
I'm using PG on windows for the first time (as of about 6 minutes ago).
I was thinking that it would be great to have a system tray icon with a
running indicator, kind of like the way Apache2.x for windows has, or
even MSSQL. Perhaps the PG logo with a small white circle with a red
square or a green triangle in the same fashion.
Just a thought.And what does the icon show or do?
That would be pretty easy to do with Delphi.
I could whip something up and donate it to the project with a BSD license.
It could be a green "Play" arrow if the service is running and a red one
if it is not, then have a few right click options
to start/stop/restart the service.
I was thinking the same thing awhile back, but forgot about it.
Later,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi,<br>
It provides a very quick and easy status check (running or not) as
well as right click access to start/stop and any other basic admin
features that may be appropriate. I'd be happy with seeing whether it
was running, as well as start/stop accessible via one right click. It's
the same as Apache for Win32, MSSQL any many other server programs.<br>
- Naz.<br>
<br>
Bruce Momjian wrote:
<blockquote cite="mid:200706221457.l5MEvmf26307@momjian.us" type="cite">
<pre wrap="">Naz Gassiep wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I'm using PG on windows for the first time (as of about 6 minutes ago).
I was thinking that it would be great to have a system tray icon with a
running indicator, kind of like the way Apache2.x for windows has, or
even MSSQL. Perhaps the PG logo with a small white circle with a red
square or a green triangle in the same fashion.
Just a thought.
</pre>
</blockquote>
<pre wrap=""><!---->
And what does the icon show or do?
</pre>
</blockquote>
</body>
</html>
Hey,
I'm sure that'd be greatly appreciated, most other major servers and
DBs have a similar feature, and that's what the systray is for, i.e.,
viewing major user-installed services.
- Naz.
Tony Caduto wrote:
Show quoted text
Bruce Momjian wrote:
Naz Gassiep wrote:
I'm using PG on windows for the first time (as of about 6 minutes ago).
I was thinking that it would be great to have a system tray icon with a
running indicator, kind of like the way Apache2.x for windows has, or
even MSSQL. Perhaps the PG logo with a small white circle with a red
square or a green triangle in the same fashion.
Just a thought.And what does the icon show or do?
That would be pretty easy to do with Delphi.
I could whip something up and donate it to the project with a BSD
license.It could be a green "Play" arrow if the service is running and a red
one if it is not, then have a few right click options
to start/stop/restart the service.I was thinking the same thing awhile back, but forgot about it.
Later,
Tony Caduto wrote:
Bruce Momjian wrote:
Naz Gassiep wrote:
I'm using PG on windows for the first time (as of about 6 minutes ago).
I was thinking that it would be great to have a system tray icon with a
running indicator, kind of like the way Apache2.x for windows has, or
even MSSQL. Perhaps the PG logo with a small white circle with a red
square or a green triangle in the same fashion.
Just a thought.And what does the icon show or do?
That would be pretty easy to do with Delphi.
I could whip something up and donate it to the project with a BSD license.
I think it'd be reasonably easy in any language really, but that's
beside the point - if you're volunteering to do it, you get to pick
language :)
Does Delphi bring in any additional runtime requirements, though? I
don't think we'd want to add a big extra runtime for such a small thing.
It could be a green "Play" arrow if the service is running and a red one
if it is not, then have a few right click options
to start/stop/restart the service.
How would it deal with multiple servers (same or different version)
running on the same box? I did think about this for 10 minutes back when
we first did 8.0 for win32, but I got stuck somewhere between that
question and the fact that I didn't need/want it myself :-)
//Magnus
Naz Gassiep wrote:
Hey,
I'm sure that'd be greatly appreciated, most other major servers and
DBs have a similar feature, and that's what the systray is for, i.e.,
viewing major user-installed services.
Don't forget that the tray (or taskbar notification area as it's
supposed to be called) is one of the most abused areas of the windows
GUI. I've seen installs where it takes up half the screen. So it's not
*necessarily* a good thing - making it mandatory to have an easy way to
turn it off. And if we don't add any actual *functionality*, it should
absolutely not be enabled by default. Providing it as an option is never
wrong, though.
//Magnus
------- Original Message -------
From: Magnus Hagander <magnus@hagander.net>
To: Naz Gassiep <naz@mira.net>
Sent: 23/06/07, 10:39:01
Subject: Re: [GENERAL] Proposed FeatureNaz Gassiep wrote:
Hey,
I'm sure that'd be greatly appreciated, most other major servers and
DBs have a similar feature, and that's what the systray is for, i.e.,
viewing major user-installed services.Don't forget that the tray (or taskbar notification area as it's
supposed to be called) is one of the most abused areas of the windows
GUI. I've seen installs where it takes up half the screen. So it's not
*necessarily* a good thing - making it mandatory to have an easy way to
turn it off. And if we don't add any actual *functionality*, it should
absolutely not be enabled by default. Providing it as an option is never
wrong, though.
I have no problem adding such a gizmo to the installer if it works well and has no onerous runtime requirements, but I wouldn't want it to be installed by default.
/D
Import Notes
Resolved by subject fallback
On 23/06/2007 10:30, Magnus Hagander wrote:
Does Delphi bring in any additional runtime requirements, though? I
don't think we'd want to add a big extra runtime for such a small thing.
Delhpi executables are completely self-contained - they don't need any
extra runtime libraries or DLLs (unless you create them yourself, of
course). That does mean that a Win32 GUI app will be around 300k or so
minimum.
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Yo,<br>
I'd have no problem with it being disabled by default. I ruthlessly
pare my systray down and turn on the hide inactive icons function as
well. But when I have PG running it is the sort of thing I'd want to be
able to see at a glance, the same as with Apache.<br>
- Naz.<br>
<br>
Magnus Hagander wrote:
<blockquote cite="mid:467CEA35.4090603@hagander.net" type="cite">
<pre wrap="">Naz Gassiep wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hey,
I'm sure that'd be greatly appreciated, most other major servers and
DBs have a similar feature, and that's what the systray is for, i.e.,
viewing major user-installed services.
</pre>
</blockquote>
<pre wrap=""><!---->
Don't forget that the tray (or taskbar notification area as it's
supposed to be called) is one of the most abused areas of the windows
GUI. I've seen installs where it takes up half the screen. So it's not
*necessarily* a good thing - making it mandatory to have an easy way to
turn it off. And if we don't add any actual *functionality*, it should
absolutely not be enabled by default. Providing it as an option is never
wrong, though.
//Magnus
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
</pre>
</blockquote>
</body>
</html>
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of
Magnus Hagander
Sent: zaterdag 23 juni 2007 11:39
To: Naz Gassiep
Cc: Tony Caduto; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Proposed FeatureNaz Gassiep wrote:
Hey,
I'm sure that'd be greatly appreciated, most other major servers
and DBs have a similar feature, and that's what the systray is for,
i.e., viewing major user-installed services.Don't forget that the tray (or taskbar notification area as
it's supposed to be called) is one of the most abused areas of
the windows GUI. I've seen installs where it takes up half the
screen. So it's not
*necessarily* a good thing - making it mandatory to have an
easy way to turn it off. And if we don't add any actual
*functionality*, it should absolutely not be enabled by
default. Providing it as an option is never wrong, though.
I fully agree with the not part of the default installation. And make it
easy to turn the thing off.
In that respect it sound like a good feature for developer systems (not
servers per se). Just ensure for a small memory footprint, preferably
within a few 100 KB of memory. If you are going over 1 MB you are
seriously doing something wrong. (Obviously that might be acceptable
when I'm actively using it, but otherwise it should keep memory usage as
low as resonably possible).
Secondly it might be a good feature to let the user choose at
installation time to install postgres as a service and either start it
on boot (server) or have the user control when it should start
(developer system). In the latter case, such a tray icon might be a very
good feature (since it keeps my 1.5 GB of memory less occupied than
full, though postgresql is already quite a friendly program in this
respect).
- Joris
Joris Dobbelsteen wrote:
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of
Magnus Hagander
Sent: zaterdag 23 juni 2007 11:39
To: Naz Gassiep
Cc: Tony Caduto; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Proposed FeatureNaz Gassiep wrote:
Hey,
I'm sure that'd be greatly appreciated, most other major servers
and DBs have a similar feature, and that's what the systray is for,
i.e., viewing major user-installed services.Don't forget that the tray (or taskbar notification area as
it's supposed to be called) is one of the most abused areas of
the windows GUI. I've seen installs where it takes up half the
screen. So it's not
*necessarily* a good thing - making it mandatory to have an
easy way to turn it off. And if we don't add any actual
*functionality*, it should absolutely not be enabled by
default. Providing it as an option is never wrong, though.I fully agree with the not part of the default installation. And make it
easy to turn the thing off.In that respect it sound like a good feature for developer systems (not
servers per se). Just ensure for a small memory footprint, preferably
within a few 100 KB of memory. If you are going over 1 MB you are
seriously doing something wrong. (Obviously that might be acceptable
when I'm actively using it, but otherwise it should keep memory usage as
low as resonably possible).
Good point. I could hack it up in C# in 15 minutes, and it'd be a 32Kb
EXE file. But it'd use 15-20Mb RAM at least, making it completely
unacceptable of course. So that's absolutely an important figure.
//Magnus
On Jun 23, 2007, at 11:06 AM, Magnus Hagander wrote:
I fully agree with the not part of the default installation. And
make it
easy to turn the thing off.In that respect it sound like a good feature for developer systems
(not
servers per se). Just ensure for a small memory footprint, preferably
within a few 100 KB of memory. If you are going over 1 MB you are
seriously doing something wrong. (Obviously that might be acceptable
when I'm actively using it, but otherwise it should keep memory
usage as
low as resonably possible).Good point. I could hack it up in C# in 15 minutes, and it'd be a 32Kb
EXE file. But it'd use 15-20Mb RAM at least, making it completely
unacceptable of course. So that's absolutely an important figure.
For something with such trivial functionality, using your application
framework of choice (C#, Java, MFC, Qt, Delphi) is, however tempting,
not going to be a good fit, for dependency reasons as much as
resource usage.
But it's probably under a couple of hundred lines of c/win32, and
wouldn't be too hard to cobble together.
Cheers,
Steve