app.py

import streamlit as st

conn = st.experimental_connection("data_db", type='sql', url="sqlite:///data.db")

with conn.session as s:
    s.execute('CREATE TABLE IF NOT EXISTS mytable (name TEXT, data TEXT);')
    s.commit()


user_name = st.text_input("Your name")
user_word = st.text_input("Choose your word")

if st.button("Guess"):
    with conn.session as s:
        s.execute(
            'INSERT INTO mytable (name, data) VALUES (:name, :data);',
            params=dict(name=user_name, data=user_word)
        )
        s.commit()

loaded_data = conn.query('select * from mytable')
st.dataframe(loaded_data)