Grist Labs | Systems Engineer | Full-time | NYC OR REMOTE +/- 3hrs | https://getgrist.com We're looking for someone to make our modern spreadsheet software run everywhere. To apply, there's a puzzle. Just do:. - Source: Hacker News / about 1 year ago

[Baserow], [APITable], [Grist], and [Rowy] are all open source Airtable alternatives which offer hosted SaaS versions that include API access, though it's a bit difficult to compare the API rate limits across all these products. Self-hosting an app like this would allow you to bypass API rate limits altogether, if you're open to it. All the above products can be self-hosted — and you might want to look at [NocoDB]... - Source: Hacker News / almost 2 years ago

There's also Grist (https://getgrist.com) - SQLite based with Excel-like formulae in Python. - Source: Hacker News / about 2 years ago

The only things I have found are Baserow which is basically the best one I've found so far, but it doesn't allow search between columns, importing columns from other tables and I can't restrict users from editing and perhaps corrupting the data. NocoDB doesn't import CSVs and seems to be buggy for some reason. Grist allows restriction for people but it does not have as good filters as Baserow and I can't save my... Source: about 3 years ago

Phenomenal capabilities exceed Excel, Google Sheets, Airtable. Allows app-like views on spreadsheet data, with drag-n-drop configuration. Supports Python-based formulas with familiar Excel functions. Access rules allow sharing a single row or any subset of data. Open-source, and can be self-hosted. https://getgrist.com. Source: about 3 years ago

This article resonates with me. I do love "mildly dynamic websites", and have fond memories of my days hacking together PHP websites 15 years ago. And what I am working on today might be called a bridge for the "dynamicity gap". I'm making an open source server to write web apps entirely in SQL ( https://sql.ophir.dev/ ). It has the "one file per page" logic of PHP, and makes it easy to add bits of dynamic... - Source: Hacker News / 11 months ago

Saving a few clicks for readers: Project page: https://sql.ophir.dev/. - Source: Hacker News / about 1 year 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 / about 1 year 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 / about 1 year 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 / over 1 year ago