Rhys Stewart from Auchindown brings us 'The PRAM Stack in Production'.

The database is the application. This is my very opinionated take on backend programming. I discuss running Livewire (see https://lvwr.io/), a SoftwareasaService used by distribution engineers in electric utility companies to provide visibility to, and answers for the relevant questions they may have about the network. It also calculates reliability metrics such as SAIDI & SAIFI and does up and downstream energy traces on one or more phases. But this talk is not about what Livewire does or how useful it is. Instead I'm going to wax lyrical about building and running it on the PRAM stack along with pgrouting and using Postgrest as a very thin, but capable layer between the browser and the database. How feasible is doing everything in the database? Is it sustainable? can anyone do it? What about tests? How do you do versioning? And of course the question on everyone's mind: Will it scale? (Hopefully no one asks if it is Web Scale) Whereas my 2021 presentation, Hurricane Prediction Accuracy Analysis Using the PRAM Stack, was a whimsical take on Doing Everything in the Database (DEITDB), this is less so, as it involves customers and money.

This is the direct successor to that 2021 talk and a spiritual successor to Brian Timoney's 2022 presentation: "Skating to Where The Puck Is Going To Be: Why SQL is the Future of Full Stack Analytics."

See also Rhys' PostGIS functions videos at    • PostGIS Function of the Week  .