SFPUG June: Build Your App Inside Postgres

Topic: Stored procedures vs. Java/Ruby/Python/Go

Presenter: Leon Starr

Host: Justin.TV (http://justin.tv) / Twitch.TV
1 Kearney Building
(who are hiring!)

Leon Starr has built a full featured open source Executable UML model editor entirely in plpgsql. WHY? Leon presents the case for building a tightly constrained schema and letting the RDBMS do the heavy logic lifting. Code patterns will be presented where object and db principles are intertwined with an eye toward deriving the best of both worlds. Naturally, plpgsql has its limitations as does the presenter who is relatively new to the language. You are invited to poke fun at his novice coding techniques and weigh in with your experiences and thoughts regarding the appropriateness of stored procedures vs. conventional code.