Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: ESQLate – Build minimum viable admin panels with just SQL

github.com

Post reply on HN
Print view View original

41–50 of 83 posts

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#41

Post by yuegui »

richieartoul wrote: post #31

This is cool. I built something similar awhile back for a side project. I had a folder that I would dump files into and each file would have a title, description, and SQL statement. When I visited a specific page on my site (password protected) I had a bit of Go code that would read all the the files, execute all the (read-only) SQL statements and then dump them into an HTML template that created a table for each one…

If you are looking for some simple SQL to table/report tools, give Poli a try: https://github.com/shzlw/poli

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#43

Post by zubairq »

bsaul wrote: post #13

i 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…

Yes yazz Pilot lets you build an admin panel by pointing at a dB and then it queries the database tables which you select visually

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#45

Post by xwowsersx »

Another 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."

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#46

Post by darau1 »

yehia2amer wrote: post #44

This look similar to Oracle Apex: https://apex.oracle.com/en/ from my experience very good for simple logic but once it's is complicated you hate yourself.

Guys on my team struggle with Apex daily since we've started using it, which has lead to me look for a better, FOSS alternative. This looks like it might be the one

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#47

Post by matthewaveryusa »

mattatkeyboard wrote: post #12
sandGorgon wrote: post #10

could you check the code ? i think esqlate-server is .gitignored

esqlate-server lives at https://github.com/forbesmyester/esqlate-server It might be the instructions for install a bit off but I've tested on MacOS and Ubuntu (both BASH)... Which method is your install? If it's Docker Compose ( https://github.com/forbesmyester/esqlate#docker-compose-meth... ) it has a BASH line there in the README that does the checkout for you. [ ! -d "esqlate-server" ] && git clone git@github.com:…

You may want to revisit how you do this. At the very least use git submodules so a particular version of your code pulls the correct version of a dependency.

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#48

Post by geewee »

xwowsersx wrote: post #45

Another 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.

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#49

Post by marviel »

geewee wrote: post #48
xwowsersx wrote: post #45

Another 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.

You might find Postgraphile interesting, if you like graphql: https://github.com/graphile/postgraphile

Re: Show HN: ESQLate – Build minimum viable admin panels with just SQL

#50

Post by brentis »

Rowern wrote: post #21

This 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

Post reply on HN