Nikhil VJ

One option is to NOT take the GTFS feed files (csv's) into a DB, and instead, work with them directly, using Pandas. This page shows some ways of optimizing speeds...

Pandas: Some pages from stackoverflow that specifically address deleting of records: - [Deleting DataFrame row in Pandas based on column value](https://stackoverflow.com/questions/18172851/deleting-dataframe-row-in-pandas-based-on-column-value) - [Fast, efficient way to remove rows from large...

[rabaDB](https://github.com/tariqdaouda/rabaDB) > rabaDB is a lightweight, borderline NoSQL, uncomplicated, ORM on top of sqlite3 > ... Somewhat Schemaless: you can modify field definitions whenever you want and it will automatically...

Ran a benchmarking exercise for using Pandas DataFrame on a large, 42MB stop_times.txt GTFS feed file having 1,176,283 entries. https://github.com/answerquest/answerquest.github.io/blob/master/pandas-benchmark-bmtc-stoptimes.ipynb See bottom of that link for conclusions. Recommendation : Use...

Note: We should probably keep the route sequence DB (which is a non-GTFS data being used by this tool to structure new trips creation) as tinydb json only, seeing its...

Update: [v2.0.0](https://github.com/WRI-Cities/static-GTFS-manager/tree/02aceecc8ec7a00564a0c50833c34aee59b2c3c4) marks a major transition to HDF5 (.h5) file format for database. If offers both high compression (millions of rows in a file of a few mb's) and high...

This might help: https://stackoverflow.com/a/1112350/4355695

Adapting from https://nattster.wordpress.com/2013/06/05/catch-kill-signal-in-python/ : ``` import signal, sys def signal_term_handler(signal, frame): print('\nClosing Program.\nThank you for using GTFS Manager. Website: https://github.com/WRI-Cities/static-GTFS-manager/\n') sys.exit(0) signal.signal(signal.SIGINT, signal_term_handler) ``` Works in linux. Have to test...

Reporting from Windows! Had to put the `signal.signal..` command inside the main function to make it work when running in python3 on windows. Then it exits gracefully. So this works...

Hi @dancesWithCycles thanks for posting this. I'm not able to determine right now what may be causing this issue; haven't checked this project in a long time. Will try to...