Hello people, this is my second question to raise in the forum, the first one was completely resolved and I am very grateful.
Now…it’s very easy to communicate python or F# with a sqlserver database in Azure, for example, because those languages have many DB connectors, but I can’t do it in Julia! or I can’t find the right paper. Could someone help me or guide me?
Thank you!!
Did you look at MySQL.jl yet?
Not yet, but I need to build a database that is in mssql server
I think the way is to use Microsoft’s ODBC driver with https://odbc.juliadatabases.org/dev/#ODBC.jl. This StackOverflow post contains some tips on how to get it working Connection string for SQL Server in Julia ODBC - Stack Overflow, but it might be easier if you are on Windows
(Sidenote: if you are building a new DB from scratch and need to connect to it from a number of different platforms, I’d consider choosing a more mainstream DBMS. For example, PostgreSQL protocol has much better support across programming languages)
1 Like
ok, tanks
(Sidenote: if you are building a new DB from scratch and need to connect to it from a number of different platforms, I’d consider choosing a more mainstream DBMS. For example, PostgreSQL protocol has much better support across programming languages)
Just to complement, today in the Julia environment I think MySQL is the best choice when it comes to support. The MySQL.jl package is a good standard database interface, but if you prefer options like PostgreSQL, LibPQ.jl will really do too!