Live data from Hacker News

Ask HN: Best low-/no-code solution for simple web-based database frontends

news.ycombinator.com

21–30 of 146 posts

Re: Ask HN: Best low-/no-code solution for simple web-based database frontends

#21
If there is no logic to be needed, wouldn't any of the RDBMS web-management things work out? (think: phpmyadmin etc.)

Alternatively, FileMaker still exists, including a direct web interface option.

I often find that if you truly want a 'low-code/no-code' thing, you're stuck with no-logic no-interaction software. As soon as you start adding logic, you're essentially migrating from programming in a somewhat re-usable language into 'programming' in the form of pictures and application-specific interfaces, which essentially requires the same effort but is much less reusable.

Unless the 'thing' is really a 'table' with some CRUD operations you're gonna en up in a messy situation where some undocumented macro-filled spreadsheet becomes a lynchpin.

Re: Ask HN: Best low-/no-code solution for simple web-based database frontends

#24
post #20

PowerApps [0] is a surprisingly powerful and flexible low code app builder (that can connect to MySQL, etc.) [0] https://powerapps.microsoft.com/

I second PowerApps. There’s a to user-friendly tutorials out there and their programming model is based on concepts similar to Excel.

It should be fairly easy to pick up for end users. But only if you don’t use denormalized tables. If your DB is in 2/3NF you’ll run into issues, e.g. the ever so useful DataTable cannot update data across table.

Also, there’s a pretty significant hard limit on 500 rows.

PowerApps is a great tool, but be aware of its limitations and see if that works for you.

Re: Ask HN: Best low-/no-code solution for simple web-based database frontends

#25
You should check out Stacker: https://stackerhq.com

Your data is hosted in an Airtable or Google Sheet that you control, not in a SQL database, though I'd say this is actually a huge advantage for your goal of a no-code CRUD web app that non-developers can work with easily. It is paid.

Disclosure: I work at Stacker, and we're a YC company. Email in my profile if you have any questions.

Re: Ask HN: Best low-/no-code solution for simple web-based database frontends

#26

You should check out Stacker: https://stackerhq.com Your data is hosted in an Airtable or Google Sheet that you control, not in a SQL database, though I'd say this is actually a huge advantage for your goal of a no-code CRUD web app that non-developers can work with easily. It is paid. Disclosure: I work at Stacker, and we're a YC company. Email in my profile if you have any questions.

Wasn’t the asker’s goal a front-end to Postgres?

Your product looks interesting but I don’t see how it fits the requirements here.

Re: Ask HN: Best low-/no-code solution for simple web-based database frontends

#27
I’ve explored lots of these and implemented a few with customers who wanted their “business analysts” to be able to build apps. My experience has been the “non technical” people can’t do these either and wind up getting developers to try, who are then frustrated with lock-in to a relatively unknown tool or expensive BPM suite. To a developer, these are often “death by a thousand clicks”. Even Visual Studio for the most part has abandoned the “Visual”.

I keep hoping that there’s ways to make low-code work without those drawbacks, and plan to try some new ones I see in this thread. In my mind it has to be a designer that a “non technical” uses to output quality code that a dev can then tweak, but not break the designer.

Re: Ask HN: Best low-/no-code solution for simple web-based database frontends

#28
post #26

You should check out Stacker: https://stackerhq.com Your data is hosted in an Airtable or Google Sheet that you control, not in a SQL database, though I'd say this is actually a huge advantage for your goal of a no-code CRUD web app that non-developers can work with easily. It is paid. Disclosure: I work at Stacker, and we're a YC company. Email in my profile if you have any questions.

Wasn’t the asker’s goal a front-end to Postgres? Your product looks interesting but I don’t see how it fits the requirements here.

Thanks, yeah you're totally right, but worth mentioning if OP had never considered backing an app with a spreadsheet.

It's a really powerful option for non developers to manage data without having to use SQL / a PG client etc.

Re: Ask HN: Best low-/no-code solution for simple web-based database frontends

#29
> I'm currently looking for a solution to provide (non-technical) team members with a way to interact with a SQL database ... While I'm generally willing to pay, I'd really prefer an open and self-hosted solution.

You should definitively check Metabase [0] then: it's open source, very easy to self-host, and democratize data access inside your team. We started using it for the same reason 3 years ago, I cannot recommend it more.

[0] https://github.com/metabase/metabase

Re: Ask HN: Best low-/no-code solution for simple web-based database frontends

#30
hasura.io was built at 34 Cross to solve some very similar issues you've outlined: https://en.wikipedia.org/wiki/Hasura#History

That aside, here are some lesser known low-code data-frontends:

https://www.basedash.com/ (mysql)

https://www.stackerhq.com/ (airtable)

https://www.glideapps.com/ (sheets)

Post reply on HN