This looks great! I've used sqlpad[1] for similar purposes which is bit more low level as it allows to write the queries in the browser directly.
Show HN: ESQLate – Build minimum viable admin panels with just SQL
51–60 of 83 posts
Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL
#52i was stunned the first time i saw web frameworks like django and symfony automatically build a full featured admin panel based on model's definition. I wonder if there aren't projects aimed a building just an administration GUI based on SQL introspection mixed with simple configuration files. Just point at a db, and there you go. Side note : what is the current state of codegen based on api and model specifications…
I think forestadmin.com / jetadmin.io are the SQL introspection equivalent of the Django Admin. Both are commercial products though.
Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL
#53I wonder if there is anything like this but for a larger swath of tools, like say anything that is JDBC or ODBC compliant. More like data virtualization tools like dremio, denodo, atscale.
Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL
#54Another worthy mention (not FE, but also exploiting power of sql): https://github.com/PostgREST/postgrest "PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write from scratch."
PostgREST is really hard to figure out how to use though. I tried it a year or two ago because I was really excited about the posibillity, but the setup was super unintuitive, and the docs were hard to follow. I got a simple case working, but in the end I gave up on using it for anything serious - I simply wouldn't trust myself to be able to debug it if something went wrong.
[deleted]
Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL
#55Another worthy mention (not FE, but also exploiting power of sql): https://github.com/PostgREST/postgrest "PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write from scratch."
PostgREST is really hard to figure out how to use though. I tried it a year or two ago because I was really excited about the posibillity, but the setup was super unintuitive, and the docs were hard to follow. I got a simple case working, but in the end I gave up on using it for anything serious - I simply wouldn't trust myself to be able to debug it if something went wrong.
Mind explaining in more detail the difficulties you encountered?
Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL
#56This looks pretty interesting! If anyone is looking for a tool to build a full fledge Back Office I warmly recommend react-admin ( https://github.com/marmelab/react-admin/ ). Been using it for a year now and we went from 0 back office to a feature full one in no time!
Been researching space as well. This is more feature complete IMO. https://react-material-dashboard.devias.io/dashboard
The is just a web "template". React-admin is a full featured framework with multiple data backends.
Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL
#57This looks pretty interesting! If anyone is looking for a tool to build a full fledge Back Office I warmly recommend react-admin ( https://github.com/marmelab/react-admin/ ). Been using it for a year now and we went from 0 back office to a feature full one in no time!
Or, you know, just use Django ;-)
Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL
#58Earlier quoted context omitted.
PostgREST is really hard to figure out how to use though. I tried it a year or two ago because I was really excited about the posibillity, but the setup was super unintuitive, and the docs were hard to follow. I got a simple case working, but in the end I gave up on using it for anything serious - I simply wouldn't trust myself to be able to debug it if something went wrong.
You might find Postgraphile interesting, if you like graphql: https://github.com/graphile/postgraphile
You might also find Hasura interesting for instant GraphQL with Postgres:
https://hasura.io/
Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL
#59Does anyone else find it humorous that the majority of top-level comments in this thread start with, "Cool! I built something just like this because sucks!"
This tells me that (a) it is a common problem, and (b) it is not solved well. I'm guilty too: I manage a large MySQL DB and the admin panels are essentially CRUD UI rendered from the schema. The alt solutions I've clicked on here try to add more functionality, but it seems that's where things break, because every solution is different beyond the 1st-order CRUD UI. This seems to indicate there is no generic solution beyond that?
Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL
#60I use adminer for this. https://www.adminer.org/ It's a single PHP file, and does everything I need.