Alternatives to access SQL Server from Julia


#1

Hi guys!

I am trying to fetch data from SQL Server using Julia. I tried to use ODBC.jl, but there are many bugs. My data is too long and it seems that ODBC.jl is putting garbage due to buffer size or something.

I cannot use it in its current state. Hence, is there any other way to do this within Julia?


#2

Never mind, I managed to fix the error and submit a PR:


#3

You can always use PyCall and your favorite python package, e.g. pyodbc.

I can confirm this works flawlessly in production.


#4

Good point! But I think a Julia-only solution will be faster right?


#5

I would be surprised if there were significant speed differences between ODBC.jl and pyodbc through PyCall, but I haven’t tested yet.

I can cofirm the pyodbc alternative
is super stable though, running live since julia 0.3, almost 4 years now, without any hiccup.


#6

Ronis,
do you have GUIDs in your SQL server tables and do you find that ODBC is bringing back the values of those GUIDs in a messy and unhelpful manner?
I’ve been wondering if I’m missing out on doing somethign specific to handle GUID data.


#7

Hi @RobLW

Unfortunately I do not have. I am accessing a very simple database that store some binary data.