You can add location information to your Tweets, such as your city or precise location, from the web and via third-party applications. You always have the option to delete your Tweet location history. Learn more
my plan is to try something like this: https://gist.github.com/mangecoeur/1fbd63d4758c2ba0c470 … but instead use to_csv in a named pipe or StringIO buffer to avoid reading / writing a file.
1. There is turbodbc with arrow support http://turbodbc.readthedocs.io/en/latest/pages/advanced_usage.html#apache-arrow-support … though unsure of the write support (definitely has bulk read just using basic select that’s fast)
2. Use this binary parser/writer I made for this exact use case! https://github.com/spitz-dan-l/postgres-binary-parser … It uses cython for the binary bits. Only supports a few of the datatypes, also uses an idiosyncratic DSL for schema specification rather than eg SQLAlchemy
I did look at turbodbc but there didn't seem to be much info on how well executemanycolumns with a dataframe worked.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.
