Re: embedded/"serverless" (Re: [GENERAL] serverless postgresql)

2004-01-22 Thread Tom Lane
Steve Atkins <[EMAIL PROTECTED]> writes: > [ much snipped ] > Vacuuming and analysing can be handled using the algorithms (and the code, > come to that) from pg_autovacuum. Autovacuum will undoubtedly migrate into the core. I'm not sure how soon, or whether the end result will look much like the

Re: embedded/"serverless" (Re: [GENERAL] serverless postgresql)

2004-01-22 Thread Steve Atkins
On Thu, Jan 22, 2004 at 01:04:29PM -0700, Rick Gigger wrote: [PostgreSQL ill-suited to embedded use] > How about the following comment from an earlier post: > > > Now, while I think that an embedded fork of PostgreSQL is completely > > missing the point I do think that a low maintenance fork or

Re: embedded/"serverless" (Re: [GENERAL] serverless postgresql)

2004-01-22 Thread Rick Gigger
> "Rick Gigger" <[EMAIL PROTECTED]> writes: > >> All of this explains why an embedded PostgreSQL isn't a great idea. It > >> being a true multi-user database means that even if you went though > >> all the work needed to turn it into an embedded database you wouldn't > >> get most of the advantages

Re: embedded/"serverless" (Re: [GENERAL] serverless postgresql)

2004-01-22 Thread Tom Lane
"Rick Gigger" <[EMAIL PROTECTED]> writes: >> All of this explains why an embedded PostgreSQL isn't a great idea. It >> being a true multi-user database means that even if you went though >> all the work needed to turn it into an embedded database you wouldn't >> get most of the advantages. > Is it

Re: embedded/"serverless" (Re: [GENERAL] serverless postgresql)

2004-01-21 Thread Nigel J. Andrews
On Wed, 21 Jan 2004, Andrew Sullivan wrote: > On Wed, Jan 21, 2004 at 11:23:40AM -0700, Rick Gigger wrote: > > > > Yes but sometimes an enterprise level application may need to be put on a > > laptop and taken off-line. Having an embedded database that is compatible > > with the one on the serve

Re: embedded/"serverless" (Re: [GENERAL] serverless postgresql)

2004-01-16 Thread David Garamond
Chris Ochs wrote: I still have to respectfully disagree. Postgresql is IMO just the wrong software for the job, and given that there are still a number of really important things that postgresql lacks, it should concentrate on those.I am not against it however for technical reasons, because th

Re: embedded/"serverless" (Re: [GENERAL] serverless postgresql)

2004-01-16 Thread Chris Ochs
I still have to respectfully disagree. Postgresql is IMO just the wrong software for the job, and given that there are still a number of really important things that postgresql lacks, it should concentrate on those.I am not against it however for technical reasons, because those things can alw

Re: embedded/"serverless" (Re: [GENERAL] serverless postgresql)

2004-01-16 Thread Jeff Bowden
Nigel J. Andrews wrote: On Fri, 16 Jan 2004, Jeff Bowden wrote: So maybe this is a packaging issue. On Debian when I install postgres it is necessary to do root shit in order to enable non-priveledged users to create and destroy databases. My understanding has alwasy been that these operat

Re: embedded/"serverless" (Re: [GENERAL] serverless postgresql)

2004-01-16 Thread Nigel J. Andrews
On Fri, 16 Jan 2004, Jeff Bowden wrote: > Tom Lane wrote: > > >Jeff Bowden <[EMAIL PROTECTED]> writes: > > > > > >>Still, the main problem I, and I suspect others, would like to solve is > >>installation/configuration. For my app I don't want the user to have to > >>understand anything about

Re: [GENERAL] serverless postgresql

2004-01-15 Thread Paul Ganainm
[EMAIL PROTECTED] says... > > That makes sense to me. I wonder if sqlite suffers for this problem > > (e.g. app crashing and corrupting the database). > Likely. I can tell you that Ann Harrison once told me she made a decent > amount of money as a consultant fixing broken Interbase/Firebi

Re: [GENERAL] serverless postgresql

2004-01-15 Thread Jonathan Bartlett
> Do the developers generally oppose the idea of a threaded (but > non-embedded) backend as well? If the backend is thread-safe, then users > can still choose to run multiprocess or multithreaded right? I've been under the impression that the developers were opposed to a threaded server because of

Re: [GENERAL] serverless postgresql

2004-01-14 Thread David Garamond
Tom Lane wrote: Jeff Bowden <[EMAIL PROTECTED]> writes: That makes sense to me. I wonder if sqlite suffers for this problem (e.g. app crashing and corrupting the database). Likely. I can tell you that Ann Harrison once told me she made a decent amount of money as a consultant fixing broken Inte

Re: [GENERAL] serverless postgresql

2004-01-14 Thread David Garamond
Rick Gigger wrote: I have just about the same sort of needs now and concluded that postgres just is not suited for embedding into apps like that. Why not? It's not that the PostgreSQL backend is a mammoth like Oracle. The Firebird embedded version is pretty much the same as their server, but wi

embedded/"serverless" (Re: [GENERAL] serverless postgresql)

2004-01-14 Thread David Garamond
Jeff Bowden wrote: 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 postmast

Re: [GENERAL] serverless postgresql

2004-01-14 Thread Doug McNaught
"Rick Gigger" <[EMAIL PROTECTED]> writes: > Anyway since postgres uses WAL files to verify the integrity of the database > couldn't it more or less make the same guarantee's in an embedded version? > As long as the app uses the db libs unmodified and doesn't mess with the > files it creates how do

Re: [GENERAL] serverless postgresql

2004-01-14 Thread Rick Gigger
> Jeff Bowden <[EMAIL PROTECTED]> writes: > > That makes sense to me. I wonder if sqlite suffers for this problem > > (e.g. app crashing and corrupting the database). > > Likely. I can tell you that Ann Harrison once told me she made a decent > amount of money as a consultant fixing broken Interb

Re: [GENERAL] serverless postgresql

2004-01-13 Thread Jeff Bowden
Tom Lane wrote: Jeff Bowden <[EMAIL PROTECTED]> writes: What about the notion of running postmaster on-demand as the user? Possibly. You'd have to think carefully about what conditions the postmaster should be shut down under, and especially what conditions it should NOT be shut down unde