SQLPage – Building a full web application with nothing but SQL queries [video]

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com
SQL Analytics low-code Database dbt-viewpoint

SurveyJS
Our great sponsors
  • SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
Our great sponsors

  • SQLpage

    SQL-only webapp builder, empowering data analysts to build websites and applications quickly

    • Saving further clicks:

    > SQLPage is a tool that allows you to build websites using nothing more than SQL queries. You write simple text files containing SQL queries, SQLPage runs them on your database, and renders the results as a website.

    The 22-line "TinyTweeter" example at 28:45 [0] in the video is a good overview - perhaps better than anything currently on the homepage/docs: https://github.com/lovasoa/SQLpage/blob/main/examples/tiny_t...

    Also, based on a couple of discussions [1][2] it seems like SQLPage has the potential to combine well with HTMX too. The two projects definitely share a similar philosophy.

    [0] https://youtu.be/mXdgmSdaXkg?t=1721

    [1] https://github.com/lovasoa/SQLpage/issues/84#issuecomment-19...

    [2] https://github.com/lovasoa/SQLpage/pull/175#issuecomment-187...

  • evidence

    Business intelligence as code: build fast, interactive data visualizations in pure SQL and markdown

    • It’s interesting to me how far you have pushed the SQL language in this framework, such that it truly is “SQL only”.

    The challenge as I see it with enabling analysts to build websites is that you need to build abstractions to get from familiar (SQL, yaml) - the language of analytics, to new (HTML, CSS, JS) - the language of the web browser

    As one of the maintainers of Evidence (https://evidence.dev), one of the things I’ve often considered is how accessible our syntax is to analysts. Our syntax combines SQL and Markdown, with MDX style components e.g.

    The are inherently webdev-ey, and I do think they put off potential users.

    On the flip-side, by adhering to web standards, you get extensibility out of the box, and working out what to do is just a Google search away.

    Anyway, thanks for the thought provoking piece.

  • SurveyJS

    Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

    SurveyJS logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts