Appreciate that. How was its installation? Anything in particular to pay attention to?
I did this couple of years ago already, but first you make sure you have the ODBC driver for your database. Windows has a tool for that, I donāt know other OSās. You test the connection work and what I did was to create a tiny package for my personal use that wrapped the operation of ODBC.jl, with a function that creates the connection with my UID and PW. I have several IUDās at work and they access different DBās, so I wanted that control. Then, all my scripts import the package and I already have the different connections I want to use and set that up. And since I inherited a lot of SQL files to do my tasks, I just run those. Iāve been working like this for about two years now and works for me.
1 Like
I knew it was gonna be trouble. 
It really wasnāt for me, or at least thatās not what I remember. However, I did benefit from setting up my ODBC driver in RStudio before and they had really good instructions. Once I had a useful connection, the rest was easy. And I did the package for my own convenience, you donāt need to do that.
I used ODBC to connect to AWS Redshift, which is a fork of PostgreSQL without issue
I know this is a few years late, but I thought Iād put in a plug for TidierDB.jl here. TidierDB.jl lets a user use Tidier.jl syntax and it converts it to SQL. It has 7 backends (duckdb is the default) including Postgres.
The user would simply open the Postgres connection using LibPQ.jl and then query as needed.
4 Likes
Hi all, just wondering if the situation change much since 2022? Now in 2024 and currently looking in to Julia support for postgres and other database solutions
Postgres also now has the ability to use DuckDB analytics with an extension
1 Like