Pushing st.data_editor into postgres database?

[dataprofessor]

Hi @jstp

And if you’re looking to push the updates back to the database, you can see this thread for some ideas:

St.form_submit_button to update Postgres database

In this case I am fairly certain the curs.execute and commit need to be below the form_submit_button. Running the code the way you have it clears the app/form and then puts the list with empty values into the database. I use an if condition, e.g., if _submitForm: curs.execute(…) conn.commit(…) This way these get triggered and run before the app refreshes itself on submit.