Progressier VS SQLPage - Build SQL-only websites

I built Progressier to provide developers with the best possible browser-based PWA installation experience. And I can say, it's nearly as good as Google/Apple's app store installation experience. - Source: dev.to / 4 months ago

That's it for me! Hopefully, now you know how to get around push subscriptions being canceled after 3 push notifications. If you have any questions, feel free to contact me here. - Source: dev.to / 11 months ago

When I made Progressier compatible with the desktop Safari update from last October, I had to rewrite a thing or two to put the request for permission inside a click event listener. Doesn't work otherwise. I'd be willing to bet mobile Safari will have the same requirement. Source: over 1 year ago

The twist is that although it does (part of) the job of an app store, it's not (nor aims to be) an app store. It's a script you add to your existing web app that makes it "self-distributing". Check it out: https://progressier.com. Under the hood, it leverages the concept of "PWA", but it goes further: 1. It creates an installation page for your app that looks like an app store listing. Demo example:... - Source: Hacker News / over 1 year ago

With something like Progressier, you can set up a caching strategy that essentially says "cache all images located on firebase.whatever-the-url-is.com and never request it from the network after that". It would take approximately 2 minutes to set up -- no code required. Source: almost 2 years ago

Saving a few clicks for readers: Project page: https://sql.ophir.dev/. - Source: Hacker News / 2 months ago

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? - Source: Hacker News / 2 months ago

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... - Source: Hacker News / 3 months ago

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. - Source: Hacker News / 5 months ago

I have been thinking about that a lot recently. Where I work, we spend a very small fraction of our time on building things that are unique to our business. Maybe we are doing something very wrong, but I am under the impression that most of the code that gets written is extremely low-entropy. This low-entropy, repetitive coding is not limited to the user interfaces. We do tend to describe the same structures and... - Source: Hacker News / 6 months ago