Team Ai
Apppublic

louiecerv/sqlite3-interactive

sourceHugging Faceapache-2.0updated 2y agoView on Hugging Face
0likes
Task3_Query_data.py19 linesDownload Raw Back to pages
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