Is there any open source tool for creating simple CRUD Apps?

Checkout Daptin https://github.com/daptin/daptin

I have build a lot of crud apps with daptin as the backend. I have been building daptin since about 2 years now.

Daptin will be able to give you much more than just CRUD. Things like authentication/authorization/user management. Maybe you would want OTP based login in future, maybe not. There are a lot of features like that.

It's written in golang so you can get a single independent binary which can run anywhere. There is a docker image as well if you prefer that.

If you are familiar with Rails, I would strongly recommend investigating Django.

Here's why:

- Django admin gives you all the CRUD you need

- ORM to design your models, simple or complex

- Baked in user auth system

- Secure defaults

- Host of pre-built plugins (Django apps)

- Python 3 is a solid language you will love

- Ability to extend in the future if the need arises

Hi, yes, this is what Retool is for! (https://retool.com)

It's like Metabase, but instead of for buliding dashboards, it's for building CRUD apps. LMK if you have any feedback? We've been working on it for a bit now.

Thanks!

Have you looked at:

* Hasura (https://hasura.io/)

* https://www.prisma.io/

* https://www.graphile.org/postgraphile/

Try https://github.com/anvil-works/anvil-runtime

No JavaScript nonsense all python code

With admin/client part builder, all open source and can be self-hosted:

(Node) https://strapi.io/

(PHP) https://directus.io/

(PHP) https://getcockpit.com/

Rails has active admin and a couple of similar options.

I've built quite complex apps with activeadmin, it's worth looking at.

React admin is a pretty good framework I've worked with. It's mature and very pleasant to deal with. It's also got data providers for many different databases.

https://github.com/marmelab/react-admin

Flask-Admin[^1] lets you set up CRUD apps easily. You declare your model and it automatically builds up the CRUD views, which you can restrict, with templates you can customize, and views you can override.

[^1]: https://flask-admin.readthedocs.io/en/latest/

JHipster: https://www.jhipster.tech/

I've seen people mention react admin on here, but I haven't gotten round to trying it out myself.

I’ve used strapi in production apps. Works great, and has a graphql plugin. I’d recommend it!

Elixir + Phoenix + Pow (although very soon there will be ‘mix phx. gen auth’ https://hexdocs.pm/phx_gen_auth/overview.html)

Literally everything does CRUD. Easier is a mirage you'll never reach. I say add Snippets for common things and more file generating and keep cracking with Rails. You'll speed up in no time.

Since you're using Rails, ActiveAdmin is pretty slick. It's an entirely new DSL (see: potential technical debt), but once you get the hang of it, it's hard to beat.

There's also https://github.com/activeadmin/inherited_resources which is what ActiveAdmin uses under the hood. This will take away a lot of the pain of creating said forms.

Obviously you could `rails g scaffold` too.

I've been playing with hyperfiddle (clojure): http://www.hyperfiddle.net/

CouchDB+PouchDB: Serve pages directly from DB

Jasonelle[0]: Write mobile native apps using JSON

[0] https://jasonelle.com

You're on Rails, just scaffold everything.

Any solution that provides a UI for you over database tables is going to feel clunky after a while. If your purpose is to just get something up, use Rails scaffold and throw some bootstrap at it.

When you reach the point where you need more sophistication in your UI, then you can more easily pivot from a set of templates created from scaffold vs. getting locked into something like Active Admin.

Use Active Admin for your dashboards. Inherited resources for controllers, which generates a set of restful actions for a model. And simple form for your forms. They’re all rails ready ruby gems.

This covers 60-80% of the most basic CRUD use cases. Though with any reasonably robust real world application you'll still need to write a lot of more specific, custom logic for the pages that are critical to your domain.

If python is considerable, I'd recommend Flask AppBuilder :https://github.com/dpgaspar/Flask-AppBuilder I used it myself in a freelance project

It has pretty everything I needed

Yii Framework for PHP has a pretty decent CRUD generation tool integrated into it.

https://www.yiiframework.com/doc/guide/2.0/en/start-gii

If you're into Node/Typescript you should have a look at Warthog. It looks a lot like the old Prisma 1 https://github.com/goldcaddy77/warthog

django-admin https://docs.djangoproject.com/en/3.0/ref/contrib/admin/

There is also Yazz Pilot, works on nodejs, docker, k8s or as an .exe or binary. https://github.com/zubairq/pilot

https://www.userfrosting.com/ is a good start if you need multiple users and ACLs.

I've been seeking a terminal based CRUD for ages.

Have you looked at openxava (https://www.openxava.org/)

Django's admin is pretty good.

We're working on some futurology like technology, and something like this will be possible by the end of the quarter. If you'd like to follow along:

https://github.com/hofstadter-io/hof (core tech)

https://github.com/hofstadter-io/_saas (open source "SaaS" to replace all those services you pay for today, and the primary example of building applications in hof-land)

divjoy.com is good for simple CRUD apps

FYI: In the Perl world, CGI::Formbuilder + HTML::Template is a really comprehensive form-centric way of writing CRUD applications.

https://metacpan.org/pod/CGI::FormBuilder