Thread: Good overview of programming IN Postgres?

Good overview of programming IN Postgres?

From
Guyren Howe
Date:
Is there a good overview of programming WITHIN Postgres? Not writing code in client languages that communicates WITH Postgres, but how to take full advantage of Postgres’ unique programming features — the advanced type system, the various PL languages, triggers, stored procedures, functions, …

I’m thinking both how all those things work, but also how to think about effective architectures given that design palette.

The Postgres documentation is great and is the ultimate reference, but is there a good overview for someone who wants to take best advantage of all these features?

Thinking if there isn’t such a thing that I might write it. But I don’t want to duplicate effort.

Re: Good overview of programming IN Postgres?

From
Joshua Kacsir
Date:
Guyren,

On Tue, Jan 30, 2024 at 12:19 AM Guyren Howe <guyren@gmail.com> wrote:
Is there a good overview of programming WITHIN Postgres? Not writing code in client languages that communicates WITH Postgres, but how to take full advantage of Postgres’ unique programming features — the advanced type system, the various PL languages, triggers, stored procedures, functions, …

While it uses Postgres 11 for its basis (though it looks like an update for 15 is in-progress), I find The Art of PostgreSQL by Dimitri Fontaine (https://theartofpostgresql.com/) to be an excellent discussion for "Postgres-First" development. Would recommend studying the release notes for the versions of Postgres released after 11 to catch up on all the improvements / new features added since it was written.

Best Regards,

Joshua Kacsir

--
Joshua Kacsir
Data Architect

[This email was written *without* the assistance of LLMs]