Re: serverless postgresql
От | Rick Gigger |
---|---|
Тема | Re: serverless postgresql |
Дата | |
Msg-id | 01c301c3da26$8768f180$0700a8c0@trogdor обсуждение исходный текст |
Ответ на | serverless postgresql (Jeff Bowden <jlb@houseofdistraction.com>) |
Ответы |
Re: serverless postgresql
(Tom Lane <tgl@sss.pgh.pa.us>)
Re: serverless postgresql (David Garamond <lists@zara.6.isreserved.com>) |
Список | 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 >
В списке pgsql-general по дате отправления: