I am pleased to announce the availability of JDBC.jl. Available via your
favourite package repository: Pkg.add("JDBC") or
at https://github.com/aviks/JDBC.jl . It has a dependency on JavaCall.jl,
and you will need to install Java where you want to use it.
Currently this supports plain SQL (insert/update/select/DDL), prepared
statements and stored procedures. The interface mimics the Java JDBC API.
The primary data access method is to iterate over the Resultset. An
optional "readtable" method can convert a ResultSet into a Julia Dataframe.
Blob types are not supported yet, nor are more esoteric features such as
scrollable cursors or Rowsets. However the power of JavaCall means that you
can easily drop down and directly call Java methods that are not yet
wrapped. Issues or PR's about missing functionality is welcome.
Finally, there are tons of different databases that have JDBC drivers. I
cannot feasibly test them all myself. So please let me know any reports of
success or failure with different databases.
Regards
-
Avik
