pgsql in shared lib

Started by ivanover 22 years ago7 messages
#1ivan
iv@psycho.pl

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)

????

#2Doug McNaught
doug@mcnaught.org
In reply to: ivan (#1)
Re: pgsql in shared lib

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

#3Andrew Dunstan
andrew@dunslane.net
In reply to: ivan (#1)
Re: pgsql in shared lib

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 looking is at the Berkeley DB stuff at http://www.sleepycat.com

cheers

andrew

#4Tom Lane
tgl@sss.pgh.pa.us
In reply to: Doug McNaught (#2)
Re: pgsql in shared lib

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

#5Czuczy Gergely
phoemix@harmless.hu
In reply to: ivan (#1)
Re: pgsql in shared lib

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.

#6ivan
iv@psycho.pl
In reply to: Tom Lane (#4)
Re: pgsql in shared lib

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:

Show quoted text

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

#7Gerhard Häring
lists@ghaering.de
In reply to: ivan (#6)
Re: pgsql in shared lib

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