Postgres FM

Stored procedures

Oct 21, 2022
The podcast explores the benefits of using stored procedures in a database, such as data consistency and improved performance. It also discusses the advantages of using Rails or Django for database management and the challenges of working with views and functions in PostgreSQL. The chapter delves into scaling strategies, subtransactions in POSGIS, and the use of stored procedures in database development. Overall, the speakers emphasize the importance of version control, testing, and the potential impact of projects like Superbase and Hasura.
Ask episode
Chapters
Transcript
Episode notes
1
Introduction
00:00 • 4min
2
The Benefits of Using Stored Procedures in a Database
04:04 • 17min
3
Advantages of Using Rails or Django for Database Management
20:58 • 2min
4
Challenges of Working with Views and Functions in PostgreSQL
22:59 • 7min
5
Scaling Up vs Scaling Out and Subtransactions in POSGIS
29:48 • 2min
6
Exploring the Use of Stored Procedures in Database Development
32:06 • 4min