Generally you should use stored procedures when it will reduce the number of round trips to the database. Wrapping simple SELECT statements in a stored proc just adds friction for updating the application especially as the number of developers grows.
On Wed, Aug 6, 2025, 8:04 AM Simon Connah <si...@connah.dev> wrote: > Hi, > > I'm pretty new to PostgreSQL and am building a simple website with it. > > My main question is whether I should use stored procedures / functions > or whether I should embed raw SQL queries in my backend? I understand > that procedures are faster as it cuts down on the round trip speed and > the database can optimise it better. > > On the other hand raw SQL is much easier to manage as you just change > the query in your bankend code without having to apply changes to the > database at deployment time of your backend. > > What is considered the best approach? My backend is written in Go if > that makes a difference. > > If you need any additional information then please let me know. > > Simon. > > >
