Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Migrate to SQLAlchemy #302

Open
DavidStirling opened this issue Jun 29, 2021 · 0 comments
Open

Migrate to SQLAlchemy #302

DavidStirling opened this issue Jun 29, 2021 · 0 comments

Comments

@DavidStirling
Copy link
Member

Moving away from sqlite/mysqlclient would help to unify a lot of the functionality and could also open up a pathway to supporting other database types. More importantly, pandas to_sql can handle any sqlalchemy connection whereas it can't work with mysqlclient. That function alone makes reading and writing tables much easier and would automatically resolve many of the errors people currently encounter with queries failing due to excessive length.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant