From: "guyren@relevantlogic.com" <guyren@gmail.com>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_C60C17F2-47FE-4A76-BB35-7C9DFC04CB34"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.500.181\))
Subject: Describing the natural architecture for an internet-facing Postgres
 based app: feedback sought
Message-Id: <4237964E-B88B-4F6B-AD3D-FD67C17ED480@relevantlogic.com>
Date: Tue, 28 Apr 2026 13:24:41 +1000
To: PostgreSQL General <pgsql-general@postgresql.org>
Archived-At: <https://www.postgresql.org/message-id/4237964E-B88B-4F6B-AD3D-FD67C17ED480%40relevantlogic.com>
Precedence: bulk


--Apple-Mail=_C60C17F2-47FE-4A76-BB35-7C9DFC04CB34
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

Coming from a Rails/PHP/etc world. All of those communities generally =
hold that the database should be treated as a dumb data bucket with all =
the logic in the middleware.

I=E2=80=99ve long thought someone should write up what the alternative =
architecture using Postgres to its fullest would look like. In order to =
differentiate it, I start from the security advantages and work forward.

I=E2=80=99d love to get some feedback on it. Harsh criticism is most =
useful=E2=80=A6 :-)

lydb.xyz/zero-authority-architecture =
<https://lydb.xyz/zero-authority-architecture/>=

--Apple-Mail=_C60C17F2-47FE-4A76-BB35-7C9DFC04CB34
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html aria-label=3D"message body"><head><meta http-equiv=3D"content-type" =
content=3D"text/html; charset=3Dutf-8"></head><body =
style=3D"overflow-wrap: break-word; -webkit-nbsp-mode: space; =
line-break: after-white-space;"><span style=3D"font-size: 19px;">Coming =
from a Rails/PHP/etc world. All of those communities generally hold that =
the database should be treated as a dumb data bucket with all the logic =
in the middleware.<br><br>I=E2=80=99ve long thought someone should write =
up what the alternative architecture using Postgres to its fullest would =
look like. In order to differentiate it, I start from the security =
advantages and work forward.<br><br>I=E2=80=99d love to get some =
feedback on it. Harsh criticism is most useful=E2=80=A6 :-)<br><br><a =
href=3D"https://lydb.xyz/zero-authority-architecture/"><font =
color=3D"#157EFB">lydb.xyz/zero-authority-architecture</font></a></span></=
body></html>=

--Apple-Mail=_C60C17F2-47FE-4A76-BB35-7C9DFC04CB34--