Redash VS Motor Admin

It seems like there may be an issue with Watchdog on Apple Silicon.

I am looking for service or tool similiar to Metabase or Redash that allows me to add data source - for example Postgres connection, and create raw SQL queries that can be shared or exposed through API. So instead of keeping raw SQL code somewhere, my other service would call this tool e.g. http://microservice/query=1?param1=xx&page=2 and get the results from the DB. These calls are internal only and part of ETL processes, but of course authentication would be required.

Yeah, a lot of the time I'd agree with you.

This container came about for the Redash project (https://github.com/getredash/redash), which has been stuck on PostgreSQL 9.5 (!) for years.

Moving to a new PostgreSQL container version is easy enough for new installations, but rolling that kind of change out to an existing userbase isn't so pretty.

For people familiar with the command line, PostgreSQL, and Docker then no worries.

But a large number of Redash deployments seem to have been done by people not skilled in those things. "We deployed it from the Digital Ocean droplet / AWS image / etc!"

For those situations, something that takes care of the database upgrade process automatically is the better approach. :)

I have tried Metabase, Redash beore (both self hosted open source versions), from my experience I find Metabase a bit easy to work with.

Regarding visualization tools, sqliteviz has proven to be the best I've found so far. Their web app runs locally but has some trackers, so I run it locally via a simple, static HTTP server. Falcon and Redash seem like overkill for my needs.

Redash seems to be dead or at least in hibernation. There hasn't been a release in over a year.

https://github.com/getredash/redash/issues/5891

redash

Tangential: MotorAdmin is a pretty reasonable, mountable, Rails-based option.

I'm using it to pack BrowserUp, a command line app that can run load tests in Ruby using your own Ruby/Capybara/Selenium/Cuprite libraries (note: still alpha, ping if interested). Motor Admin ships a web app with a no-code admin utility. I think Shopify would have been way better off using this for their latest command line interface rather than taking on a Node dependency, but they might not have realized this was an option, so that's part of why I'm sharing this.

There seems enough competitors when this looks like a tool from 20 years ago with limited functionality.

If you somehow do not use the obvious GUI tools like TablePlus, Postico or SequelAce but prefer web based, there are some that actually look modern.

https://www.getmotoradmin.com/

https://www.nocodb.com/

https://redash.io/

For readonly usage, Metabase is good.

You should check Motor Admin open-source tool (disclaimer: I'm the creator of the tool): https://github.com/motor-admin/motor-admin

>Auto-generating the GUI from SQL schema, similar to the original Django Admin

Thats exactly how Motor Admin works :)

The link posted here is to a Supabase-specific landing page.

Their main home page doesn't mention Supabase: https://www.getmotoradmin.com/

If you want a more codeless approach (not as customizable, but it already looks good and works fine out of the box), I suggest Motor Admin. You just plop it in your project, run a few migrations and it's ready to go. From that point forward, you can add forms, graphs, and query all of your models without coding as much.

Github

There are many open-source no-code tools so you can gain full control over your data/application with them as well as contribute into the source code.

For instance, you can deploy an admin panel with https://www.getmotoradmin.com/ (plug) and save a lot of time building custom internal tools.