Skip to content
TrackPodcasts
educationOct 25, 20191:12pending

PostgreSQL example of self-contained stored procedures

Derek Sivers

About this episode

First, see my previous article about PostgreSQL functions at sive.rs/pg. That article gave tiny examples, but no finished working code.

This week, I wrote a shopping cart to sell my books directly from my own site.

So I took a couple extra hours today to put my code into public view, so anyone can play around with it. See github.com/sivers/store, to browse, download, and try it.

It’s a working self-contained shopping cart / store. It’s a very concrete example of using stored procedures to keep all the data logic together in one place. You can use it from JavaScript, Python, Ruby, or any language you want, since all the functionality is in the database itself. It works.

If you have any questions, or want to tell me how stupid I am for doing this, email me.

postgresql logo

Get every episode summarized

Each time Derek Sivers publishes, we email you a written briefing from the transcript — the topics, who appeared, and any specific claims, with the ad reads skipped.

Email me new episodes

Free for 3 shows. No card needed.

Hosts & guests

No transcript yet

This episode has not been transcribed. Request it and it moves to the front of the queue.

PostgreSQL example of self-contained stored procedures

Derek Sivers

0:00
1:12

More episodes

More from Derek Sivers

View all episodes →