The age-old debate of server-side logic and stored procedures

The podcast episode delves into the long-standing debate surrounding the use of server-side logic and stored procedures in databases. The hosts discuss their own experiences with different platforms, noting that stored procedures were more commonly used in SQL 7 Oracle than in Postgres. They acknowledge the divided opinions on the topic, with some people advocating for the convenience and efficiency of stored procedures, while many others express concerns and prefer to avoid them. They also touch upon the importance of transaction control and the necessity of maintaining data consistency in databases.