An interface to PostgreSQL from Julia. Uses libpq (the C PostgreSQL API) and obeys the DBI.jl protocol.
I can no longer spend work time on this so this project is in maintenance mode (accepting PRs and attempting to resolve issues). New code on the dbapi
branch (https://github.com/JuliaDatabases/DBAPI.jl) represents the most recent work, which I will continue if I am in a position to do so again.
using DBI
using PostgreSQL
conn = connect(Postgres, "localhost", "username", "password", "dbname", 5432)
stmt = prepare(conn, "SELECT 1::bigint, 2.0::double precision, 'foo'::character varying, " *
"'foo'::character(10);")
result = execute(stmt)
for row in result
# code
end
finish(stmt)
disconnect(conn)
using DBI
using PostgreSQL
connect(Postgres, "localhost", "username", "password", "dbname", 5432) do conn
#code
end
- DBI.jl
- DataFrames.jl >= v0.5.7
- DataArrays.jl >= v0.1.2
- libpq shared library (comes with a standard PostgreSQL client installation)
- Julia 0.4
Tests require a local PostgreSQL server with a postgres user/database (installed by default with PostgreSQL server installations) with trusted authentication from localhost.
- Tested on Funtoo Linux and Windows 8
- Should work on other systems provided libpq is avaiable (please file an issue if this is not the case)
- Implement more default PostgreSQL type handling
- Test type handling overrides
- More comprehensive error handling and tests
- Support for COPY
- Asynchronous connection support
- Asynchronous Julia for handling asynchronous connections
- Testing and compatibility with multiple versions of PostgreSQL and libpq