MobilityData / gtfs-realtime-validator

Java-based tool that validates General Transit Feed Specification (GTFS)-realtime feeds
Other
38 stars 9 forks source link

Add compatibility with Microsoft SQL Server #88

Open isabelle-dr opened 2 years ago

isabelle-dr commented 2 years ago

As mentioned in https://github.com/MobilityData/gtfs-realtime-validator/issues/56, when we try to deploy the validator as-is as a hosted service the default embedded HSQLDB database performance degrades with usage to the point that is it not usable. To fix this, we need to deploy a different database server (e.g., MySQL, Microsoft SQL Server, PostgreSQL).

Work to to make the validator compatible with Microsoft SQL server has been started in PR#323 on the CUTR-at-USF GitHub repository. We recommend leveraging the work already done, merging it on the CUTR-at-USF GitHub repository and then fetching the changes here.