Re: FAQ on Embedding Postgres

От: Bruce Momjian
Тема: Re: FAQ on Embedding Postgres
Дата: ,
Msg-id: 200804241958.m3OJwEm18743@momjian.us
(см: обсуждение, исходный текст)
Ответ на: Re: FAQ on Embedding Postgres  (Greg Smith)
Список: pgsql-docs

Скрыть дерево обсуждения

FAQ on Embedding Postgres  (David Fetter, )
 Re: FAQ on Embedding Postgres  (Bruce Momjian, )
  Re: FAQ on Embedding Postgres  (Richard Huxton, )
   Re: FAQ on Embedding Postgres  (Bruce Momjian, )
    Re: FAQ on Embedding Postgres  (Richard Huxton, )
     Re: FAQ on Embedding Postgres  (Bruce Momjian, )
    Re: FAQ on Embedding Postgres  (Tom Lane, )
     Re: FAQ on Embedding Postgres  (David Fetter, )
      Re: FAQ on Embedding Postgres  ("Joshua D. Drake", )
      Re: FAQ on Embedding Postgres  (Tom Lane, )
       Re: FAQ on Embedding Postgres  (David Fetter, )
        Re: FAQ on Embedding Postgres  ("Joshua D. Drake", )
         Re: FAQ on Embedding Postgres  ("Joshua D. Drake", )
          Re: FAQ on Embedding Postgres  (Alvaro Herrera, )
           Re: FAQ on Embedding Postgres  ("Joshua D. Drake", )
           Re: FAQ on Embedding Postgres  (Greg Smith, )
            Re: FAQ on Embedding Postgres  (Tom Lane, )
             Re: FAQ on Embedding Postgres  ("Joshua D. Drake", )
             Re: FAQ on Embedding Postgres  (Theo Kramer, )
             Re: FAQ on Embedding Postgres  ("Gurjeet Singh", )
              Re: FAQ on Embedding Postgres  ("Dave Page", )
            Re: FAQ on Embedding Postgres  (Bruce Momjian, )
          Re: FAQ on Embedding Postgres  (David Fetter, )
           Re: FAQ on Embedding Postgres  ("Joshua D. Drake", )

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  http://www.gregsmith.com Baltimore, MD
>
> --
> Sent via pgsql-docs mailing list ()
> 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. +


В списке pgsql-docs по дате сообщения:

От: Bruce Momjian
Дата:
Сообщение: Re: FAQ on Embedding Postgres
От: Andy Anderson
Дата:
Сообщение: Backslash Escape Sequences