search

galaxyproject / gx-it-proxy

3 stars 9 forks source link

Add support for PostgreSQL #21

Closed kysrpex closed 1 week ago

kysrpex commented 4 months ago

Support loading mappings from PostgreSQL via the pg-native library. A major problem was that the proxy works watching files for changes (SQLite or JSON files). With PostgreSQL this is not possible, so I resorted to polling at regular intervals (configurable via the new --pollingInterval command line option) and PostgreSQL asynchronous notifications. See the new function watchPostgres and new section of the README for more details.

As a side effect, running the proxy requires nodejs v14 now. I have also included a package-lock.json file and version specifiers for axios, axios-retry, chai and mocha.

This feature is meant to work in conjunction with galaxyproject/galaxy#18481.

kysrpex commented 2 months ago

galaxyproject/galaxy#18481 got merged, this PR would be the next step. From Git blame, it looks like the original maintainer was @jmchilton.

@jmchilton are you still a contact person for this repository? Who should I contact otherwise?

kysrpex commented 2 weeks ago

@mvdbeek Sorry for not answering earlier, I was out of office. Thanks for the review.

I do not have permission to merge PRs to this repository. Could you merge it, then #22 to bump the version number and finally create a new tag v0.1.0?

kysrpex commented 1 week ago

Thanks @natefoo!