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 <par...@apache.org> 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 <cgi...@gmail.com> 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
