Re: EMBEDDED PostgreSQL - Mailing list pgsql-general

From Richard_D_Levine@Raytheon.com
Subject Re: EMBEDDED PostgreSQL
Date
Msg-id OF7E81244A.482D13A7-ON05256F94.004AC6E7@ftw.us.ray.com
Whole thread Raw
In response to EMBEDDED PostgreSQL  (Tope Akinniyi <topeakinniyi@yahoo.co.uk>)
Responses Re: EMBEDDED PostgreSQL
List pgsql-general
Do you need something from PostgreSQL that Firebird doesn't have?  My
experience has been that Firebird/Interbase is a fairly complete, ACID
compliant, low/no maintenance back end for single workstation applications.

On the other hand, you can make any RDBMS into an embedded database with
enough behind the scenes scripting, cron jobs, etc.  The autovacuum feature
is a big help in the regard.  You can tune once, deploy many times.  You
can throw away anything you don't need to make smaller distribution media.

I've done this with Oracle, believe it or not, including automatic
replication when two workstations see each other on the LAN.  I've haven't
had a chance to try it with PostgreSQL because no customer has accepted a
proposal yet.  If it can be done with Oracle, it can be done with
PostgreSQL.

Rick



                     
                      Tope Akinniyi
                     
                      <topeakinniyi@yahoo.co.        To:       pgsql-general@postgresql.org
                     
                      uk>                            cc:
                     
                      Sent by:                       Subject:  [GENERAL] EMBEDDED PostgreSQL
                     
                      pgsql-general-owner@pos
                     
                      tgresql.org
                     

                     

                     
                      01/25/2005 07:21 AM
                     

                     

                     




Hi,

If I may ask, is there any plan for embedded PostgreSQL database as we have
it in Firebird database?  In Firebird embedded a compact engine of the
database that can only accept connections from localhost (127.0.0.1) and
easily distributable with single user applications exists.

Any plan for such?


ALL-NEW Yahoo! Messenger - all new features - even more fun!







pgsql-general by date:

Previous
From: Alex Turner
Date:
Subject: Re: Object Relational, Foreign Keys and Triggers
Next
From: Vincenzo Ciancia
Date:
Subject: Re: Validating user-input to be inserted in regular expressions