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

1–10 of 83 posts

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

#3

Post by BjoernKW »

That looks quite useful. The name's pretty clever, too.

Tools like these are a viable, low-code (to use a hyped-up term) alternative to creating full-blown back-ends with all the boilerplate code that comes with them. Often these back-ends add little more than a REST API or a simple CRUD interface on top of an SQL database.

RDBMS on the other hand are immensely powerful tools that unfortunately more often than are used for little more than simple data storage.

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

#5

Post by mattatkeyboard »

jimmar wrote: post #2

Interesting idea. Are you doing anything to protect against sql injection attacks?

Yeh. It send through the key/values in HTTP POST and then you have the SQL and K/C's on the server, the SQL itself is not sent. Server passes them through as parameters to the Node.JS `pg` module so that takes care of defeating SQL injection.

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

#6

Post by BjoernKW »

trungdq88 wrote: post #4

Interesting. How would you make this to support one-to-many/many-to-many relationships?

This being a tabular visualisation of SQL result sets you'd either have duplication in some columns or aggregated results.

That's simply how SQL deals with 1:n and n:m relations.

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

#7

Post by mattatkeyboard »

trungdq88 wrote: post #4

Interesting. How would you make this to support one-to-many/many-to-many relationships?

You write the SQL into a JSON file. Users then can then execute that SQL with their own parameters. So the many-to-many is in your capability... A key reason for this is that it itself should not be clever.

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

#8

Post by Gys »

Nice work. I have also build a (mysql) sql based dashboard for our internal use. It mainly shows agregated lists of data and allows to click on many items to see more details.

We use it to get more insight in our data. It does not allow a user to enter anything.

Basically my app only uses a list of queries. To allow that any selected field is clickable, the result field should be like 'report|name|field,field' so the app knows this is a special link (report) refering to another defined query ('name') and should be passed some values (record specific, here 'field,field').

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

#9

Post by mattatkeyboard »

Gys wrote: post #8

Nice work. I have also build a (mysql) sql based dashboard for our internal use. It mainly shows agregated lists of data and allows to click on many items to see more details. We use it to get more insight in our data. It does not allow a user to enter anything. Basically my app only uses a list of queries. To allow that any selected field is clickable, the result field should be like 'report|name|field,field' so the…

Yeh sounds like you had a similar revelation to me :-) This can also do the linking between "reports" or "forms". Happy you built one, makes me think this has at least some chance of success.
Post reply on HN