Re: Change to PostgreSQL

Hi Richard,

Thanks for your answer. About your comments, in the original order:

1) Thanks for the links. I found in PostgreSQLs FAQ that any one can
use the database for any purpose, including comercial development. But
i couln't find if this applies to the .net driver too.

2) Yes I mean a schema designer. I downloaded a demo from CASE Studio
(http://www.casestudio.com/enu/default.aspx) It looks like a very good
product (also price is ok), but it does not support direct connection
to the database for schema update/synchronization.

3), 4) I guess that's enough. The databases i'm using are in the order
of 100k records and no more than 3 or 4 concurrent users.

Regards,

Felix Beltran

> Richard Huxton <dev(at)archonet(dot)com>
> Sent by: pgsql-general-owner(at)postgresql(dot)org
>
> 10/08/2005 02:23 a.m.
> Tofbeltran(at)cln(dot)megared(dot)net(dot)mx
> ccpgsql-general(at)postgresql(dot)org
> SubjectRe: [GENERAL] Change to PostgreSQL
>
>
>
>
>
>
> Félix Beltrán wrote:
> > Hi all,
> >
> > I'm new to PostgreSQL. I've been working for about two years with
mySQL
> > but i'm evaluating other options (like PostgreSQL) because of lack
of
> > features and a more restrictive licensing model. Right now what i
am
> > looking in PostgreSQL is:
>
> > 1) Free distribution even for non free applications (including .Net
> > driver).
>
> http://www.postgresql.org/about/
> http://www.postgresql.org/docs/faqs.FAQ.html
> http://www.postgresql.org/download/
> http://gborg.postgresql.org/project/npgsql/projdisplay.php
>
> > 2) Is there a good graphical database designer for PostgreSQL wich
also
> > suppors online database synchronization?
>
> Not sure what you mean here. There are a number of graphical clients.
> Were you looking for a schema-designer?
>
> > 3) Easy of management and robust so it needs almost zero
administration
> > (applications suited for non technical users)
>
> Depends how you set it up. End-users shouldn't need to do anything.
>
> > 4) Light enough so it can be used on applications installed in a
single
> > PC.
>
> Depends on the database and the PC. I regularly demonstrate/train on
> systems built using PG/PHP using an old iBook laptop. Handles about a
> dozen users OK, not tried more.
>
> Be aware that most PC disk systems lie about flushing data to disk,
so
> PG can't offer the same guarantee on data integrity that it can with
> SCSI disk systems.
> --
> Richard Huxton
> Archonet Ltd
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>