I am using LibPQ.jl to interface Julia with Postgres as follows: using FunSQL using DBInterface dbread = "Test2" user = "postgres" password = "password" conn = LibPQ.Connection("dbname=$dbread user=$DATABASE_USER password=$DATABASE_PASSWORD") This is working well. To interface with DBInterface, r…

What am I doing wrong? You are trying to define a function, but the function arguments you specified are wrong ("dbname=$dbread user=$DATABASE_USER password=$DATABASE_PASSWORD" on the left side is neither a variable name or a type). About the actual problem: I guess you are reading to this part …

Okay I copied the code just as you copied it from the docs. Then I put in const conn = DBInterface.connect(FunSQL.DB{LibPQ.Connection}, "dbname=$dbread user=$DATABASE_USER password=$DATABASE_PASSWORD") And lo and behold it worked! Thanks for your help.

Now that I have the database open and can interact with it, I am having problems closing the Database. I am not sure where to go from here. julia> close(conn) ERROR: MethodError: no method matching close(::FunSQL.SQLConnection{LibPQ.Connection}) or julia> DBInterface.close(conn) ERROR: MethodEr…

Hey @Jake , I am about to finish adding DBInterface support to LibPQ via this PR: https://github.com/iamed2/LibPQ.jl/pull/271 (the original author went missing and I am in the process of rebasing and opening a new PR). If need be, I think the forked version of LibPQ with this functionality may fix y…

Thanks. I am not proficient with loading pull requests but was able to look over the source code of the changes made to LibPQ. I then added the new function ‘DBInterface.close!’ that was not included in the FunSQL manual . For reference for others looking at this my solution until the new LibPQ is…

[image] TheCedarPrince: Hey @Jake , I am about to finish adding DBInterface support to LibPQ via this PR: https://github.com/iamed2/LibPQ.jl/pull/271 @TheCedarPrice do I still need to copy the code from the FunSQL manual to bridge DBInterface with LibPQ? I note that DBInterface is now a dep…

The code posted here works fine and without error when used from the REPL. In my use case I have a package MyPackage with the Module also called MyPackage that includes a submodule called MySubModule. MySubModule uses this code through an include statement. When I try to precompile my package it …

[image] Jake: connect(Type{LibPQ.Connection}, Any...) in module LibPQ It looks like you are overwriting (i.e. replacing) the LibPQ function definition for connect, which is probably not what you want to do.

I am wondering if the FunSQL documentation is old documentation and needs to be updated based on the comment from @TheCedarPrince and I should be doing something differently. But I have not been able to figure out what.

Interface FunSQL with LibPQ using DBInterface

General Usage

Jake September 30, 2026, 1:50am 11

By switching from LibPQ.jl to Postgres.jl, my module will now precompile. See Using FunSQL.jl with Postgres.jl and [ANN] Postgres.jl: a Julia-native PostgreSQL client for details on how to do this.

[ANN] Postgres.jl: a Julia-native PostgreSQL client

Topic		Replies	Views
Using FunSQL.jl with Postgres.jl Data	1	220	September 24, 2026
SQLite.jl and LibPQ.jl packages don't work when wrapped in a package General Usage	2	358	August 28, 2023
LibPQ.jl in 2026: Maintenance status and PostgreSQL alternatives Package Management	19	767	September 29, 2026
Easiest and most complete package for PostgreSQL right now (Feb 2022)? General Usage postgresql	48	8061	July 11, 2025
Lack of stable PostgreSQL-communication a major showstopper Data	33	5281	January 8, 2021

Interface FunSQL with LibPQ using DBInterface

Related topics