gtfs-realtime-validator icon indicating copy to clipboard operation
gtfs-realtime-validator copied to clipboard

Published 20 hours ago • verified publisher icon CUTR-at-USF

Add compatibility with Microsoft SQL Server

Open Suryakandukoori opened this issue 6 years ago • 1 comments

Summary:

As mentioned in https://github.com/CUTR-at-USF/gtfs-realtime-validator/issues/308, 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).

This PR changes some of the SQL statements to make the validator compatible with Microsoft SQL server.

It needs to be tested on HSQLDB, Microsoft SQL server, and preferably other database servers as well before it is merged.

Closes https://github.com/CUTR-at-USF/gtfs-realtime-validator/issues/308.

Suryakandukoori avatar Mar 21 '18 16:03 Suryakandukoori

Thanks @Suryakandukoori! I'll take a look at this and see if I can set it up, and make it compatible with HSQLDB too. I appreciate it!

barbeau avatar Apr 01 '18 04:04 barbeau