PostgREST: Providing HTML Content Using Htmx

Re:PostgREST: Providing HTML Content Using Htmx by haolez on Monday December 18, 2023 @08:43PM (#38690801)

I've gone down this road before and that's not what I would criticize.

Where things went south for me:

- hard to hire developers that know how to work with this or that are willing to learn

- very hard to debug performance issues

- version control gets weird, since migrations are not really meant for functions and procedures (although Pyrseas[0] helped a lot)

[0] https://pyrseas.readthedocs.io/en/latest/

[ Parent | on HN ]

Re:PostgREST: Providing HTML Content Using Htmx by jonahx on Monday December 18, 2023 @09:51PM (#38691212)

Is it possible to capture changes in git somehow? If not what did you do?

[ Parent | on HN ]

Re:PostgREST: Providing HTML Content Using Htmx by akoboldfrying on Tuesday December 19, 2023 @02:57AM (#38693020)

I smell a startup opportunity.

[ Parent | on HN ]

Re:PostgREST: Providing HTML Content Using Htmx by haolez on Tuesday December 19, 2023 @06:50AM (#38694462)

I think using Postgres as a runtime would feel like a PaaS runtime not much different from other offerings in the market. But, for something self-hosted, it feels like super powers in the beginning.

[ Parent | on HN ]

Re:PostgREST: Providing HTML Content Using Htmx by haolez on Tuesday December 19, 2023 @06:50AM (#38694469)

I've used git as usual to evolve my SQL functions and procedures and my CI/CD pipeline used Pyrseas to sync code with database.

[ Parent | on HN ]