Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
You can use Pandas to_sql method to upload records to a relational database. However, be aware this functionality is aimed at using Pandas for its original purpose (data analytics and transformati...
Answer
#1: Initial revision
by
marquii
·
2023-07-06T19:42:23Z (over 1 year ago)
You can use Pandas [`to_sql`](https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_sql.html) method to upload records to a relational database. However, be aware this functionality is aimed at using Pandas for its original purpose (data analytics and transformations), so that Pandas can make complex processing and send the results to a SQL table, but it is not advisable to write a traditional "database app" using Pandas as the database connector, since it will be slow performing and less scalable (Pandas is not meant for high throughput applications). You can use an ORM like [Django ORM](https://docs.djangoproject.com/en/3.1/topics/db/queries/) or [SQLAlchemy](https://docs.sqlalchemy.org/en/20/index.html) if writing bare SQL is annoying for you.