It should allow creating forms for data input and updates and it should be preferably open-source.
I am thinking more like metabase for creating dashboards, does any such tool exists ?
I am using Rails currently
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.
- 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
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.
However our main ERP system doesn't have an API, so I've been building a custom scraper that feeds into a Django app, which allows custom tooling around our data.
This would have been perfect if it allowed for building scrapers to feed the custom db.
* Hasura (https://hasura.io/)
Serious question though, why post hog & metabase? Dont they overlap?
They both give you incredibly useful data, but different kinds. Metabase lets you analyze trends/relationships in your overall database-layer data. Posthog lets you analyze how users are interacting with your website/app and where your traffic is coming from.
It's like Tableau vs Mixpanel/Amplitude.
So choosing Python makes you swtich languages between FE and BE.
And then there is the async story. Yes Python has a way to write async code, but is more like a patch on top of fully synchronous language rather than full solution, not to mention the very crippled syntax of Python that doesn't let you write anonymous functions.
I've built quite complex apps with activeadmin, it's worth looking at.
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.
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.
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.
It has pretty everything I needed
Jasonelle: Write mobile native apps using JSON
I find flask-admin easier to customize than django’s admin. The django ecosystem has a ton of libraries to add functionality to django admin though.
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)