SQLpage VS prql

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...

I am currently looking for a solution to run automated tests on a sql website generator I am working on ( https://sql.ophir.dev )

I wanted to use hurl (https://hurl.dev/), but Bruno's UI seems to be useful while developing the tests... Has someone tried both ? Which is better for automated testing, including when the response type is html and not json?

Full fledged BI tools like Superset and Metabase are amazing for their intended use cases.

But they may be an overkill if your primary use case is to infrequently build semi-interactive reports for non-technical end-users and your use cases are are mostly covered by standard graphs & tables. Esp. so if you are familiar with SQL and have access to the underlying data source. Two nifty utilities I have found to be very useful for latter kind of use cases are SQLPage and Evidence.

They make it very convenient to whip out some SQL and convert that to a neat professional looking web ui that can be forwarded to an end user. In case of Evidence it is a statically generated site, and in case of SQLPage it is a web app that connects to a live database.

SQLPage: https://sql.ophir.dev/

Evidence: https://evidence.dev

I feel obligated to add a shameless plug here. The idea is very close to a project I presented at pgconf.eu last week: SQLPage

https://sql.ophir.dev/

SQLPage has the same goal as postgrest+htmx, but is a little bit higher level. It let's you build your application using prepackaged components you can invoke directly from SQL, without having to write any HTML, CSS, or JS.

It would be great if someone could open a github issue with reproduction steps and maybe a screenshot: https://github.com/lovasoa/SQLpage/issues

The worst I'm able to get when manually disabling the cache and simulating a slow 3G connection is this: a blank page first, then text in the browser's font, then the text re-renders with the right font, then the icons load. The user should never see completely unstyled content.

The site uses "font-display: fallback" so this happens only on slow network connections. If the font loads fast enough, then the fallback never appears.

The official website for SQLPage (https://sql.ophir.dev/) is written in SQLPage.

The source code is here: https://github.com/lovasoa/SQLpage/tree/main/examples/offici...

The site also links to this little collaborative game written in SQLPage: https://conundrum.ophir.dev/

The github README has code snippets and associated screenshots: https://github.com/lovasoa/SQLpage#examples

There is also an official repl.it that you can fork to quickly try it online without having to download anything: https://replit.com/@pimaj62145/SQLPage

And SQLPage cloud is coming: https://sql.ophir.dev/your-first-sql-website/hosted.sql

Hey HN community!

I'll be making my first ever presentation at a large tech conference at pgconf.eu this December, where I'll be presenting the SQLPage webapp micro-framework ( https://sql.ophir.dev/ ). I'm eager to make a lasting impression and deliver a presentation that truly resonates with the audience at the conference, who probably knows more about postgres than I do.

That's where I could use your insights. What makes a good tech talk in your eyes? Do you like seeing mind-blowing demos, deep dives into code, compelling storytelling, or something else entirely ?

If you have any specific advice, tips, or ideas for structuring a tech conference presentation, I'm all ears. I want to ensure that my presentation is not just informative but also an experience to remember.

Thank you in advance for your guidance and suggestion !

When I see that, I always wonder whether this is part of the business plan of the people who distribute open source software for free, with a paid hosted version. There is some kind of a conflict of interest: the easier the software is to install and operate, the less attractive the hosted version.

I am working on an open-source software with a hosted version myself ( https://sql.ophir.dev ). It's a website builder, and I'm trying to make ease of deployment and operations a competitive advantage, which is marketed on the home page. But it may be idealistic to ask the same of others. My audience is mostly people who will have to operate the software themselves, whereas in most other domains, the people making the choice to use the software and the people who will then have to operate it are not the same.

> I completely attribute this to SQL being difficult or "backwards" to parse. I mean backwards in the way that in SQL you start with what you want first (the SELECT) rather than what you have and widdling it down.

> The turning point for me was to just accept SQL for what it is.

Or just write PRQL and compile it to SQL

https://github.com/PRQL/prql

Hey HN! We’ve built Pretzel, an open-source data exploration and visualization tool that runs fully in the browser and can handle large files (200 MB CSV on my 8gb MacBook air is snappy). It’s also reactive - so if, for example, you change a filter, all the data transform blocks after it re-evaluate automatically. You can try it here: https://pretzelai.github.io/ (static hosted webpage) or see a demo video here: https://www.youtube.com/watch?v=73wNEun_L7w

You can play with the demo CSV that’s pre-loaded (GitHub data of text-editor adjacent projects) or upload your own CSV/XLSX file. The tool runs fully in-browser—you can disconnect from the internet once the website loads—so feel free to use sensitive data if you like.

Here’s how it works: You upload a CSV file and then, explore your data as a series of successive data transforms and plots. For example, you might: (1) Remove some columns; (2) Apply some filters (remove nulls, remove outliers, restrict time range etc); (3) Do a pivot (i.e, a group-by but fancier); (4) Plot a chart; (5) Download the chart and the the transformed data. See screenshot: https://imgur.com/a/qO4yURI

In the UI, each transform step appears as a “Block”. You can always see the result of the full transform in a table on the right. The transform blocks are editable - for instance in the example above, you can go to step 2, change some filters and the reactivity will take care of re-computing all the cells that follow, including the charts.

We wanted Pretzel to run locally in the browser and be extremely performant on large files. So, we parse CSVs with the fastest CSV parser (uDSV: https://github.com/leeoniya/uDSV) and use DuckDB-Wasm (https://github.com/duckdb/duckdb-wasm) to do all the heavy lifting of processing the data. We also wanted to allow for chained data transformations where each new block operates on the result of the previous block. For this, we’re using PRQL (https://prql-lang.org/) since it maps 1-1 with chained data transform blocks - each block maps to a chunk of PRQL which when combined, describes the full data transform chain. (PRQL doesn’t support DuckDB’s Pivot statement though so we had to make some CTE based hacks).

There’s also an AI block: This is the only (optional) feature that requires an internet connection but we’re working on adding local model support via Ollama. For now, you can use your own OpenAI API key or use an AI server we provide (GPT4 proxy; it’s loaded with a few credits), specify a transform in plain english and get back the SQL for the transform which you can edit.

Our roadmap includes allowing API calls to create new columns; support for an SQL block with nice autocomplete features, and a Python block (using Pyodide to run Python in the browser) on the results of the data transforms, much like a jupyter notebook.

There’s two of us and we’ve only spent about a week coding this and fixing major bugs so there are still some bugs to iron out. We’d love for you to try this and to get your feedback!

> Looks like PRQL doesn't have a Go library so I guess they just really wanted something in Go?

There's some C bindings and the example in the README shows integration with Go:

https://github.com/PRQL/prql/tree/main/prqlc/bindings/prqlc-...

Can someone tell me why PRQL is better? I went here: https://github.com/PRQL/prql

It looks nice, but what's the strengths compared to SQL?

PRQL [1] is a compile-to-SQL relational querying language that puts FROM first.

[1] https://prql-lang.org

https://prql-lang.org/ might be an answer for this. As a cross-database pipelined language, it would allow RAG to be intermixed with the query, and the syntax may(?) be more reliable to generate