3 ms·

> I've seen more than one system where the database itself was directly responsible for things like rendering final HTML for use by the end clients. I did this

> I've seen more than one system where the database itself was directly responsible for things like rendering final HTML for use by the end clients. I did this for a side project a few months ago and even used postgrest to serve the page with correct headers for html. It felt simultaneously really cursed and obvious. Shit you could even use plv8 to run mustache or whatever in the db if you really wanted to piss people off.

dventimi 4y ago
I'm doing this right now with a DO droplet built with PostgreSQL, postgrest, nginx, and not much else. Do you have any tips, tricks, or blog posts you can share based on your experience? You should post it to HN. Strike while the iron's hot. With a little luck you'll hit the front page.
- giraffe_lady 4y ago
  Nah nothing that refined. Pretty predictably supabase is doing some weird stuff along these lines and I found some abandoned and semi-active repos associated with them and people working for them that were useful examples of some things. As for posting to HN absolutely no thanks. These people are so fucking hostile there is no accomplishment too small to tear apart for entertainment here. I have no interest in it.
  - dventimi 4y ago
    > As for posting to HN absolutely no thanks. These people are so fucking hostile there is no accomplishment too small to tear apart for entertainment here. I have no interest in it. You make a really good point.
  - kiwicopple 4y ago
    disclosure: supabase ceo plv8 doesn't have network access, but this can be done with PostgREST. That said, we actually restricted the HTML content-type on our platform so that users cannot do this. This is because we don't want to get too deep into the "frontend" world, with ever-changing frameworks. We've found that if we offer a small feature, our users demand feature-completeness. In this case we're better-off waiting until we have solve a few of the major database tasks (branching + migrations, scale-to-zero, edge caching, etc) FWIW, I think it's very cool serving HTML through PostgREST. I would be pretty happy to do this personally
    - dventimi 4y ago
      disclosure: Supabase user Long time user, first time caller. Besides the DO droplet, separately I also use Supabase and I love it. I understand completely about restricting the content type, maybe just for now. Fun fact: I work around it by serving up text/xml plus XSLT. I'm sure you don't mind.
      - kiwicopple 4y ago
        > I work around it by serving up text/xml plus XSLT. I'm sure you don't mind. Not at all, I hear "application/xhtml+xml" is a nice hack from some of the team

dventimi 4y ago

I'm doing this right now with a DO droplet built with PostgreSQL, postgrest, nginx, and not much else. Do you have any tips, tricks, or blog posts you can share based on your experience? You should post it to HN. Strike while the iron's hot. With a little luck you'll hit the front page.

giraffe_lady 4y ago
Nah nothing that refined. Pretty predictably supabase is doing some weird stuff along these lines and I found some abandoned and semi-active repos associated with them and people working for them that were useful examples of some things. As for posting to HN absolutely no thanks. These people are so fucking hostile there is no accomplishment too small to tear apart for entertainment here. I have no interest in it.
- dventimi 4y ago
  > As for posting to HN absolutely no thanks. These people are so fucking hostile there is no accomplishment too small to tear apart for entertainment here. I have no interest in it. You make a really good point.
- kiwicopple 4y ago
  disclosure: supabase ceo plv8 doesn't have network access, but this can be done with PostgREST. That said, we actually restricted the HTML content-type on our platform so that users cannot do this. This is because we don't want to get too deep into the "frontend" world, with ever-changing frameworks. We've found that if we offer a small feature, our users demand feature-completeness. In this case we're better-off waiting until we have solve a few of the major database tasks (branching + migrations, scale-to-zero, edge caching, etc) FWIW, I think it's very cool serving HTML through PostgREST. I would be pretty happy to do this personally
  - dventimi 4y ago
    disclosure: Supabase user Long time user, first time caller. Besides the DO droplet, separately I also use Supabase and I love it. I understand completely about restricting the content type, maybe just for now. Fun fact: I work around it by serving up text/xml plus XSLT. I'm sure you don't mind.
    - kiwicopple 4y ago
      > I work around it by serving up text/xml plus XSLT. I'm sure you don't mind. Not at all, I hear "application/xhtml+xml" is a nice hack from some of the team