Ask HN: Easiest way to create a CRUD web app in 2024?
33 comments
You might find PostgREST (https://postgrest.org/en/stable/) interesting. The 'Tutorial 0' gets right to the point with what you can do: https://postgrest.org/en/stable/tutorials/tut0.html
I’ve used Django, Next.js, and Ruby on Rails for CRUD apps recently (in 2023). If you want to minimize time spent writing boilerplate, Rails is still your best bet.
Great to know! I have liked Django in many ways when playing with it, but it is quite the boilerplate to write. Feels like you basically repeat yourself three times, with the MVC split setup. Feels like some of that should be possible to auto-generate, at least with defaults.
Have you looked at .NET MVC with Blazor? It might be overkill for your needs, but the templates give you a good starting point to avoid the usual boilerplate.
Budibase is great at generating CRUD apps based on a model.
https://budibase.com/
https://budibase.com/
Rails features Turbo, background jobs libraries, mailers, etc. It's like 90% of what you need is _already there_ you just have to use it.
Hi! 100% Hasura is what you need! This is our calling card, I work for Hasura and if you need instant CRUD on your database, new or existing you can’t go wrong with Hasura.
It’s kind of like PostGrest with GraphQL.
It does exactly what you want, you have a database with models and it gives you endpoints for CRUD in GraphQL and you can RESTify any GraphQL to make it into a REST endpoint as well.
It does it by introspecting the database then generating a schema, and the OSS GraphQL-engine that runs Hasura compiles the GraphQL directly to SQL.
It’s kind of like PostGrest with GraphQL.
It does exactly what you want, you have a database with models and it gives you endpoints for CRUD in GraphQL and you can RESTify any GraphQL to make it into a REST endpoint as well.
It does it by introspecting the database then generating a schema, and the OSS GraphQL-engine that runs Hasura compiles the GraphQL directly to SQL.
afaik ...
without using a search engine - so i cant say "lmgt4u" - the following ones come to my mind:
* python with for example django
* php with for example laravel
* ruby with rails (2nd this ... not that i ever used it ;)
* java with for example spring-boot
* javascript/node.js with some crappy lib i can't remember right now
* ...
just my 0.02€
without using a search engine - so i cant say "lmgt4u" - the following ones come to my mind:
* python with for example django
* php with for example laravel
* ruby with rails (2nd this ... not that i ever used it ;)
* java with for example spring-boot
* javascript/node.js with some crappy lib i can't remember right now
* ...
just my 0.02€
Yeah, I guess I thought there might be some revolutionary new framework that simplifies it beyond these frameworks. I have been playing with Django, and seen some Laravel code, and it is Ok, but still quite the effort to get something simple up
It depends what you mean by CRUD app.
Strictly speaking, the answer to your question is Airtable.
Strictly speaking, the answer to your question is Airtable.
The one you have the most experience with.
Not that I use it, but that sounds like the promise of Ruby on Rails?
Django and its built in admin panel is still so impressive to me. Adding react admin would be a logical extension of that for a more flexible frontend.
I have some prebuilt tools in vanilla JavaScript. I just copy/paste what I need from my tools and use WebSockets. I can be up within 90 minutes with everything tested and have a large web app that fully loads around 800ms cold and as fast as 130ms in Chrome. Then the next day is content, database (optional), and finally event test automation in the browser.
Have you considered Power Apps model-driven apps[1]? You may not be interested in a PaaS solution however it is very easy to create a CRUD app from a model!
[1] https://learn.microsoft.com/en-us/power-apps/maker/model-dri...
[1] https://learn.microsoft.com/en-us/power-apps/maker/model-dri...
I have heard about Appsmith but never used it myself. Anybody have used Appsmith for this purpose and can share personal experience?
It’s fine for quick prototyping and internal applications.
What you do not like in it? Can you suggest better alternatives?
I haven’t used it for a while as I stopped using low code tools since ChatGPT’s release, but I remember:
- the final application is a bit slow to load, there is a lot of code.
- it uses mongodb internally. I don’t like having mongodb on my stacks.
- the docker and kubernetes deployments were not following best practices. They ran everything, even mongodb and redis, in a stateful container with a process manager inside the container.
- version controlling the apps wasn’t trivial.
- some features weren’t open source so I had to quickly hack them again.
I found retool, proprietary, to be better if you can afford it.
- the final application is a bit slow to load, there is a lot of code.
- it uses mongodb internally. I don’t like having mongodb on my stacks.
- the docker and kubernetes deployments were not following best practices. They ran everything, even mongodb and redis, in a stateful container with a process manager inside the container.
- version controlling the apps wasn’t trivial.
- some features weren’t open source so I had to quickly hack them again.
I found retool, proprietary, to be better if you can afford it.
How do you use ChatGPT to write CRUD apps? Do you mean Github Copilot?
I use them both. I use ChatGPT to do the big parts like the SQL schema and some boilerplate. It works better in Python with fastAPI than Rust with Axum though.
Cool. How do you use it to generate the frontend CRUD interfaces?
I go with React and use GitHub copilot more but ChatGPT can do the big or more advanced components. It’s a lot of manual work still.
Thanks, I'll check it out!
We're trying to build this with https://www.airsequel.com.
So far it generates the whole backend from the SQLite database schema and we'll include an automatic webapp generator soon.
So far it generates the whole backend from the SQLite database schema and we'll include an automatic webapp generator soon.
There is a React meta-framework named Refine for building CRUD apps like internal tools, admin panels etc.
However it's only for frontend.
Check out the CRUD app templates with source codes. https://refine.dev/templates/
However it's only for frontend.
Check out the CRUD app templates with source codes. https://refine.dev/templates/
I've used bootify to good effect: https://bootify.io/frontend/spring-boot-crud-generator.html
Platformatic (https://platformatic.dev) deserves a mention here!:)
1000% Hasura https://hasura.io/
Py4web
Something that can generate a functioning app based on just a model, or similar?