search

apache / arrow-adbc

Database connectivity API standard and libraries for Apache Arrow
https://arrow.apache.org/adbc/
Apache License 2.0
385 stars 97 forks source link

MSSQL support #588

Open zacqed opened 1 year ago

zacqed commented 1 year ago

I was reading the documentation and open issues to check on MSSQL implementation. Let me know if there is a plan in place to support it.

Thanks

lidavidm commented 1 year ago

As far as I am aware, nobody is actively working on it, but SQL Server support would be welcome. The catch I think would be that FreeTDS is GPL licensed and so development of an ADBC driver using it wouldn't be able to happen here.

lidavidm commented 1 year ago

Now that we can develop drivers in Go and use them in Python/R/C++/etc, we could use https://github.com/microsoft/go-mssqldb (the official Microsoft MSSQL client) which is BSD licensed.

zacqed commented 1 year ago

That ia good to hear.

On Thu, Nov 2, 2023, 7:20 PM David Li @.***> wrote:

Now that we can develop drivers in Go and use them in Python/R/C++/etc, we could use https://github.com/microsoft/go-mssqldb (the official Microsoft MSSQL client) which is BSD licensed.

— Reply to this email directly, view it on GitHub https://github.com/apache/arrow-adbc/issues/588#issuecomment-1790775785, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAMZCR5DJCCHJI6L3J7ESUDYCOQITAVCNFSM6AAAAAAW7FDIJKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTOOJQG43TKNZYGU . You are receiving this because you authored the thread.Message ID: @.***>

davlee1972 commented 10 months ago

Not to hijack this, but could we also work on Sybase support at the same time? https://github.com/SAP/go-ase

Both products support FreeTDS.

The initial version of MS-SQL was a Unix port of Sybase for Windows..

SQL Server 6.0 is released in 1995, marking the end of collaboration with Sybase; Sybase would continue developing their own variant of SQL Server, Sybase Adaptive Server Enterprise, independently of Microsoft.

SQL Server 2005, released in 2005, finishes the complete revision of the old Sybase code into Microsoft code.

SQL Server 2017, released in 2017, adds Linux support for these Linux platforms: Red Hat Enterprise Linux, SUSE Linux Enterprise Server, Ubuntu & Docker Engine.[4]