29 ms·
Ask HN: No Code GUI Tools?
Is there a flexible, on prem, platform that would allow one to create simple guis to query a series of internal REST APIs and databases?
The idea would be to give non-technical people the power to get at data that is available without having to program custom GUIs.
- msantos 5y agoIf the resulting data doesn't need formatting, try https://www.postman.com/ https://www.postman.com/ It's easy enough to write a few collections and train non-techies to use it. If you are after richly formatted data then try Metabase https://www.metabase.com/ https://www.metabase.com/
- AnotherDS 5y agoKNIME is another option: https://www.youtube.com/watch?v=Snj3_XPcJrU https://www.youtube.com/watch?v=Snj3_XPcJrU
- Reebz 5y agoI’m not entirely sure, but could you do something with node red? https://nodered.org/ https://nodered.org/
- gerardnico 5y agoWhat you are searching is called a business intelligence application such as tableau, qlikview, Business object, Oracle bi and more.
- speedgoose 5y agoYou didn't mention Microsoft PowerBi, is it because it's not something you would recommend?
- gerardnico 5y agoNot at all. Just forgot it out of my mind.
- mritchie712 5y agomost BI don't support querying REST APIs
- gerardnico 5y agoA rest API has by definition no data structure. You can't query data without structure.
- tmaly 5y agoThank you, I am going to have to look into each of these. A solution for non-technical people is probably the biggest feature need.
- napier 5y agoRetool has a self-hosted beta https://retool.com/self-hosted/ https://retool.com/self-hosted/
- mritchie712 5y agoIf your target user does a lot of work in Google Sheets, https://www.wax.run/ https://www.wax.run/ might work well for you. It lets you set up templatized SQL or Python snippets that the end user can control from Sheets by clicking a button (e.g. they could control the WHERE statement in SQL using the value from a cell). The landing page has some examples.
- d--b 5y agoYES!!!! This is what I am building: https://www.jigdev.com https://www.jigdev.com It’s based on ObservableHQ, and is meant to give you ui components that you’d generally use in small tools: buttons, selectboxes, inputs, tables and charts… The code part is javascript, so you can just connect to rest apis no problem, and do some data wrangling using javascript. The doc is non-existant, and the product is in early beta (in use at exactly 1 company). It’s an electron app people can run on their computers. The apps generated are text files containing mostly javascript code that you can diff/audit. Shoot me an email if you want a demo / more info. Edit: the current version can query mysql databases as well. I could write other modules as well. Also planning to add pivot table soon.