Re: EMBEDDED PostgreSQL

From: Richard_D_Levine(at)Raytheon(dot)com
To: Tope Akinniyi <topeakinniyi(at)yahoo(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-general-owner(at)postgresql(dot)org
Subject: Re: EMBEDDED PostgreSQL
Date: 2005-01-25 13:45:09
Message-ID: OF7E81244A.482D13A7-ON05256F94.004AC6E7@ftw.us.ray.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)yahoo(dot)co(dot) To: pgsql-general(at)postgresql(dot)org
uk> cc:
Sent by: Subject: [GENERAL] EMBEDDED PostgreSQL
pgsql-general-owner(at)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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vincenzo Ciancia 2005-01-25 13:48:08 Re: Validating user-input to be inserted in regular expressions
Previous Message Christopher Browne 2005-01-25 13:44:13 Re: EMBEDDED PostgreSQL