Sure. Any improvements we can get in the UI would be cool. On Thu, Nov 29, 2018 at 10:52 AM Charles Givre <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 > >
