louiecerv/sqlite3-interactive
0
1import streamlit as st2import sqlite33import pandas as pd4 5st.title("Task 3: Query Data")6 7db_name = st.text_input("Enter database name:", "example.db")8query = st.text_area("Enter SQL query (e.g., SELECT * FROM students):")9 10if st.button("Execute Query"):11 try:12 conn = sqlite3.connect(db_name)13 result = pd.read_sql_query(query, conn)14 st.write(result)15 except Exception as e:16 st.error(f"Error: {e}")17 finally:18 conn.close()19 