Re: EMBEDDED PostgreSQL

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                                                                                                          
                                                  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!