public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Greg Smith <[email protected]>
Cc: PostgreSQL Docs <[email protected]>
Subject: Re: FAQ on Embedding Postgres
Date: Thu, 24 Apr 2008 15:58:14 -0400 (EDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
Added to FAQ as part of item 1.13:
<H3 id="item1.13">1.13) How does PostgreSQL compare to other
<SMALL>DBMS</SMALL>s? Can PostgreSQL be embedded?</H3>
...
<P>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.</P>
---------------------------------------------------------------------------
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 [email protected] http://www.gregsmith.com Baltimore, MD
>
> --
> Sent via pgsql-docs mailing list ([email protected])
> To make changes to your subscription:
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-docs
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
view thread (24+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: FAQ on Embedding Postgres
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox