From david@fetter.org Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DE1372E2F29 for ; Wed, 5 Mar 2008 10:37:31 -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 35926-06 for ; Wed, 5 Mar 2008 10:37:08 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from fetter.org (start.fetter.org [66.92.188.65]) by postgresql.org (Postfix) with ESMTP id 6B98B2E2F47 for ; Wed, 5 Mar 2008 10:37:15 -0400 (AST) Received: by fetter.org (Postfix, from userid 500) id E0FA6FBCDA6; Wed, 5 Mar 2008 06:37:12 -0800 (PST) Date: Wed, 5 Mar 2008 06:37:12 -0800 From: David Fetter To: PostgreSQL Docs Subject: FAQ on Embedding Postgres Message-ID: <20080305143712.GJ19860@fetter.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/2 X-Sequence-Number: 4814 Folks, I just got yet another question about embedding Postgres in a binary. What should be in the FAQ on this subject? Here's what I have so far: Q: How can I embed PostgreSQL in a binary? A: You can't. PostgreSQL is designed from the ground up to run as a separate set of processes on a server. If you really need to embed an SQL engine in a binary, consider the excellent SQLite for the purpose. Comments? Criticisms? Rotten tomatoes? Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate From bruce@momjian.us Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D1FE62E00C8 for ; Wed, 5 Mar 2008 10:41:33 -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 49847-04 for ; Wed, 5 Mar 2008 10:41:19 -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 35F492E00D1 for ; Wed, 5 Mar 2008 10:41:26 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id m25EfLC16177; Wed, 5 Mar 2008 09:41:21 -0500 (EST) From: Bruce Momjian Message-Id: <200803051441.m25EfLC16177@momjian.us> Subject: Re: FAQ on Embedding Postgres In-Reply-To: <20080305143712.GJ19860@fetter.org> To: David Fetter Date: Wed, 5 Mar 2008 09:41:21 -0500 (EST) CC: PostgreSQL Docs 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/3 X-Sequence-Number: 4815 David Fetter wrote: > Folks, > > I just got yet another question about embedding Postgres in a binary. > What should be in the FAQ on this subject? Here's what I have so far: > > Q: How can I embed PostgreSQL in a binary? > > A: You can't. PostgreSQL is designed from the ground up to run as a > separate set of processes on a server. If you really need to embed an > SQL engine in a binary, consider the excellent > SQLite for the purpose. > > Comments? Criticisms? Rotten tomatoes? Yea, good idea. Let me add it. Thanks. -- Bruce Momjian http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + From dev@archonet.com Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A71682E00EC for ; Wed, 5 Mar 2008 10:58:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 09554-01 for ; Wed, 5 Mar 2008 10:58:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pih-relay08.plus.net (pih-relay08.plus.net [212.159.14.134]) by postgresql.org (Postfix) with ESMTP id 9E3DE2E00E1 for ; Wed, 5 Mar 2008 10:58:37 -0400 (AST) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay08.plus.net with esmtp (Exim) id 1JWv4g-0002n0-Cg; Wed, 05 Mar 2008 14:58:30 +0000 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 3104127404B; Wed, 5 Mar 2008 14:58:30 +0000 (GMT) Message-ID: <47CEB516.7090007@archonet.com> Date: Wed, 05 Mar 2008 14:58:30 +0000 From: Richard Huxton User-Agent: Thunderbird 2.0.0.12 (X11/20080213) MIME-Version: 1.0 To: Bruce Momjian CC: David Fetter , PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres References: <200803051441.m25EfLC16177@momjian.us> In-Reply-To: <200803051441.m25EfLC16177@momjian.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 433f8b04da7ebac2df97c3ac29661fbf X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/4 X-Sequence-Number: 4816 Bruce Momjian wrote: > David Fetter wrote: >> If you really need to embed an >> SQL engine in a binary, consider the excellent >> SQLite or Firebird >> for the purpose. Just to be fair. -- Richard Huxton Archonet Ltd From bruce@momjian.us Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C84752E0218 for ; Wed, 5 Mar 2008 11:02:58 -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 69562-07 for ; Wed, 5 Mar 2008 11:02:37 -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 8E7D72E00EC for ; Wed, 5 Mar 2008 11:02:45 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id m25F2fm03349; Wed, 5 Mar 2008 10:02:41 -0500 (EST) From: Bruce Momjian Message-Id: <200803051502.m25F2fm03349@momjian.us> Subject: Re: FAQ on Embedding Postgres In-Reply-To: <47CEB516.7090007@archonet.com> To: Richard Huxton Date: Wed, 5 Mar 2008 10:02:41 -0500 (EST) CC: David Fetter , PostgreSQL Docs 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/5 X-Sequence-Number: 4817 Richard Huxton wrote: > Bruce Momjian wrote: > > David Fetter wrote: > >> If you really need to embed an > >> SQL engine in a binary, consider the excellent > >> SQLite > > or Firebird > > >> for the purpose. > > Just to be fair. sqlite seems much more appropriate for embedding. -- Bruce Momjian http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + From dev@archonet.com Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6FCA12E0322 for ; Wed, 5 Mar 2008 11:05:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 22896-02 for ; Wed, 5 Mar 2008 11:05:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pih-relay04.plus.net (pih-relay04.plus.net [212.159.14.131]) by postgresql.org (Postfix) with ESMTP id 640182E02BB for ; Wed, 5 Mar 2008 11:05:36 -0400 (AST) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay04.plus.net with esmtp (Exim) id 1JWvBU-0003zu-FN; Wed, 05 Mar 2008 15:05:32 +0000 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id DF51327404B; Wed, 5 Mar 2008 15:05:29 +0000 (GMT) Message-ID: <47CEB6BA.8020503@archonet.com> Date: Wed, 05 Mar 2008 15:05:30 +0000 From: Richard Huxton User-Agent: Thunderbird 2.0.0.12 (X11/20080213) MIME-Version: 1.0 To: Bruce Momjian CC: David Fetter , PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres References: <200803051502.m25F2fm03349@momjian.us> In-Reply-To: <200803051502.m25F2fm03349@momjian.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 8a7645e9995e12e1cf81671a027c800e X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/6 X-Sequence-Number: 4818 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 >>>> SQLite >> or Firebird >> >>>> 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 :-) -- Richard Huxton Archonet Ltd From bruce@momjian.us Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4E6182E02E3 for ; 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 ; 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 ; 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 Message-Id: <200803051509.m25F9cs11343@momjian.us> Subject: Re: FAQ on Embedding Postgres In-Reply-To: <47CEB6BA.8020503@archonet.com> To: Richard Huxton Date: Wed, 5 Mar 2008 10:09:38 -0500 (EST) CC: David Fetter , PostgreSQL Docs 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 > >>>> SQLite > >> or Firebird > >> > >>>> 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 http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + From tgl@sss.pgh.pa.us Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7E8882E0255 for ; Wed, 5 Mar 2008 13:36:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 33809-07 for ; Wed, 5 Mar 2008 13:36:00 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 174882E0325 for ; Wed, 5 Mar 2008 13:35:59 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m25HZrvJ000719; Wed, 5 Mar 2008 12:35:53 -0500 (EST) To: Bruce Momjian cc: Richard Huxton , David Fetter , PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres In-reply-to: <200803051502.m25F2fm03349@momjian.us> References: <200803051502.m25F2fm03349@momjian.us> Comments: In-reply-to Bruce Momjian message dated "Wed, 05 Mar 2008 10:02:41 -0500" Date: Wed, 05 Mar 2008 12:35:53 -0500 Message-ID: <718.1204738553@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/13 X-Sequence-Number: 4825 Bruce Momjian writes: > Richard Huxton wrote: >> Bruce Momjian wrote: > David Fetter wrote: >>> If you really need to embed an >>> SQL engine in a binary, consider the excellent >>> SQLite >> >> or Firebird >> > for the purpose. >> >> Just to be fair. > sqlite seems much more appropriate for embedding. Is it really a good idea to be recommending particular other products? And don't forget that the next thing on that list would be mysql. If we need a FAQ entry on this at all, I'd stop after David's first two sentences. regards, tom lane From david@fetter.org Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1D0522E2DE5 for ; Wed, 5 Mar 2008 13:41:31 -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 80207-09 for ; Wed, 5 Mar 2008 13:41:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from fetter.org (start.fetter.org [66.92.188.65]) by postgresql.org (Postfix) with ESMTP id C37A52E2E08 for ; Wed, 5 Mar 2008 13:41:27 -0400 (AST) Received: by fetter.org (Postfix, from userid 500) id 8D2AFFBCD9C; Wed, 5 Mar 2008 09:41:26 -0800 (PST) Date: Wed, 5 Mar 2008 09:41:26 -0800 From: David Fetter To: Tom Lane Cc: Bruce Momjian , Richard Huxton , PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres Message-ID: <20080305174126.GM19860@fetter.org> References: <200803051502.m25F2fm03349@momjian.us> <718.1204738553@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <718.1204738553@sss.pgh.pa.us> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/14 X-Sequence-Number: 4826 On Wed, Mar 05, 2008 at 12:35:53PM -0500, Tom Lane wrote: > Bruce Momjian writes: > > Richard Huxton wrote: > >> Bruce Momjian wrote: > > David Fetter wrote: > >>> If you really need to embed an > >>> SQL engine in a binary, consider the excellent > >>> SQLite > >> > >> or Firebird > >> > > for the purpose. > >> > >> Just to be fair. > > > sqlite seems much more appropriate for embedding. > > Is it really a good idea to be recommending particular other > products? And don't forget that the next thing on that list would > be mysql. > > If we need a FAQ entry on this at all, I'd stop after David's first > two sentences. Stopping there seems like a very bad idea from a public relations point of view. Making the suggestion generic and naming several FLOSS DBs as an alternative might work better. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate From jd@commandprompt.com Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7B4912E2EDF for ; Wed, 5 Mar 2008 13:49:12 -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 81239-05 for ; Wed, 5 Mar 2008 13:48:52 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id F30C42E2EE3 for ; Wed, 5 Mar 2008 13:48:53 -0400 (AST) Received: from jd-laptop (or-65-40-176-144.dyn.embarqhsd.net [65.40.176.144]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m25HmvWo001114 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 5 Mar 2008 09:48:58 -0800 Date: Wed, 5 Mar 2008 09:48:30 -0800 From: "Joshua D. Drake" To: David Fetter Cc: Tom Lane , Bruce Momjian , Richard Huxton , PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres Message-ID: <20080305094830.1082378e@jd-laptop> In-Reply-To: <20080305174126.GM19860@fetter.org> References: <200803051502.m25F2fm03349@momjian.us> <718.1204738553@sss.pgh.pa.us> <20080305174126.GM19860@fetter.org> Organization: Joshua D. Drake X-Mailer: Claws Mail 3.3.1 (GTK+ 2.12.0; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/ldBNJ3YQldvjI08+Srja5Pp"; protocol="application/pgp-signature"; micalg=PGP-SHA1 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 05 Mar 2008 09:48:59 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/15 X-Sequence-Number: 4827 --Sig_/ldBNJ3YQldvjI08+Srja5Pp Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Wed, 5 Mar 2008 09:41:26 -0800 David Fetter wrote: > Stopping there seems like a very bad idea from a public relations > point of view. Making the suggestion generic and naming several FLOSS > DBs as an alternative might work better. IMO, entries last forever, for years and years even after we fix them. I believe we should make reference that PostgreSQL is not generally considered an embeddable platform and call it good. Sincerely, Joshua D. Drake --=20 The PostgreSQL Company since 1997: http://www.commandprompt.com/=20 PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit --Sig_/ldBNJ3YQldvjI08+Srja5Pp Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHztzuATb/zqfZUUQRAtFwAKCRfLkEy8tuaDw0li28EeBax+iEoQCgpU5G UrDWlTzXgtf/KahBwP577gM= =tzJu -----END PGP SIGNATURE----- --Sig_/ldBNJ3YQldvjI08+Srja5Pp-- From tgl@sss.pgh.pa.us Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 52E442E2F23 for ; Wed, 5 Mar 2008 13:56:13 -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 82703-06-3 for ; Wed, 5 Mar 2008 13:56:08 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id A8E5A2E2F38 for ; Wed, 5 Mar 2008 13:56:06 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m25Hu1i3001030; Wed, 5 Mar 2008 12:56:01 -0500 (EST) To: David Fetter cc: Bruce Momjian , Richard Huxton , PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres In-reply-to: <20080305174126.GM19860@fetter.org> References: <200803051502.m25F2fm03349@momjian.us> <718.1204738553@sss.pgh.pa.us> <20080305174126.GM19860@fetter.org> Comments: In-reply-to David Fetter message dated "Wed, 05 Mar 2008 09:41:26 -0800" Date: Wed, 05 Mar 2008 12:56:01 -0500 Message-ID: <1029.1204739761@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/16 X-Sequence-Number: 4828 David Fetter writes: > On Wed, Mar 05, 2008 at 12:35:53PM -0500, Tom Lane wrote: >> If we need a FAQ entry on this at all, I'd stop after David's first >> two sentences. > Stopping there seems like a very bad idea from a public relations > point of view. Pointing to an alternative product doesn't make that any better. What would make it better is to explain *why* we design PG this way. regards, tom lane From david@fetter.org Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2209F2E0201 for ; Wed, 5 Mar 2008 14:25:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 48233-06 for ; Wed, 5 Mar 2008 14:25:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from fetter.org (start.fetter.org [66.92.188.65]) by postgresql.org (Postfix) with ESMTP id 4D59F2E017F for ; Wed, 5 Mar 2008 14:25:02 -0400 (AST) Received: by fetter.org (Postfix, from userid 500) id DB382FBCDB1; Wed, 5 Mar 2008 10:25:00 -0800 (PST) Date: Wed, 5 Mar 2008 10:25:00 -0800 From: David Fetter To: Tom Lane Cc: Bruce Momjian , Richard Huxton , PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres Message-ID: <20080305182500.GN19860@fetter.org> References: <200803051502.m25F2fm03349@momjian.us> <718.1204738553@sss.pgh.pa.us> <20080305174126.GM19860@fetter.org> <1029.1204739761@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1029.1204739761@sss.pgh.pa.us> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/17 X-Sequence-Number: 4829 On Wed, Mar 05, 2008 at 12:56:01PM -0500, Tom Lane wrote: > David Fetter writes: > > On Wed, Mar 05, 2008 at 12:35:53PM -0500, Tom Lane wrote: > >> If we need a FAQ entry on this at all, I'd stop after David's > >> first two sentences. > > > Stopping there seems like a very bad idea from a public relations > > point of view. > > Pointing to an alternative product doesn't make that any better. > What would make it better is to explain *why* we design PG this way. It's good to explain why PG does what it does how it does it, and that should be in that section of the FAQ, but continuing, even by silence, with an answer equivalent to, "We don't do that. You shouldn't either. Tough $#!+" only makes us look bad, where suggesting alternatives for the use cases we don't cover makes us look good. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate From jd@commandprompt.com Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A4C352E00CF for ; Wed, 5 Mar 2008 14:31:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 51653-02 for ; Wed, 5 Mar 2008 14:31:00 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id A7E932E1BF9 for ; Wed, 5 Mar 2008 14:31:00 -0400 (AST) Received: from jd-laptop (or-65-40-176-144.dyn.embarqhsd.net [65.40.176.144]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m25IVAs8005237 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 5 Mar 2008 10:31:12 -0800 Date: Wed, 5 Mar 2008 10:30:43 -0800 From: "Joshua D. Drake" To: David Fetter Cc: Tom Lane , Bruce Momjian , Richard Huxton , PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres Message-ID: <20080305103043.233761e8@jd-laptop> In-Reply-To: <20080305182500.GN19860@fetter.org> 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> Organization: Joshua D. Drake X-Mailer: Claws Mail 3.3.1 (GTK+ 2.12.0; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/pEdjZjoWtr=4tJSekN=+4J8"; protocol="application/pgp-signature"; micalg=PGP-SHA1 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 05 Mar 2008 10:31:12 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/19 X-Sequence-Number: 4831 --Sig_/pEdjZjoWtr=4tJSekN=+4J8 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Wed, 5 Mar 2008 10:25:00 -0800 David Fetter wrote: > It's good to explain why PG does what it does how it does it, and that > should be in that section of the FAQ, but continuing, even by silence, > with an answer equivalent to, "We don't do that. You shouldn't > either. Tough $#!+" only makes us look bad, where suggesting > alternatives for the use cases we don't cover makes us look good. I believe there is wording that could be used that would not convey that sentiment. Sincerely, Joshua D. Drake >=20 > Cheers, > David. --=20 The PostgreSQL Company since 1997: http://www.commandprompt.com/=20 PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit --Sig_/pEdjZjoWtr=4tJSekN=+4J8 Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHzubTATb/zqfZUUQRAiQnAJ0SBQICWi9VmfN0bZxCd42rA7IFBwCfaiA4 WeevGUtrov1LvWlJ39iPpHc= =SUn4 -----END PGP SIGNATURE----- --Sig_/pEdjZjoWtr=4tJSekN=+4J8-- From jd@commandprompt.com Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8E5782E015C for ; Wed, 5 Mar 2008 14:53:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 58044-04 for ; Wed, 5 Mar 2008 14:53:20 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id A3DD62E0378 for ; Wed, 5 Mar 2008 14:53:20 -0400 (AST) Received: from jd-laptop (or-65-40-176-144.dyn.embarqhsd.net [65.40.176.144]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m25IrY9C007348 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 5 Mar 2008 10:53:35 -0800 Date: Wed, 5 Mar 2008 10:53:07 -0800 From: "Joshua D. Drake" To: "Joshua D. Drake" Cc: David Fetter , Tom Lane , Bruce Momjian , Richard Huxton , PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres Message-ID: <20080305105307.2bcce254@jd-laptop> In-Reply-To: <20080305103043.233761e8@jd-laptop> 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> Organization: Joshua D. Drake X-Mailer: Claws Mail 3.3.1 (GTK+ 2.12.0; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/ANalwU1y89TfYKLRityCExl"; protocol="application/pgp-signature"; micalg=PGP-SHA1 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 05 Mar 2008 10:53:37 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/21 X-Sequence-Number: 4833 --Sig_/ANalwU1y89TfYKLRityCExl Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Wed, 5 Mar 2008 10:30:43 -0800 "Joshua D. Drake" wrote: =20 > I believe there is wording that could be used that would not convey > that sentiment. Such as: PostgreSQL is designed as a client / server architecture and does not normally embed in an optimal way. Discussion of other product solutions to the embedded problem is outside the scope of this document. Sincerely, Joshua D. Drake --=20 The PostgreSQL Company since 1997: http://www.commandprompt.com/=20 PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit --Sig_/ANalwU1y89TfYKLRityCExl Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHzuwTATb/zqfZUUQRAoQEAJsHF3zxaKV1ftlJar+pDwKH+UdhHwCgnGr8 Mw49VyFEqeCsJ8rHsfkg62w= =YuCR -----END PGP SIGNATURE----- --Sig_/ANalwU1y89TfYKLRityCExl-- From alvherre@commandprompt.com Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8B1C72E0DD0 for ; Wed, 5 Mar 2008 15:18:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 67123-03 for ; Wed, 5 Mar 2008 15:18:08 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id B77532E003B for ; Wed, 5 Mar 2008 15:18:08 -0400 (AST) Received: from perhan.alvh.no-ip.org (190-95-27-98.bk17-dsl.surnet.cl [190.95.27.98]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m25JHjiT009543 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 5 Mar 2008 11:18:23 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id D304C47BF8; Wed, 5 Mar 2008 16:17:17 -0300 (CLST) Date: Wed, 5 Mar 2008 16:17:17 -0300 From: Alvaro Herrera To: "Joshua D. Drake" Cc: David Fetter , Tom Lane , Bruce Momjian , Richard Huxton , PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres Message-ID: <20080305191717.GV4755@alvh.no-ip.org> 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> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20080305105307.2bcce254@jd-laptop> User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 05 Mar 2008 11:18:24 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/22 X-Sequence-Number: 4834 Joshua D. Drake wrote: > On Wed, 5 Mar 2008 10:30:43 -0800 > "Joshua D. Drake" wrote: > > > I believe there is wording that could be used that would not convey > > that sentiment. > > Such as: > > PostgreSQL is designed as a client / server architecture and does not > normally embed in an optimal way. Discussion of other product solutions > to the embedded problem is outside the scope of this document. I would suggest something less unfriendly, like "there are other open source databases that that are better suited for embedded usage." -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support From jd@commandprompt.com Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7D15B2E01EF for ; Wed, 5 Mar 2008 15:32:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 69516-03 for ; Wed, 5 Mar 2008 15:32:24 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 6FB312E01E6 for ; Wed, 5 Mar 2008 15:32:24 -0400 (AST) Received: from jd-laptop (or-65-40-176-144.dyn.embarqhsd.net [65.40.176.144]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m25JWacB010851 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 5 Mar 2008 11:32:37 -0800 Date: Wed, 5 Mar 2008 11:32:08 -0800 From: "Joshua D. Drake" To: Alvaro Herrera Cc: David Fetter , Tom Lane , Bruce Momjian , Richard Huxton , PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres Message-ID: <20080305113208.70f8c4a6@jd-laptop> In-Reply-To: <20080305191717.GV4755@alvh.no-ip.org> 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> Organization: Joshua D. Drake X-Mailer: Claws Mail 3.3.1 (GTK+ 2.12.0; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/Z07Mm.l5kFhdZUR3o5UTCMf"; protocol="application/pgp-signature"; micalg=PGP-SHA1 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 05 Mar 2008 11:32:38 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL=0.050 X-Spam-Level: X-Archive-Number: 200803/23 X-Sequence-Number: 4835 --Sig_/Z07Mm.l5kFhdZUR3o5UTCMf Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Wed, 5 Mar 2008 16:17:17 -0300 Alvaro Herrera wrote: > > PostgreSQL is designed as a client / server architecture and does > > not normally embed in an optimal way. Discussion of other product > > solutions to the embedded problem is outside the scope of this > > document. >=20 > I would suggest something less unfriendly, like "there are other open > source databases that that are better suited for embedded usage." >=20 No argument. Joshua D. Drake --=20 The PostgreSQL Company since 1997: http://www.commandprompt.com/=20 PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit --Sig_/Z07Mm.l5kFhdZUR3o5UTCMf Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHzvU6ATb/zqfZUUQRAp8nAJ9d9bSLW3TfTMOkDW8N5yh5X+N8zgCeOVns 5ql2Fxm8ADdxG8i8Sdt4Ngk= =x0LM -----END PGP SIGNATURE----- --Sig_/Z07Mm.l5kFhdZUR3o5UTCMf-- From david@fetter.org Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8C4022E0375 for ; Wed, 5 Mar 2008 15:40:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 70098-10 for ; Wed, 5 Mar 2008 15:40:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from fetter.org (start.fetter.org [66.92.188.65]) by postgresql.org (Postfix) with ESMTP id 80A422E0303 for ; Wed, 5 Mar 2008 15:40:26 -0400 (AST) Received: by fetter.org (Postfix, from userid 500) id D437EFBCF9F; Wed, 5 Mar 2008 11:40:24 -0800 (PST) Date: Wed, 5 Mar 2008 11:40:24 -0800 From: David Fetter To: "Joshua D. Drake" Cc: Tom Lane , Bruce Momjian , Richard Huxton , PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres Message-ID: <20080305194024.GA10390@fetter.org> 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> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20080305105307.2bcce254@jd-laptop> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/24 X-Sequence-Number: 4836 On Wed, Mar 05, 2008 at 10:53:07AM -0800, Joshua D. Drake wrote: > On Wed, 5 Mar 2008 10:30:43 -0800 > "Joshua D. Drake" wrote: > > > I believe there is wording that could be used that would not > > convey that sentiment. > > Such as: > > PostgreSQL is designed as a client / server architecture Good so far. > and does not normally embed in an optimal way. While could be twisted around to be factually true--it's possible to ship a VM as part of a software package, for example--it's at best misleading. Let's just cut the weasel words out. > Discussion of other product solutions to the embedded problem is > outside the scope of this document. As Alvaro said, it should be possible to put this in a positive light. I still think it is good to name a few places to start the research on embedded SQL DBMSs rather than leave people with the feeling of, "It's all up to you from here. Go away." Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate From jd@commandprompt.com Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0BB0A2E0255 for ; Wed, 5 Mar 2008 15:45:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 73497-04 for ; Wed, 5 Mar 2008 15:45:00 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id B89B62E02F2 for ; Wed, 5 Mar 2008 15:45:00 -0400 (AST) Received: from jd-laptop (or-65-40-176-144.dyn.embarqhsd.net [65.40.176.144]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m25JjEks012044 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 5 Mar 2008 11:45:15 -0800 Date: Wed, 5 Mar 2008 11:44:47 -0800 From: "Joshua D. Drake" To: David Fetter Cc: Tom Lane , Bruce Momjian , Richard Huxton , PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres Message-ID: <20080305114447.6527ed40@jd-laptop> In-Reply-To: <20080305194024.GA10390@fetter.org> 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> <20080305194024.GA10390@fetter.org> Organization: Joshua D. Drake X-Mailer: Claws Mail 3.3.1 (GTK+ 2.12.0; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/DYNS5ASfSyCc+DSuqvjErBC"; protocol="application/pgp-signature"; micalg=PGP-SHA1 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 05 Mar 2008 11:45:16 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.043 tagged_above=0 required=5 tests=AWL=0.043 X-Spam-Level: X-Archive-Number: 200803/25 X-Sequence-Number: 4837 --Sig_/DYNS5ASfSyCc+DSuqvjErBC Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Wed, 5 Mar 2008 11:40:24 -0800 David Fetter wrote: =20 > I still think it is good to name a few places to start the research on > embedded SQL DBMSs rather than leave people with the feeling of, "It's > all up to you from here. Go away." Well let's start the +/- +1 on wording -1 on mentioning other products. :) Joshua D. Drake --=20 The PostgreSQL Company since 1997: http://www.commandprompt.com/=20 PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit --Sig_/DYNS5ASfSyCc+DSuqvjErBC Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHzvgvATb/zqfZUUQRAnXVAJ9EyK9PW9N8ggPUJKSx8CMuzPGY/gCeLsem eglDTN0GT5++9pf7fnzkrFw= =dbn9 -----END PGP SIGNATURE----- --Sig_/DYNS5ASfSyCc+DSuqvjErBC-- From gsmith@gregsmith.com Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E3F932E1382 for ; Wed, 5 Mar 2008 20:16:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 06505-03 for ; Wed, 5 Mar 2008 20:16:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id 9010B2E0321 for ; Wed, 5 Mar 2008 20:16:27 -0400 (AST) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m260GQOo011426 for ; Wed, 5 Mar 2008 19:16:26 -0500 (EST) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m260GQ0u011420 for ; Wed, 5 Mar 2008 19:16:26 -0500 (EST) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Wed, 5 Mar 2008 19:16:26 -0500 (EST) From: Greg Smith X-X-Sender: gsmith@westnet.com To: PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres In-Reply-To: <20080305191717.GV4755@alvh.no-ip.org> Message-ID: 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 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/26 X-Sequence-Number: 4838 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 From tgl@sss.pgh.pa.us Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E62642E1714 for ; Thu, 6 Mar 2008 02:25:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 05702-09 for ; Thu, 6 Mar 2008 02:25:38 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id B83532E0297 for ; Thu, 6 Mar 2008 02:25:37 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m266PZ6p011586; Thu, 6 Mar 2008 01:25:35 -0500 (EST) To: Greg Smith cc: PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres In-reply-to: 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> Comments: In-reply-to Greg Smith message dated "Wed, 05 Mar 2008 19:16:26 -0500" Date: Thu, 06 Mar 2008 01:25:35 -0500 Message-ID: <11585.1204784735@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/27 X-Sequence-Number: 4839 Greg Smith writes: > 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 I've got nothing against SQLite. But I am unhappy with the idea of us recommending *any* particular bit of software that is not under our control, especially in a document that is as widespread and hard to update as our FAQ. There are any number of scenarios where we might want to take back such an endorsement, but once made it'll be out there somewhere on the Web until cockroaches rule the earth. There is also the whole class of arguments about "why'd you recommend X and not Y?" that we'd surely get sucked into. Better not to go there in the first place. regards, tom lane From jd@commandprompt.com Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9F9E52E004E for ; Thu, 6 Mar 2008 02:53:45 -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 14723-05 for ; Thu, 6 Mar 2008 02:53:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 4FBE72E007C for ; Thu, 6 Mar 2008 02:53:42 -0400 (AST) Received: from jd-laptop (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m266s3xt004999 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 5 Mar 2008 22:54:04 -0800 Date: Wed, 5 Mar 2008 22:53:34 -0800 From: "Joshua D. Drake" To: Tom Lane Cc: Greg Smith , PostgreSQL Docs Subject: Re: FAQ on Embedding Postgres Message-ID: <20080305225334.4c9aad61@jd-laptop> In-Reply-To: <11585.1204784735@sss.pgh.pa.us> 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> <11585.1204784735@sss.pgh.pa.us> Organization: Joshua D. Drake X-Mailer: Claws Mail 3.3.1 (GTK+ 2.12.0; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/8Mi1T8YCk9Ujk.0r09uADNp"; protocol="application/pgp-signature"; micalg=PGP-SHA1 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 05 Mar 2008 22:54:04 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/28 X-Sequence-Number: 4840 --Sig_/8Mi1T8YCk9Ujk.0r09uADNp Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Thu, 06 Mar 2008 01:25:35 -0500 Tom Lane wrote: > I've got nothing against SQLite. But I am unhappy with the idea of us > recommending *any* particular bit of software that is not under our > control, especially in a document that is as widespread and hard to > update as our FAQ. There are any number of scenarios where we might > want to take back such an endorsement, but once made it'll be out > there somewhere on the Web until cockroaches rule the earth. There > is also the whole class of arguments about "why'd you recommend X and > not Y?" that we'd surely get sucked into. Better not to go there in > the first place. I have to agree. As much as I actually like SQLite the reality is the only thing we can remotely guarantee is the quality of our own software and as Tom says, "cockroaches". I still find articles that I wrote 5 years ago that are not even remotely relevant any longer but I get emails about them. We need to focus the language on and about postgresql and postgresql only. Sincerely, Joshua D. Drake --=20 The PostgreSQL Company since 1997: http://www.commandprompt.com/=20 PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit --Sig_/8Mi1T8YCk9Ujk.0r09uADNp Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHz5TxATb/zqfZUUQRAgRcAJ4mbEIU3ABqFuV4PZ67p2eNDqF1UACffwot aA/HBfpKPSxv/BAQ6BjAUeU= =a4Im -----END PGP SIGNATURE----- --Sig_/8Mi1T8YCk9Ujk.0r09uADNp-- From theo@flame.co.za Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2DC7B2E007C for ; Thu, 6 Mar 2008 02:56:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 13099-05 for ; Thu, 6 Mar 2008 02:56:06 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from flame.co.za (ns.flame.co.za [160.124.170.1]) by postgresql.org (Postfix) with ESMTP id 057FB2E004E for ; Thu, 6 Mar 2008 02:56:05 -0400 (AST) Received: from [192.168.0.138] (unknown [196.209.62.7]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by flame.co.za (Postfix) with ESMTP id 697C9802A0 for ; Thu, 6 Mar 2008 08:54:56 +0200 (SAST) Subject: Re: FAQ on Embedding Postgres From: Theo Kramer Reply-To: theo@flame.co.za To: pgsql-docs@postgresql.org In-Reply-To: <11585.1204784735@sss.pgh.pa.us> 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> <11585.1204784735@sss.pgh.pa.us> Content-Type: text/plain Organization: Flame Computing Enterprises cc Date: Thu, 06 Mar 2008 08:54:23 +0200 Message-Id: <1204786463.2332.11.camel@localhost6.localdomain6> Mime-Version: 1.0 X-Mailer: Evolution 2.10.3 (2.10.3-4.fc7) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/29 X-Sequence-Number: 4841 On Thu, 2008-03-06 at 01:25 -0500, Tom Lane wrote: > Greg Smith writes: > > 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 > > I've got nothing against SQLite. But I am unhappy with the idea of us > recommending *any* particular bit of software that is not under our > control, especially in a document that is as widespread and hard to > update as our FAQ. There are any number of scenarios where we might > want to take back such an endorsement, but once made it'll be out there > somewhere on the Web until cockroaches rule the earth. There is also > the whole class of arguments about "why'd you recommend X and not Y?" > that we'd surely get sucked into. Better not to go there in the first > place. >From a users point of view - both PostgreSQL and other embedable databases aka file handlers I have to agree - suggesting an alternate product might belong in a book but not in a FAQ which is relevant to PostgreSQL and an integral part of the PostgreSQL documentation. -- Regards Theo From singh.gurjeet@gmail.com Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 262AE2E2EFF for ; Thu, 6 Mar 2008 03:14:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 18227-06 for ; Thu, 6 Mar 2008 03:14:37 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from rn-out-0910.google.com (rn-out-0910.google.com [64.233.170.189]) by postgresql.org (Postfix) with ESMTP id BE2E62E1D81 for ; Thu, 6 Mar 2008 03:14:37 -0400 (AST) Received: by rn-out-0910.google.com with SMTP id e11so882934rng.17 for ; Wed, 05 Mar 2008 23:14:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=VHsU+X2b0unQH7R47V/StuRbU3Gv+rff5NdzgbUxIwE=; b=WuHYjNeyh+AS8IkEbLpo6e8OXEk44IeL4mI/d85ZoHA94KkoAAXVj0vSTBbBLOdtz7Y/8S8tRZbICAYUiNQkv01sGoZkM+33/tQHSx200edZ1Egukul0wTnUYoVC9Xka+hYEyj+pw/lIkFZ56tefxF8LJoI6XGOlYobkr0kug48= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=IpLAZElenjm2POjjQZTLlos9ElhYDXkhUbtgf7H/hBST0QmYuwJ91qShkmeWQCdSyeA7c+ctUIwPXHcyO/S3TLz+kQP+zmyrKCvTCTT0U0dpBTvDTtH8j2kBpYcLscP8Vve8clUPxGx/PKJQayDCi2CyhMycFejW3ZFBN7WDB3U= Received: by 10.115.49.16 with SMTP id b16mr6284709wak.65.1204787674934; Wed, 05 Mar 2008 23:14:34 -0800 (PST) Received: by 10.114.102.7 with HTTP; Wed, 5 Mar 2008 23:14:34 -0800 (PST) Message-ID: <65937bea0803052314g792620b0xbdd44e94827357a1@mail.gmail.com> Date: Thu, 6 Mar 2008 12:44:34 +0530 From: "Gurjeet Singh" To: "Tom Lane" Subject: Re: FAQ on Embedding Postgres Cc: "Greg Smith" , "PostgreSQL Docs" In-Reply-To: <11585.1204784735@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7586_8027704.1204787674938" 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> <11585.1204784735@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/30 X-Sequence-Number: 4842 ------=_Part_7586_8027704.1204787674938 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Thu, Mar 6, 2008 at 11:55 AM, Tom Lane wrote: > but once made it'll be out there > somewhere on the Web until cockroaches rule the earth. Hate to deviate away from the topic, but couldn't resist.... sorry. I had watched this episode of Mythbusters, and they have busted the myth that cockroaches will be the last/only survivors of a nuclear holocaust. Here's a link to a portion of that episode. I love the show BTW. http://www.youtube.com/watch?v=3DS-6cIy_s8pQ&feature=3Drelated Best regards, --=20 gurjeet[.singh]@EnterpriseDB.com singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com 17=B0 29' 34.37"N, 78=B0 30' 59.76"E - Hyderabad * 18=B0 32' 57.25"N, 73=B0 56' 25.42"E - Pune 37=B0 47' 19.72"N, 122=B0 24' 1.69" W - San Francisco http://gurjeet.frihost.net Mail sent from my BlackLaptop device ------=_Part_7586_8027704.1204787674938 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Thu, Mar 6, 2008 at 11:55 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
but once made it'll be out there
somewhere on the Web until cockroaches rule the earth.
<= br>Hate to deviate away from the topic, but couldn't resist.... sorry.<= br>
I had watched this episode of Mythbusters, and they have busted the = myth that cockroaches will be the last/only survivors of a nuclear holocaus= t. Here's a link to a portion of that episode. I love the show BTW.

http://www.youtube.com/watch?v=3DS-6cIy_s8pQ&feature=3Drelated<= /a>

Best regards,
--
gurjeet[.singh]@EnterpriseDB.com
sing= h.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB      http://www.enterprisedb.com

17=B0 29' 34.37"N,  = 78=B0 30' 59.76"E - Hyderabad *
18=B0 32' 57.25"N, &nb= sp;73=B0 56' 25.42"E - Pune
37=B0 47' 19.72"N, 122=B0 24' 1.69" W - San Francisco
=
http://gurjeet.frihost.net
Mail sent from my BlackLaptop device ------=_Part_7586_8027704.1204787674938-- From dpage@pgadmin.org Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 407CD2E036E for ; Thu, 6 Mar 2008 04:54:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 63198-10 for ; Thu, 6 Mar 2008 04:54:28 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ti-out-0910.google.com (ti-out-0910.google.com [209.85.142.186]) by postgresql.org (Postfix) with ESMTP id 6A70F2E0367 for ; Thu, 6 Mar 2008 04:54:26 -0400 (AST) Received: by ti-out-0910.google.com with SMTP id y6so2599582tia.5 for ; Thu, 06 Mar 2008 00:54:25 -0800 (PST) Received: by 10.151.42.13 with SMTP id u13mr1783376ybj.107.1204793663602; Thu, 06 Mar 2008 00:54:23 -0800 (PST) Received: by 10.150.96.5 with HTTP; Thu, 6 Mar 2008 00:54:23 -0800 (PST) Message-ID: <937d27e10803060054jedba990t1f03b7af95141e22@mail.gmail.com> Date: Thu, 6 Mar 2008 08:54:23 +0000 From: "Dave Page" To: "Gurjeet Singh" Subject: Re: FAQ on Embedding Postgres Cc: "Tom Lane" , "Greg Smith" , "PostgreSQL Docs" In-Reply-To: <65937bea0803052314g792620b0xbdd44e94827357a1@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <200803051502.m25F2fm03349@momjian.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> <11585.1204784735@sss.pgh.pa.us> <65937bea0803052314g792620b0xbdd44e94827357a1@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/31 X-Sequence-Number: 4843 On Thu, Mar 6, 2008 at 7:14 AM, Gurjeet Singh wrote: > On Thu, Mar 6, 2008 at 11:55 AM, Tom Lane wrote: > > > but once made it'll be out there > > somewhere on the Web until cockroaches rule the earth. > > Hate to deviate away from the topic, but couldn't resist.... sorry. > > I had watched this episode of Mythbusters, and they have busted the myth > that cockroaches will be the last/only survivors of a nuclear holocaust. > Here's a link to a portion of that episode. I love the show BTW. > > http://www.youtube.com/watch?v=S-6cIy_s8pQ&feature=related Now that just sounds plain weird without the voiceover guy that does the Discovery UK edits! -- Dave Page EnterpriseDB UK Ltd: http://www.enterprisedb.com PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk From bruce@momjian.us Wed Jun 3 19:57:24 2026 Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 7DA192E0042 for ; Thu, 24 Apr 2008 16:58:26 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 60391-07 for ; Thu, 24 Apr 2008 16:58:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from momjian.us (momjian.us [70.90.9.53]) by developer.postgresql.org (Postfix) with ESMTP id 79C092E004B for ; Thu, 24 Apr 2008 16:58:21 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id m3OJwEm18743; Thu, 24 Apr 2008 15:58:14 -0400 (EDT) From: Bruce Momjian Message-Id: <200804241958.m3OJwEm18743@momjian.us> Subject: Re: FAQ on Embedding Postgres In-Reply-To: To: Greg Smith Date: Thu, 24 Apr 2008 15:58:14 -0400 (EDT) CC: PostgreSQL Docs 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: 200804/24 X-Sequence-Number: 4884 Added to FAQ as part of item 1.13:

1.13) How does PostgreSQL compare to other DBMSs? Can PostgreSQL be embedded?

...

PostgreSQL is designed as a client/server architecture, which requires separate processes for each client and server, and various helper processes. Many embedded architectures can support such requirements. However, if your embedded architecture requires the database server to run inside the application process, Postgres cannot be used and a lighter-weight database solution should be selected.

--------------------------------------------------------------------------- Greg Smith wrote: > 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 > > -- > Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) > To make changes to your subscription: > http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-docs -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +