Sync st.data_editor to a database

[dtiosd]

Checklist

• I have searched the existing issues for similar feature requests.
• I added a descriptive title and summary to this issue.

Summary

I use st.data_editor to connect the data to the table in my database, num_rows="dynamic", and after deleting and adding the table on the page, the table of the corresponding database has not changed, is there a way to synchronize it to the database?

Why?

No response

How?

No response

Additional Context

No response

[github-actions]

To help Streamlit prioritize this feature, react with a 👍 (thumbs up emoji) to the initial post.

Your vote helps us identify which enhancements matter most to our users.

[jrieke]

Hey, there's currently no automated way to sync st.data_editor to a database, but we've considered this a few times in the past. You can manually parse the added/deleted rows though and manually write them to your database (they are accessible through st.session_state, see here).

Can I ask for which database specifically you want this and if you have a specific use case in mind?

[dtiosd]

Thank you for your answer. The following are the databases I used and the code. After processing the feedback, I want to delete the information on the page and synchronize this operation to the feedback table in the database.

import sqlite3
import pandas as pd
import streamlit as st

# 连接到数据库
conn = sqlite3.connect('./info.db')

query_feedback = "SELECT username, content, contact FROM feedback"
feedback = pd.read_sql_query(query_feedback, conn)

# 关闭数据库连接
conn.close()

st.data_editor(
    feedback,
    column_config={
        "username": "Username",
        "content": "Content",
        "contact": "Contact",
    },num_rows="dynamic"
)