+1 if you can get it deployed and running smoothly out of the box. We can then hack around Drill to host this as the Query interface on the Drill server's webpage instead of using the current mashup of libraries, and take away the inherent challenges of maintaining the web-based Query interface within the Drill server.
~ KK On 11/29/2018 10:59:49 AM, Parth Chandra <par...@apache.org> wrote: Sure. Any improvements we can get in the UI would be cool. On Thu, Nov 29, 2018 at 10:52 AM Charles Givre wrote: > Hi Parth, > SQLPad doesn’t currently support JDBC, but I think it could be extended to > do so. I found some node modules for JDBC ( > https://www.npmjs.com/package/nodejdbc > https://www.npmjs.com/package/nodejdbc>), but I’m not the world’s best > JavaScript programmer, so it took me a while to hack the current one > together. I’ll have a go at it, now that I “know” what I’m doing. > > Regardless… I think it could be done with what’s out there. SQLPad does > offer a huge improvement over what Drill’s current UI offers and I do think > it would be really great to include or borrow code (with appropriate > attribution) from it for the Drill UI. The current UI uses REST anyway, so > it wouldn’t be any different. > > I always wonder why the developers of tools like this don’t include > generic interfaces such as JDBC and ODBC rather than building tool-specific > drivers, but that’s another discussion. > > > > On Nov 29, 2018, at 13:40, Parth Chandra wrote: > > > > I once considered whether we could incorporate SQLPad as the query > > execution interface in the web UI, but never got around to looking into > it. > > The problem with using the REST api is that it becomes unwieldy when the > > number of records returned by the query becomes large. I haven't looked > at > > the code in SQLPad, but is there a way to use the JDBC/ODBC API's ? > > > > On Thu, Nov 29, 2018 at 7:33 AM Charles Givre wrote: > > > >> All, > >> There is a really nice open source tool out there called SQLPad. In > >> addition to executing basic SQL Queries, SQLPad enables to to export > >> results and produce basic visualizations. Until recently, SQLPad did > not > >> support Drill however, I just wrote a first attempt at Drill support > which > >> you can download here: > >> > >> https://github.com/cgivre/sqlpad/tree/drill > >> https://github.com/cgivre/sqlpad/tree/drill> > >> > >> Please check it out and let me know what you think. > >> Best, > >> — C > >
