Hasura is the greatest CRUD tool of all time. It gives you a UI you can build a database schema in or you can put in on top of an existing schema (PostgreSQL and MSSQL support), it has support for migrations, it easily integrates any auth you like, and you just run GraphQL queries against it to CRUD the data. Not a single need to write SQL or REST APIs or anything!
Ask HN: Easiest way to build a CRUD app?
151–160 of 239 posts
Re: Ask HN: Easiest way to build a CRUD app?
#152+1 for Django. Defining your model is easier than CREATE TABLE and built-in admin is ridiculously powerful - it can do all the CRUD operations, makes it super easy to add bulk actions (literally just a function), comes with filtering and search that you simply need to enable and handles nested forms (like 1-N or N-M relationships) out of the box.
User authentication and permissions are built in and there are many 3rd party modules available to do all sorts of thing. django-import-export for example allows importing and exporting to/from any spreadsheet format, including a preview of the changes before you run it for real.
Re: Ask HN: Easiest way to build a CRUD app?
#153Retool + Dark Lang
Re: Ask HN: Easiest way to build a CRUD app?
#154The answer is use whatever language/framework you know best. Know PHP? Use Laravel. Know Python? Use Django.
For me, I am mainly a Javascript developer so I use AWS + Next.js. It's very easy to create an API with Serverless, hook up a DynamoDB table, maybe add some Cognito in there, etc. All just Javascript. You can deploy the Next.js site to S3.
Obviously, this means a ton of external dependencies, but if you want something easily it I think it works well.
Re: Ask HN: Easiest way to build a CRUD app?
#155For non enterprise graded CRUD apps, I usually go the PHP way, it's not sexy but it's cheap to run both in term of server cost and brain space to worry about what could go wrong, doesn't require constant maintenance and is likely to outlive the majority of what is considered sexy today.
Why would using PHP make an app not require maintenance?
Re: Ask HN: Easiest way to build a CRUD app?
#156I’m surprised nobody had said MS Access. You don’t need to learn any programming languages, it comes with everything you need, and every Access app has lasted way longer than anyone wanted it to. ;)
^ legit point -- tight coupling between data + UX widgets is like postgREST + retool in a single package that has been evolutionarily stagnant since like 1992
Re: Ask HN: Easiest way to build a CRUD app?
#157nginx + language of choice as CGI + sqlite on a DO droplet
This. If you can use Go you can skip ngnix and add auto cert gen with let’s encrypt with about 3 lines of code.
Re: Ask HN: Easiest way to build a CRUD app?
#158"Easiest way to build a CRUD app". Using the CRUD-app-building framework in which you are competent . Beyond toy apps there are no shortcuts without that competence but there are plenty of prospective frameworks to develop it in, as evidenced by the other comments.
> Using the CRUD-app-building framework in which you are competent. That's assuming people already know one. If they don't, which would you recommand?
I wouldn't. There are no silver bullets. I would say (assuming there were no other motivations) to trial whichever popular, community-supported and well-documented frameworks seem the best match for whatever skills (languages, business domains, whatever) they already have, and go with the one they feel most comfortable with.
Re: Ask HN: Easiest way to build a CRUD app?
#159.NET, razor pages, sqlite, entity framework. Its hard to build anything non-trivial with a gui without involving a few languages these days. You can package your .NET server as completely self contained and run it on anything, just need a web browser. Edit: python might get you close with a simple html framework.
This is the only valid answer as far as I’m concerned. No other solution offered allows you to write client-side code, SQL commands, and back-end code all in the same language (in this case, C#).
With the SAFE stack and SQL data providers you can go 100% F#
Re: Ask HN: Easiest way to build a CRUD app?
#160I'm reading this as a CRUD GUI app. Definitely Ruby on Rails coupled with Avo (shameless plug). It literally takes you less than an hour to create a realistic usable CRUD app (that would take you at least a few days in the traditional way) without learning anything new. Generate a DSL (a Resource) and add one line per field. Avo knows how to read and display in a rich way, handle creating/updating records using your…
Except ruby is dead for literally anything else, so the moment you need it for anything else you're combining languages.