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@xxxxxxxxx To: pgsql-general@xxxxxxxxxxxxxx
uk> cc:
Sent by: Subject: 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!
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
