Thank you both! Was just seeing if there was a way to be lazy :) David - thanks for the note on the odbc driver. I’m actually curious about the other end. Do you know if one can use the driver in say DataGrip / SQL workbench etc? If so, do we pick say “Postgres” connection or some other flavor?
Cheers, Chang On Wed, Feb 1, 2023 at 7:34 AM Philip Moore <phi...@voltrondata.com> wrote: > Ah yes – sorry I missed the “pyarrow” part in the subject line, my > apologies. The example links are C++ only… > > > > *From: *David Li <lidav...@apache.org> > *Date: *Wednesday, February 1, 2023 at 10:29 AM > *To: *dl <user@arrow.apache.org> > *Subject: *Re: example pyarrow flight sql server? > > Flight SQL is not supported in Python (client or server). > > > > For the server side, I think we can consider PRs. The API surface is > large, so I worry it would be tedious to maintain. > > > > For the client side, there is an experimental driver available for ADBC > [1]. > > > > For the ODBC driver, IIRC James Duong has stated it was mostly tested > against Dremio. (It's not part of the Arrow project due to licensing > issues, because it has code derived from a GPL codebase - though I believe > those parts could be rewritten eventually.) So this is a case of 'try it > and see'. > > > > [1]: > https://github.com/apache/arrow-adbc/tree/main/python/adbc_driver_flightsql > > > > On Wed, Feb 1, 2023, at 09:00, Philip Moore wrote: > > Hi Chang, > > > > Here are the examples from the Arrow repo: > https://github.com/apache/arrow/tree/master/cpp/src/arrow/flight/sql/example > > > > They have SQLite and Acero example servers built… > > > > Thanks. > > > > Phil > > > > *From: *Chang She <ch...@eto.ai> > *Date: *Tuesday, January 31, 2023 at 10:01 PM > *To: *user@arrow.apache.org <user@arrow.apache.org> > *Subject: *example pyarrow flight sql server? > > Hi there, > > > > I was looking to play around with flight sql server but couldn't find an > example/reference server implementation to help me get started. If anyone > can point me in the right direction I'd really appreciate it. > > > > Thanks! > > > > Chang > > >
