PostgREST: Providing HTML Content Using Htmx

Re:PostgREST: Providing HTML Content Using Htmx by horusthegame on Monday December 18, 2023 @08:38PM (#38690767)

We've been down this road before. It's neat but not for long term maintenance, support or training as soon as HTMX loses its luster and the, then manager, has to concede the whole thing has to be re-written from scratch.

[ Parent | on HN ]

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 ]

Re:PostgREST: Providing HTML Content Using Htmx by yen223 on Monday December 18, 2023 @10:06PM (#38691309)

I am starting to believe that "system has to be rewritten from scratch in the future" is not nearly the dealbreaker people make it out to be. Especially if it didn't take that much work building the v0 version.

You should almost always rewrite the system in the future, that's just the nature of growth and systems evolution.

[ Parent | on HN ]

Re:PostgREST: Providing HTML Content Using Htmx by potamic on Tuesday December 19, 2023 @12:05AM (#38692045)

https://wiki.c2.com/?PlanToThrowOneAway

[ Parent | on HN ]

Re:PostgREST: Providing HTML Content Using Htmx by cpursley on Tuesday December 19, 2023 @05:08AM (#38693838)

So like nearly every JavaScript framework that comes along?

[ Parent | on HN ]