Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 4E6182E02E3
	for <pgsql-docs-postgresql.org@postgresql.org>;
	Wed,  5 Mar 2008 11:09:50 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 87829-03 for <pgsql-docs-postgresql.org@postgresql.org>;
	Wed,  5 Mar 2008 11:09:34 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from momjian.us (momjian.us [70.90.9.53])
	by postgresql.org (Postfix) with ESMTP id A70F52E0218
	for <pgsql-docs@postgresql.org>; Wed,  5 Mar 2008 11:09:42 -0400 (AST)
Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id
 m25F9cs11343;
	Wed, 5 Mar 2008 10:09:38 -0500 (EST)
From: Bruce Momjian <bruce@momjian.us>
Message-Id: <200803051509.m25F9cs11343@momjian.us>
Subject: Re: FAQ on Embedding Postgres
In-Reply-To: <47CEB6BA.8020503@archonet.com>
To: Richard Huxton <dev@archonet.com>
Date: Wed, 5 Mar 2008 10:09:38 -0500 (EST)
CC: David Fetter <david@fetter.org>,
	PostgreSQL Docs <pgsql-docs@postgresql.org>
X-Mailer: ELM [version 2.4ME+ PL124 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="US-ASCII"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/8
X-Sequence-Number: 4820

Richard Huxton wrote:
> Bruce Momjian wrote:
> > Richard Huxton wrote:
> >> Bruce Momjian wrote:
> >>> David Fetter wrote:
> >>>> If you really need to embed an
> >>>> SQL engine in a binary, consider the excellent
> >>>> <a href="http://www.sqlite.org/">SQLite</a>
> >> or <a href="http://http://www.firebirdsql.org/">Firebird</a>
> >>
> >>>> for the purpose.
> >> Just to be fair.
> > 
> > sqlite seems much more appropriate for embedding.
> 
> It's certainly the lightest DB I'm aware of, but Firebird does have an 
> embedded mode (apparentl - I tend to use a different DB :-)

Right.  The issue with Firebird is it does both embedded and
traditional, while sqlite is only embedded, so is probably a better
choice for that purpose.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +