Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

allow customising the DB schema #8

Open
derhuerst opened this issue Feb 16, 2024 · 1 comment
Open

allow customising the DB schema #8

derhuerst opened this issue Feb 16, 2024 · 1 comment
Labels
enhancement New feature or request help wanted Extra attention is needed

Comments

@derhuerst
Copy link
Owner

This use case has been brought up in derhuerst/berlin-gtfs-rt-server#9.

berlin-gtfs-rt-server uses hafas-gtfs-rt-feed underneath, which in turn uses gtfs-via-postgres & match-gtfs-rt-to-gtfs. The former already supports using a schema other than public, but match-gtfs-rt-to-gtfs doesn't support it yet.

Two places would have to be adapted:

  • The build-index command needs a new option (e.g. --db-schema).
  • The actual matching logic (index.js) needs a new option (e.g. dbSchema).

The name of the schema should be added to the DB queries in a secure manner, e.g. by using pg-format.

@derhuerst derhuerst added enhancement New feature or request help wanted Extra attention is needed labels Feb 16, 2024
@derhuerst
Copy link
Owner Author

cc @dancesWithCycles

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

1 participant