Thread: Using PostgresQL as a database back-end

Hello,

    I want to use PostgresQL as a back-end for my program. What I'm looking
for is something similar to sqlite, as in being able to compile a dll/so
and use/call it from my program. Are there any pointers/documentation
that I could use?

AmadeusZ.-

.>     I want to use PostgresQL as a back-end for my program. What I'm looking
> for is something similar to sqlite, as in being able to compile a dll/so
> and use/call it from my program. Are there any pointers/documentation
> that I could use?

Below is a thread that touched on the same subject.  If my memory serves me correctly, the
thread's originator wanted to encapsulate/embed postgresql in a program he was developing.  I
believe the answers to his question were that Postgres was not able to be used this way.  SQLITE
was mentioned as a solution that would support that type of usage.

http://archives.postgresql.org/pgsql-novice/2006-02/msg00136.php

However,  I would recommend getting a second opinion just to be sure.

Regards,

Richard Broersma Jr.

After takin a swig o' Arrakan spice grog, amadeus0@cox.net (Amadeus Zilfinski) belched out:
> Hello,
>
>     I want to use PostgresQL as a back-end for my program. What I'm looking
> for is something similar to sqlite, as in being able to compile a dll/so
> and use/call it from my program. Are there any pointers/documentation
> that I could use?

No, that isn't something you can do with PostgreSQL.  If you
honest-to-goodness *do* need to have a database engine embedded (via
linking in the whole engine) into your application, then SQLite is
probably one of the better options out there.

There hasn't been terribly much interest in making PostgreSQL more
fragile, which would be the concommittant effect of making it
"embeddable like SQLite"...
--
select 'cbbrowne' || '@' || 'gmail.com';
http://linuxdatabases.info/info/lisp.html
NIHIL EX NIHIL -- DON'T SETQ NIL.