On Tue, 2005-05-03 at 07:53, Robin Boerdijk wrote:
> Hi,
>
> Apologies if this has been discussed before, but I was wondering if
> there have been any efforts in the past to provide a deep integration
> of PostgreSQL with Apache. What I mean by deep integration is that the
> PostgreSQL server logic runs inside the Apache server processes, rather
> than separate processes. In particular, the postmaster server logic
> would run inside the Apache master process and the postgres server
> logic would run inside Apache child processes.
>
> The main advantage of this approach would be that it avoids the
> Apache/PostgreSQL context switch when executing SQL requests from the
> web server. It looks like the Apache server and PostgreSQL server
> architectures are quite similar to make this feasible. Any thoughts?
And a single crashed or corrupted apache thread or process can trash
your database.
Connection pooling is generally a better answer to this type of
problem. PostgreSQL just isn't designed to be embedded into other
people's code. SQLLite, on the other hand, might be a good option for
such a project.