Date: Wed, 5 Mar 2008 19:16:26 -0500 (EST)
From: Greg Smith <gsmith@gregsmith.com>
To: PostgreSQL Docs <pgsql-docs@postgresql.org>
Subject: Re: FAQ on Embedding Postgres
In-Reply-To: <20080305191717.GV4755@alvh.no-ip.org>
Message-ID: <Pine.GSO.4.64.0803051830040.3352@westnet.com>
References: <200803051502.m25F2fm03349@momjian.us>
	<718.1204738553@sss.pgh.pa.us>
	<20080305174126.GM19860@fetter.org> <1029.1204739761@sss.pgh.pa.us>
	<20080305182500.GN19860@fetter.org> <20080305103043.233761e8@jd-laptop>
	<20080305105307.2bcce254@jd-laptop>
	<20080305191717.GV4755@alvh.no-ip.org>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed

I think it's funny to consider a specific recommendation for SQLite as 
being out of line when you look at the history here.  The whole reason 
that software even exists is because of the difficulty of using PostgreSQL 
in this context.  See http://www.linuxjournal.com/article/6650

With that in mind, after gobbling up a good mix of earlier suggestions 
here and editing a bit I think it's completely reasonable to write this:

"Q:  How can I embed PostgreSQL inside another program?

A:  PostgreSQL is designed with a client/server architecture that makes it 
difficult to embed this way.  There are other open source databases you 
might consider that are better suited for embedded usage, such as SQLite 
which was designed for that purpose."

Now there's no obligation to mention Firebird/MySQL/etc. because that's 
not in fact what they were originally designed for (there's not enough 
angry Derby users to worry about them), and this satisfies the idea I 
support that you give people some idea where they might look instead.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD