Dear all,

Here are some issues:

1) PostgreSQL installer (wizard)

http://www.networksimplicity.com/openssh has released an OpenSSH minimal 
Cygwin installer. They have had 300.000 tracked downloads so far. If true, 
this numer is superior to Cygwin downloads itself.

The installer is incompatible with Cygwin (as it installs a minimal Cygwin 
layer). They also provide a minimal configuration GUI.Is this the solution?

I got in contact with the installer maintainer to ask the cons/pros of such a 
solution v.s. a pure Cygwin layer.

For the moment, I still agree the solution is to create a wizard in pgAdmin2

2) My current work is stopped

For the moment, I am too bust to work on pgAdmin2. This might last 1 or 2 
weeks. Here is my personal to-do list. Feel free to pick-up any issue  :
- Handle two separate connexions (one for schema, another for data queries). 
The user should be able to define client_encoding for each connexion.
- Work on PostgreSQL wizard.
- Refine pseudo-alter trigger code (it was removed because unfinished).
- Add pseudo ALTER DROP COLUM (this should not be difficult using pgSchema).

I will be back soon with plenty of time.

3) KDE3 is marvelous
I now use KDE3 which is a perfect environment. I tried writing some code in 
kDevelop. It seems possible to write code fast... Therefore I am still asking 
myself ***why***we should continue develop pgAdmin on Windows...

To my humble opinion, KDE needs a real database abstraction layer (like 
pgSchema) with a multi-vendor interface. The only solution today is Gnome 
libgda. Unfortunately, libgda is not well-written. A good abstraction layer 
needs inheritence (C++, not C) and XML to handle specfic features of each 
database provider. 

Secondly, KDE3, Konqueror and KDevelop would probably welcome a pgAdmin port. 
This would immediatly give us hundred thousands of users. So why bother with 
Windows?

Thirdly, qt3 applications can be compiled under Windows. And KDE3 is beeing 
ported to Windows using Cygwin. You can be sure it is not a year before we 
can use KDE3 under WIndows and MacOSX.

Last of all, Microft is like a desease: if we do not fight them now, it will 
continue growing. So why work for them under Windows?

Cheers,
Jean-Michel


Fri, 12 Apr 2002 09:25:46 +0200
Jean-Michel POURE <jm.poure@freesurf.fr>
Various issues
> To my humble opinion, KDE needs a real database abstraction layer (like
> pgSchema) with a multi-vendor interface. The only solution today is Gnome
> libgda. Unfortunately, libgda is not well-written. A good
> abstraction layer
> needs inheritence (C++, not C) and XML to handle specfic features of each
> database provider.

Not quite true.  QT3 that KDE3 is based on has full database support.  It
supports MySQL, Postgres and ODBC I think.

As for KDE DB admin software:

apps.kde.com , search for 'postgres'.  There's at least 4 frontends already
in progress...

Chris


Fri, 12 Apr 2002 15:55:39 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: Various issues
Jean-Michel POURE wrote:
> 
> Dear all,
> 
> Here are some issues:
> 
 
> 3) KDE3 is marvelous
> I now use KDE3 which is a perfect environment. I tried writing some code in
> kDevelop. It seems possible to write code fast... Therefore I am still asking
> myself ***why***we should continue develop pgAdmin on Windows...
> 
> To my humble opinion, KDE needs a real database abstraction layer (like
> pgSchema) with a multi-vendor interface. The only solution today is Gnome
> libgda. Unfortunately, libgda is not well-written. A good abstraction layer
> needs inheritence (C++, not C) and XML to handle specfic features of each
> database provider.

Just as a sidenote... have you checked hk_classes, 
(http://hk-classes.sourceforge.net/)?
Moreover, latest TOra version seems to support PostgreSQL thru QT
SQL plugins, at least to some extents...
I would really like to see a complete PostgreSQL admin interface
in KDE... :-)
Best regards
Andrea Aime

Fri, 12 Apr 2002 09:57:38 +0200
"Andrea Aime" <aaime@comune.modena.it>
Re: Various issues