I think the more accurate translation into modern Postgresql would be to develop as an extension. This should more or less cover same functionalities. One down

I think the more accurate translation into modern Postgresql would be to develop as an extension. This should more or less cover same functionalities. One downside is that you need to be careful around upgrade procedures and backup because postgresql extensions weren't initially developed for persistent data. So you have to declare clearly in the extension definition which table should be backed up and kept when updating the extension. Also if you manage your repo wisely extensions are a great way to version control. I'm currently toying around with a mostly sql app delivered as an extension and so far it's working pretty nicely. But it's a side project and it's not really ready for prime time.