
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)

????


Mon, 8 Sep 2003 22:37:25 +0200 (CEST)
ivan <iv@psycho.pl>
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

08 Sep 2003 16:41:18 -0400
Doug McNaught <doug@mcnaught.org>
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



Mon, 08 Sep 2003 17:01:38 -0400
Andrew Dunstan <andrew@dunslane.net>
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

Mon, 08 Sep 2003 17:29:10 -0400
Tom Lane <tgl@sss.pgh.pa.us>
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.



Tue, 9 Sep 2003 08:06:57 +0200 (CEST)
Czuczy Gergely <phoemix@harmless.hu>
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:

> 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
>

Tue, 9 Sep 2003 22:36:42 +0200 (CEST)
ivan <iv@psycho.pl>
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



Mon, 15 Sep 2003 11:09:17 +0200
=?ISO-8859-1?Q?Gerhard_H=E4ring?= <lists@ghaering.de>
Re: pgsql in shared lib