5 ms·

I think if someone made a decent auto-fullstack-web-CRUD app they would be very rich and would have solved a lot of no-code problems and saved us an amazing num

I think if someone made a decent auto-fullstack-web-CRUD app they would be very rich and would have solved a lot of no-code problems and saved us an amazing number of man-hours on internal tools. Just: SQL tables, prettified CRUD on those SQL tables on the frontend (with R/W permissions per user on tables), and reports (either on-the-fly or SQL queries run on a cron schedule).

throwaway1777 5y ago
Lots of startups attempting this, two big ones being Retool and Airtable doing almost exactly what you describe.
dragonwriter 5y ago
> Just: SQL tables, prettified CRUD on those SQL tables on the frontend (with R/W permissions per user on tables), and reports (either on-the-fly or SQL queries run on a cron schedule). Supabase is pretty much the backend piece of this (built around PostgREST), all it needs is a frontend generator that fits with its DB conventions.
waxdotrun 5y ago
We're (https://www.wax.run/ https://www.wax.run/) doing this. We expose a CRUD app for your existing database in Google Sheets. You can also call custom Python for anything not covered by SQL.
codegeek 5y ago
Ms-Access says Hello :)
- throw_m239339 5y ago
  > Ms-Access says Hello :) You mean Sharepoint. oh wait, it sucks! ... You mean Dreamweaver. Oh wait, it produces crappy code ... Visual FoxPro... VBA apps... Java's Vignette... Who the hell are people kidding here? I encourage all the "no-code" people here to try all these solutions and understand why they eventually failed, because yours will suffer from the exact same problems...
WJW 5y ago
Isn't that just basically Rails? It has a (pretty good) built-in ORM, prettified CRUD on any of the tables managed through that ORM and making SQL queries on a cron schedule is possible through Rake tasks, which come preinstalled with the framework.
mike22 5y ago
JHipster (https://www.jhipster.tech/ https://www.jhipster.tech/) goes a bit beyond that. From my reading, its basic functionality is taking in either interactive command line inputs or theor custom DSL, and spitting out DDL for a MySQL DB, Spring Boot backend, and Angular frontend.

throwaway1777 5y ago

Lots of startups attempting this, two big ones being Retool and Airtable doing almost exactly what you describe.

dragonwriter 5y ago

> Just: SQL tables, prettified CRUD on those SQL tables on the frontend (with R/W permissions per user on tables), and reports (either on-the-fly or SQL queries run on a cron schedule). Supabase is pretty much the backend piece of this (built around PostgREST), all it needs is a frontend generator that fits with its DB conventions.

waxdotrun 5y ago

We're (https://www.wax.run/ https://www.wax.run/) doing this. We expose a CRUD app for your existing database in Google Sheets. You can also call custom Python for anything not covered by SQL.

codegeek 5y ago

Ms-Access says Hello :)

throw_m239339 5y ago
> Ms-Access says Hello :) You mean Sharepoint. oh wait, it sucks! ... You mean Dreamweaver. Oh wait, it produces crappy code ... Visual FoxPro... VBA apps... Java's Vignette... Who the hell are people kidding here? I encourage all the "no-code" people here to try all these solutions and understand why they eventually failed, because yours will suffer from the exact same problems...

WJW 5y ago

Isn't that just basically Rails? It has a (pretty good) built-in ORM, prettified CRUD on any of the tables managed through that ORM and making SQL queries on a cron schedule is possible through Rake tasks, which come preinstalled with the framework.

mike22 5y ago

JHipster (https://www.jhipster.tech/ https://www.jhipster.tech/) goes a bit beyond that. From my reading, its basic functionality is taking in either interactive command line inputs or theor custom DSL, and spitting out DDL for a MySQL DB, Spring Boot backend, and Angular frontend.