SQLpage VS bruno

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.

Bruno is a Git-friendly API client. Feature-wise, what makes it stand out from other popular GUI API clients out there is that Bruno stores your collections directly in a folder on your filesystem and it's a desktop app made for offline use.

https://news.ycombinator.com/item?id=39653718 https://www.usebruno.com/

Good timing to find alternatives.

Especially once a VC gets into the fold.

We will never take VC funding. We received around 10 inbound reach outs from VCs till date and have denied funding from all of them. We will remain independent and I have written about it in detail here https://www.usebruno.com/blog/bootstrapping

> I didn't stick with Bruno. I think it was due to not having an equivalent to Postman's pre-request scripts.

Bruno has come a long way, we support pre-request scripts and a lot more

> But can it handle oauth2? I had to write a httpie script recently just to test an oauth2 api.

We have released oauth2 support, some rough edges are being polished

> Good thing it's open source. Money being involved, I don't have long term hopes for it's openness.

I understand this is a hard problem. We are fully bootstrapped and independent. We earn money via selling the Golden Edition. We will build more developer products in the long term, and the goal is to make even the golden edition features also open source in the future. In the unlikely case of me going dark (dead/incapacitated to lead the project), I have instructed our small team (2 FT employees) and my family to release our golden edition features too to the community as opensource. I am committed to this cause.

Some good links where I have discussed about opensource, freedom and monetization

- https://www.usebruno.com/blog/bootstrapping

- https://github.com/usebruno/bruno/discussions/269

If you'd like to pre-order the golden edition: https://www.usebruno.com/pricing

Thank you for all the love and kind words, HN!

Have you heard of the Bruno project? It's an open-source alternative to subscription-based API testing applications like Postman and Insomnia. It's gaining popularity and deserves more attention. Plus, since it's open-source, users can enjoy full privacy. Check it out at https://github.com/usebruno/bruno.

Now, I'm looking at trying Bruno, a new tool I heard about. Bruno has all the features you'd want, like support for websockets. What's great about Bruno is it only costs $19 for a one-time payment, which seems like a good deal. I want to see how well it works for me and if it's as good as it sounds. I'm excited to try it out and maybe talk about it later.

In contrast to Postman, Bruno aims to be an offline-first API client which stores requests in a local folder. You can still collaborate using Git, but everything else happens on your machine. Bruno turns out to be a great solution when you just want to run HTTP requests. It supports a lot of features you might know from Postman or Insomnia (set environment variables, several authentication methods, and scripted tests, to name a few). Looking at the roadmap, the amount of these is only going to increase.