Instructions for saving to SQL?

[bpolasek]

Could anyone share with me information they found useful for learning how to take inputs from Dash and save to a SQL database. The database structure has already been created.

Thanks!

[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.

[bpolasek]

Yeah so I have been reading in data from a SQL database to generate graphs. Now I need to save some settings from these graphs into different SQL database tables. The current SQL set up uses pyodbc so I’m sure that is probably what I need to go for here.

[jinnyzor]

In that case, you can create a cursor and perform an execute a raw SQL could with your updates.

Remember, do not take user’s inputs directly, but use ? as a placeholder.

Also, do not forget to commit after you are done.

[bpolasek]

Thank you!