From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Andrej <andrej.groups@gmail.com>,
 Dimitri Fontaine <dimitri@2ndquadrant.fr>,
	c k <shreeseva.learning@gmail.com>,
	Chris Travers <chris.travers@gmail.com>,
	Scott Marlowe <scott.marlowe@gmail.com>,
	pgsql-general@postgresql.org, sad@bestmx.ru
Subject: Re: Using Postgresql as application server
Organization: 2ndQuadrant
References: 
 <CAN2Y=uPjF14F5A9JXj02_vaPw4TMR0WGQid_w80xt4sC8o4qGg@mail.gmail.com>
	<4E46D0D7.3090700@officenet.no>
	<CAHyXU0xQp+-sA6-oPJVTYaFBYO_R4P=fnX+jm8Pgy_j0rPcO7Q@mail.gmail.com>
	<4E49B47E.8020401@ringerc.id.au>
	<CAHyXU0y16H=ywZ+2hRowXZ4GK-YGdmh-E2y+FDAeubx=cTPMvw@mail.gmail.com>
	<CAOR=d=0XN6Wrueh8rhE=X+Jb-MMPhy2kbfteMmprxMiNvuCLPg@mail.gmail.com>
	<CAKt_ZftbUeUPycofs1dqRbTvvqowi5_wA-7H1mdCa+kM_412tg@mail.gmail.com>
	<CAHyXU0z3H8gEXBXu9XE7sRqBUe=8HydTnvWkieprwmA1DGrbeg@mail.gmail.com>
	<CAKt_Zfsrm+TUd8qR=+q91_Zbvb2TKP0ghxjdu4D8N7Q2ep8Y5w@mail.gmail.com>
	<CAHyXU0zCRh1qxqwYEnaKDzudFfFgma54YidhKw1_d_c09DyL4w@mail.gmail.com>
	<CAKt_Zfv-B5TVYD16z9jTzviJXeah5-HCsCSBEXFec5LJ4sf_xQ@mail.gmail.com>
	<CAHyXU0yiUJM0V-1FyqZ0UMBc8cVtba9MBLwHNmsQSnSkSTuYLA@mail.gmail.com>
	<CAKt_ZfsV67rZfFVdFpxwfQ8Z5vQYLn639K6YfossGYxY6kE9Fw@mail.gmail.com>
	<CAN2Y=uOGSs7-fWTWLRawnnGD762EFFey0G2xvmiLu+e+VLe3rg@mail.gmail.com>
	<87d3g3807x.fsf@hi-media-techno.com>
	<CAHyXU0xV8OctzyK_nCLewBEsqOXZN8BOTvhyHRZcDCo3qewJqw@mail.gmail.com>
	<CACMx3pMUQBmnoGYKQykCuNBfRi6jRm8Vqtpg5E44FkqLEjDZ9A@mail.gmail.com>
	<CAHyXU0z2Fa_Mxe9C4D1G-+qLxpsFRv0uZbWc-To0F4q+7FDTfQ@mail.gmail.com>
User-Mail-Address: dimitri@2ndQuadrant.fr
Date: Sun, 28 Aug 2011 19:09:41 +0200
In-Reply-To: 
 <CAHyXU0z2Fa_Mxe9C4D1G-+qLxpsFRv0uZbWc-To0F4q+7FDTfQ@mail.gmail.com>
	(Merlin Moncure's message of "Sun, 28 Aug 2011 10:13:52 -0500")
Message-ID: <m2zkit5up6.fsf@2ndQuadrant.fr>
User-Agent: Gnus/5.110018 (No Gnus v0.18) Emacs/24.0.50 (darwin)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


[edited]

Merlin Moncure <mmoncure@gmail.com> writes:
>>>> =C2=A0http://asmith.id.au/mod_libpq.html
>> http://asmith.id.au/source/mod_libpq2.c
>
> node.js is even thinner.
>
> node.js is single threaded and 100% asynchronous which fits very nice
> with libpq which is at heart a single threaded asynchronous library.

Sure.  Elnode shares this design, and yaws more seriously so.  I
wouldn't pick mod_libpq myself.

  http://nic.ferrier.me.uk/blog/2010_10/elnode
  http://yaws.hyber.org/

Just saying that the thin web server layer that directly hands the
request to the database has been existing in PostgreSQL land for a long
time already, no need to resort to other proprietary architectures here.

Regards,
--=20
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support