typicalTYLER

I had thought maybe my sqlite version didn't have this feature, but it seems like it does according to the link below. ``` sqlite3.sqlite_version '3.11.0' sqlite3.version '2.6.0' ``` ``` The...

The main reason this is a problem is because I'm inserting a lot of data and checking to see if the data already exists is causing a 10x slowdown for...

Thanks so much for the detailed response! It did feel like going through a car-wash blindfolded and not getting wet haha. I had been looking for something like `__table_args__` to...

Also seems to happen right on startup too: ``` (venv) tyler@tyler-MS-7821:~/PycharmProjects/SolarPanelDataWrangler$ python run_entire_process.py --city "San Antonio" --state "Texas" Searching OSM for a polygon for: San Antonio, Texas Checking if this...

Getting even slower as more cities are in the db. I wonder if there's a way to get a log of longest queries from sqlite. Just to see where adding...

Some slowdown is expected in sqlite due to increased numbers of rows and whatnot, but the slowdown I'm experiencing here is like right after a bunch of rows have had...

But the more I think about it, you're right, we probably need to switch to postgres sooner rather than later. I think maybe after we wrap up contributor friendliness stuff...

Nice! Sounds good :)

I'm unsure if that would be the best thing to do just because then we don't know the extent of the corruption, it's effect on classification, and how often it's...

Yep, your assumptions are correct, if the error happens like this again, no corrupt imagery should be saved and no metadata updated. I think we can maybe just catch this...