I am a new Julia user and am working with Debian.
Connectivity to PostgreSQL is important to me.
I have installed odbc-postgresql on my computer and could do:
> isql 'PostgreSQL test' js
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> quit
js@artikel ~>
Then I installed ODBC using Pkg.add("ODBC") in Julia.
However when I want to use it I get a lot of warnings and in the end an
error:
julia> using ODBC
WARNING: requiring "Dates" in module "ODBC" did not define a corresponding
module.
WARNING: dlopen is deprecated, use Libdl.dlopen instead.
etc... (A lot of warnings removed)
WARNING: Base.String is deprecated, use AbstractString instead.
likely near /home/js/.julia/v0.4/ODBC/src/ODBC.jl:16
ERROR: LoadError: TypeError: Array: in parameter, expected Type{T}, got
Tuple{DataType,DataType}
in include at ./boot.jl:261
in include_from_node1 at ./loading.jl:304
in require at ./loading.jl:243
while loading /home/js/.julia/v0.4/ODBC/src/ODBC.jl, in expression starting
on line 16
I see there is a PostgreSQL.lj which depends on DBI.jl (both of which not
in the official package list).
I have tried to use Python's psychopg2 (through PyCall) and successfully
connected to the database, but I could not define a cursor.
So what is the best way to achieve stable and reliable communication with
my database?
Regards.
Johann
