Show HN: Open-source admin panel for Supabase
getmotoradmin.comBased on the use cases section, it doesn't seem like this is Supabase specific, but rather postgres specific. Do I have that right? Leveraging Supabase for marketing is a good idea.
You're right - Motor Admin is Postgres specific (or DB specific since it works with Mysql and SQLserver as well).
The link posted here is to a Supabase-specific landing page.
Their main home page doesn't mention Supabase: https://www.getmotoradmin.com/
I've been using this with my clients the last few weeks, and while it's definitely polished enough for many uses and one of the better admin tools I've seen, note some drawbacks of this tool:
1) It does not appear to have good support for custom Postgres data types (which is reasonable, given that Motor admin appears to work with multiple SQL databases, rather than just Postgres)
2) Its handling of hiding columns is somewhat hacky - if you hide columns from being shown, they're hidden from inserting and editing as well. This can cause issues if you'd like to hide some NOT NULL columns from being displayed.
3) It seems to inject its own 'ID' column into all 'Resources' in the admin panel, and will not be happy if you happen to have an 'ID' column. (As far as I can tell, it seems that the 'Resources' of Motor admin are precisely Ruby on Rails Resources, and that Motor admin generates Rails classes and Resources for you based on your database schema)
4) It does not allow 'unusual' table names such as names containing ':', '--', etc (This seems to cause the generated Ruby class names to become invalid)
To cope with the above issues, I've created Postgres tables for the express purpose of being managed by Motor admin, with the admin tables being sync-ed with the backing tables via triggers. I've attempted to use views instead, but it seems that Motor admin does not recognise views.
Please feel free to open issue on Github if you face some difficulties or find some bugs/errors - hopefully those issues can be easily resolved.
I find Directus better because it is 100% even with Role Support. Not related to directus just enjoing it so much AFTER i have used strapi and supabase for quite some time. Don't get me wrong supabase is great and i know this tool is a generic admin interface, but the same is true for directus. you can put directus on top of any DB (sqlite, postgresql, mysl, oracle) and get a fancy admin ui for free. https://directus.io/
The latest release of Motor Admin includes automatic DB schema reload feature. So now all change in Supabase schema are automatically applied to the Motor Admin panel. It means that Motor Admin now works perfectly with Supabase and can be used to build complex admin UIs for internal users.
I have been using motor admin with a postgresql database for a few months now, and the team is really enjoying its lightning-fast features.
Also, the maintainers take the reported issues seriously, and have been at task with fixing them.
My first reaction to this is that some of the features (directly editing data, viewing data) won't work for our deployment of supabase, as our data is within a schema not exposed by PostgREST (all interaction with supabase is done via db functions on the public schema).
Unless this admin panel directly connects to the postgres instance?
It directly connects to PostgreSQL database instance.
Looks interesting ! I'm currently building a webapp on Supabase and have been considering Retool for admin purposes. What would this offer over something like Retool ? Do you offer specific features tailored to Supabase in order to make the integration easier or do you simply treat it as an ordinary PostgreSQL DB ?
Motor Admin uses PG instead of Supabase API for better performance, ease of use and enhanced features.
It has several advantages comparing to Retool like simple self-hosting option, CRUD UI out of the box, periodical data reports (aka alerts), unified UI optimized on mobile (instead of retool's more complex UI builder).
Shame, but looks like SSO is hidden behind an "enterprise" tax.
https://www.getmotoradmin.com/pro
Another entry for https://sso.tax
How does it compare to Metabase?
It is not clear within the documentation, is the Heroku Deployment going to run on a an Heroku Free Tier Plan?
Yeah, Heroku free tier would be enough to deploy and run the app.
Is anyone who has tried both this and Forest Admin able to give a comparison of feature sets?
Disclaimer: I'm the founder of Forest Admin
I never tried MotorAdmin as it seems to be a young project. But it provides a great open-source alternative to Forest Admin as the value proposition explained on the website has been highly influenced by our tool. It is always a great sign for me :-)
What I can say about Forest Admin and that we spend years to provide all the fundamentals to get started with a great admin panel and also all the required features for fast-growing companies to huge corporate.
Please don't give a free license to companies. Charge them and donate your profits to the dependencies you rely on.
is an AWS deploy planned soon?
You can run it on AWS EC2 or on any other Ubuntu server - the app is distributed as a single executable binary - so you basically need to connect to your AWS EC2 via SSH, download the binary and run it: https://docs.getmotoradmin.com/guide/#ubuntu
Thank you! great idea!
Wow, this looks really cool. And if it can be used for Supabase I guess it can be used for https://nhost.io too because both are using Postgres?
As you are the creator of nhost maybe you could check that out and tell us whether it works?
Wording this differently so you’re not guessing about a project you run would be better.