Thread: PostgreSQL

PostgreSQL

From
"U.Oeder"
Date:
Are there any future plans to actually make a Windows EXE for
Postgre.SQL which I the basic user can download without me having to
make the EXE on my platform ? Can I run MySQL on any Windows system
95/98/Me/NT/Windows2000/XP ?

If I used PostgreSQL to manage a database that my application connects
to using the BSd license. Must I then give the source code for my
application or distribute my program for free ???
NA,Windhoek
www.filetopia.com
_______________________________________________________________________
Cool Connection, Cool Price, Internet Access for R59 monthly @ WebMail
http://www.webmail.co.za/dialup/

Re: PostgreSQL

From
Al Hulaton
Date:
U.Oeder wrote:

> Are there any future plans to actually make a Windows EXE for
> Postgre.SQL which I the basic user can download without me having to
> make the EXE on my platform ?

Right now, the only way to run community PostgreSQL on Windows is via
cygwin. As you know, cygwin is a unix emulation layer and like most
emulators, there is a performance penalty which is why most of the time
we see such PostgreSQL/cygwin deployments being used in light duty
servers or in development.

There are plans for community PostgreSQL to on Windows, as you'll see in
the link below. They estimate late 2003/early 2004. More info about that
here: http://techdocs.postgresql.org/guides/Windows

The link above also includes links to companies providing windows-native
versions of PostgreSQL.

Given the choice, however, I'd run PostgreSQL on a unix/linux box, but I
understand in some shops there is a hesitancy to install anything but
Microsoft Windows. Whatever the case, you have several options open to you.

Hope this helps.

Best,

Al Hulaton    |  Sr. Account Engineer  |  Command Prompt, Inc.
503.222.2783  |  ahulaton@commandprompt.com
Linux business hosting, PostgreSQL consulting and migration
Read and Search O'Reilly's 'Practical PostgreSQL' at
http://www.commandprompt.com


Re: PostgreSQL

From
Jason Tishler
Date:
On Mon, Aug 11, 2003 at 01:14:38PM +0200, U.Oeder wrote:
> Are there any future plans to actually make a Windows EXE for
> Postgre.SQL which I the basic user can download without me having to
> make the EXE on my platform ?

Pre-built PostgreSQL packages have been part of the standard Cygwin
distribution for years:

    http://cygwin.com/ml/cygwin-announce/2003-08/msg00001.html

> Can I run MySQL on any Windows system 95/98/Me/NT/Windows2000/XP ?

The above is off-topic for this list.

> If I used PostgreSQL to manage a database that my application connects
> to using the BSd license.

The above description is not very clear.

> Must I then give the source code for my application or distribute my
> program for free ???

Note that IANAL, but most likely no.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: PostgreSQL

From
Jason Tishler
Date:
Please keep your replies on-list.

On Tue, Aug 12, 2003 at 03:04:53PM +0200, U.Oeder wrote:
> Sorry about the MySQL stuff in the post , got my messages messed up.
> But while we are on the subject. I don't have to make the interface
> that works/links to the PostgreSQl database engine open source ??? Or
> am I misunderstanding your license ?

First, it is not *my* license.  Second, IANAL (again).  Third, you are
not being very clear (again).

Nevertheless, if you are referring to the Cygwin license:

    http://cygwin.com/licensing.html

then the following is the essence:

    If you distribute binaries linked against the Cygwin DLL, then you
    must also distribute (or at least make available) the corresponding
    source to satisfy the GPL.

Hence, if your code does not link against the Cygwin DLL, then you do
not need to distribute its source.  However, you do need to distribute
the source for PostgreSQL, the Cygwin DLL, and any other (e.g., sh)
Cygwin binary that you distribute.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: PostgreSQL

From
Jason Tishler
Date:
On Wed, Aug 13, 2003 at 07:26:08AM -0400, Jason Tishler wrote:
> Hence, if your code does not link against the Cygwin DLL, then you do
> not need to distribute its source.

Add to be explicit:  If your code does link against the Cygwin DLL, then
you do need to distribute its source.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: PostgreSQL

From
Ian Burrell
Date:
Jason Tishler wrote:
>
> Add to be explicit:  If your code does link against the Cygwin DLL, then
> you do need to distribute its source.
>

It is possible to write PostgreSQL client applications than don't use
the Cygwin DLL and don't need to be open source.  The libpg client
library complies and runs natively under Windows.  A Windows application
can be linked against that library and not need to use Cygwin.  This is
done with the Perl DBD::Pg module.

  - Ian