Re: serverless postgresql - Mailing list pgsql-general

I have just about the same sort of needs now and concluded that postgres
just is not suited for embedding into apps like that.  I am going with
sqlite and it is working fairly well.  We just made user defined functions
in php for sqlite to match the date functions in postgres.  Who knows what
other issues we may run into but so far sqlite is working fairly well.

I think that sqlite stores everything as a string but for searching,
sorting, ordering etc it uses the type info.

I to would absolutely love to just include a postgres dll and have postgres
in process and just store everything in a nice little file but from what I
have read hear that would involve major changes that the developers on not
interested in making.  So far sqlite has done the job for me.

Also I am considering looking into firebird for an embedded database
solution since it can you pretty much what you are talking about here with
an in proccess db that uses a single file to store it's data.  While I don't
want to switch my server stuff to it, it is probably more full featured than
sqlite (I'm sure it has date and arithmatic functions) and is made to work
well in embedded situations.

I would be intersted to see what you end up doing.

Rick

----- Original Message -----
From: "Jeff Bowden" <jlb@houseofdistraction.com>
To: "pgsql-general" <pgsql-general@postgresql.org>
Sent: Tuesday, January 13, 2004 2:38 PM
Subject: [GENERAL] serverless postgresql


> For ease of configuration and other reasons, I would like for my
> single-user GUI app to be able to use postgresql in-process as a library
> accessing a database created in the users home directory.  I think I
> could possibly get what I want by launching a captive copy of postmaster
> with appropriate args but it seems conceptually cleaner to not have a
> seperate process at all.  Has anyone tried to do anything like this?
>
> I've looked at sqlite and it might be workable for my project but I
> would prefer the more standard and featureful SQL of postgres.  In
> particular sqlite lacks date arithmetic and has some funny type issues
> (it claims to be typeless, except when it isn't, or something).
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>