Import GTFS Static/Schedule datasets into a PostgreSQL database, to allow for efficient querying and analysis. Importing will take 10s to 10m, depending on the size of the feed. On an M1 MacBook Air, ...
A robust Python script that converts Excel (.xlsx, .xls) and CSV files to T-SQL INSERT statements, ready for execution in SQL Server or Azure SQL Database.
The Execute Direct Query event has a duration of 2.1 seconds – meaning that again there is a gap to be explained, a gap where ...