Thread: pgsql in shared lib

hi,

ist possible to compile postgres (after same small modification) to shared
so, or dll , and usr it like normal postgres , but without any server and
so on. Its whould be work like simple database (with all funciton in one
lib), which dont need any others additionals like (network,other process
etc)

????

ivan <iv@psycho.pl> writes:

> hi,
> 
> ist possible to compile postgres (after same small modification) to shared
> so, or dll , and usr it like normal postgres , but without any server and
> so on.

Not without very major code changes.

-Doug

ivan wrote:

>hi,
>
>ist possible to compile postgres (after same small modification) to shared
>so, or dll , and usr it like normal postgres , but without any server and
>so on. Its whould be work like simple database (with all funciton in one
>lib), which dont need any others additionals like (network,other process
>etc)
>

You apparently want an embedded database. That is really a different class of software. Maybe a good place to start
lookingis at the Berkeley DB stuff at http://www.sleepycat.com
 


cheers

andrew

Doug McNaught <doug@mcnaught.org> writes:
> ivan <iv@psycho.pl> writes:
>> ist possible to compile postgres (after same small modification) to shared
>> so, or dll , and usr it like normal postgres , but without any server and
>> so on.

> Not without very major code changes.

... which are unlikely to happen, given the development community's
strong emphasis on reliability.  An embedded database is inherently less
reliable than a client/server one, since any application bug has the
potential to corrupt the database.  With client/server, at least we only
have to worry about our own bugs ;-)
        regards, tom lane

hello

there is an alternate sql server, designed almost for your needs, it's
name is SQLite. it's a very simple one, but you can statically compile it
into your programs. search sf or freshmeat for it(or google, ofcourse)

Bye,

Gergely Czuczy
mailto: phoemix@harmless.hu
PGP: http://phoemix.harmless.hu/phoemix.pgp

The point is, that geeks are not necessarily the outcasts
society often believes they are. The fact is that society
isn't cool enough to be included in our activities.

Is true, but sometimes programers needgood database engine for simply
program.I think that postgres is one of the best sql db for free and with
open source, but its too much to install server form only one application,
on one workstation . So i thought that there could be the way out , to
build most simple version of postgres to lib(s), its also could be like
porting ??

On Mon, 8 Sep 2003, Tom Lane wrote:

> Doug McNaught <doug@mcnaught.org> writes:
> > ivan <iv@psycho.pl> writes:
> >> ist possible to compile postgres (after same small modification) to shared
> >> so, or dll , and usr it like normal postgres , but without any server and
> >> so on.
>
> > Not without very major code changes.
>
> ... which are unlikely to happen, given the development community's
> strong emphasis on reliability.  An embedded database is inherently less
> reliable than a client/server one, since any application bug has the
> potential to corrupt the database.  With client/server, at least we only
> have to worry about our own bugs ;-)
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

ivan wrote:
> Is true, but sometimes programers needgood database engine for simply
> program.I think that postgres is one of the best sql db for free and with
> open source, [...]

Your current alternatives are:

- Firebird: can be built as an embedded database engine (may be 
experimental)
- MySQL: can be built as an embedded database engine since 4.0
- SQLite: embedded mode only. Very small (ca. 180 kb), but has most 
features you'll ever need. Typelessness is sometimes annoying, though.

-- Gerhard