Instructions for saving to SQL?

[jinnyzor]

Hello @bpolasek,

There are a few ways:

You can save a dataframe directly to sql using df.to_sql.
https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_sql.html

You can hook up to PostgreSQL and push updates that way:

How to power a Dash App with a PostgreSQL DB

Hi there, in this article I will go through the steps to set up a database (db) on your Heroku project, the ‘musts’ to consider to make a connection to a bd manager and the deployment of a dash-app capable to commit data to the database. This tutorial is tied to a multi-page Dash app that I built and shared with you in this GitHub repository. However, the focus of this article will be on connecting a Dash app to a PostgreSQL Database, so even if you have a one page Dash app, this will show you …

Or, if you want transactions and SQL strings, you can use a library like pyodbc.

I personally use the last option, as I do some pretty extensive updates to a SQL server.