PostgeSQL

[mshiner]

Is there a way to connect up Huey to a backend postgeSQL database?

[mshiner]

So, did a bit of digging

Given the ERP system we want to connect to is open source (https://github.com/uzerpllp/uzerp) I thought we might be able to use postgrest so that the views we need to query could be set up as api endpoints. However, I guess we will run into issue #479 as postgrest uses JWT https://docs.postgrest.org/en/v14/references/auth.html