Re:Julia 1.6: what has changed since Julia 1.0?
by oxinabox on Sunday February 14, 2021 @10:52AM
(#26133336)
> (1) How is its database connectivity?
Databases are not really my thing but:
From what I hear: It is ok. Not amazing. But decent.
LibPQ.jl is very mature (we run it in production).
MySQL.jl exists, I hear about SQLite.jl being used pretty often.
I know people use ODBC.jl, and JDBC.jl, though only because they complaint about things. I suspect there are a fair few people using them without complain that i never hear from.
Though I haven't heard any mention really of JDBC in a while.
While there is nothing like SQLAlchemy,
a nice thing about DataBases in julia is they all conform to Tables.jl tables.
So very easy to take your DataFrame library of choice (or CSV reader, or Arrow.jl or a dozen other formats), and use that is the input or output from a database query.
Databases are not really my thing but: From what I hear: It is ok. Not amazing. But decent.
LibPQ.jl is very mature (we run it in production). MySQL.jl exists, I hear about SQLite.jl being used pretty often.
I know people use ODBC.jl, and JDBC.jl, though only because they complaint about things. I suspect there are a fair few people using them without complain that i never hear from. Though I haven't heard any mention really of JDBC in a while.
While there is nothing like SQLAlchemy, a nice thing about DataBases in julia is they all conform to Tables.jl tables. So very easy to take your DataFrame library of choice (or CSV reader, or Arrow.jl or a dozen other formats), and use that is the input or output from a database query.