Show HN: SQLPage – Build Dynamic Websites with Just SQL Queries

Re:Show HN: SQLPage – Build Dynamic Websites with Just SQL Q... by brudgers on Monday June 05, 2023 @11:21AM (#36197508)

On the landing page, I think a simple hero diagram would be helpful because this appears to be an uncommon approach that mashes-up familiar terms.

I mean I have some familiarity with "dynamic websites" and "just SQL Queries" but no clear picture of the mechanics.

When I hit a landing page, my first questions are:

  What is it? 
  What does it do?
  Should I care about it enough to invest more time?

I clicked "try it out" but it didn't start to answer my questions...instead it asked me questions.

Anyway, Congratulations on launching. I know that's hard.

[ Parent | on HN ]

Re:Show HN: SQLPage – Build Dynamic Websites with Just SQL Q... by lovasoa on Tuesday June 06, 2023 @04:25PM (#36218645)

This is a very good point, and I think I have a hard time explaining how it works technically without it sounding more complicated than it actually is. What

The diagram is a good idea, I'll do it. For a simple explanation, what do you think about:

    SQLPage is a web server that runs .sql files to answer web requests. For every request, it runs the SQL statements in the requested file one by one, passing the HTTP request parameters as SQL statement parameters. Then, it passes the results returned by the database to pre-defined HTML components to create a good-looking webpage that is streamed back to the user's web browser.

[ Parent | on HN ]

Re:Show HN: SQLPage – Build Dynamic Websites with Just SQL Q... by zigh on Tuesday June 06, 2023 @06:13PM (#36219784)

That explanation made it easier to understand, but I found the GitHub Readme much better explains everything. The little video and example helped a lot.

[ Parent | on HN ]

Re:Show HN: SQLPage – Build Dynamic Websites with Just SQL Q... by lovasoa on Tuesday June 06, 2023 @06:51PM (#36220182)

I'll try to include more of the technical contents from github on the landing page, without making it too obscure for neophytes.

[ Parent | on HN ]