Hello everyone,
I’m reading the Streamlit documentation and I’m trying to use the st.connection with a Neon database. From the documentation there is only the query method which works only for Read operations, what I need to use for the other CRUD operations? Do I have to use conn.session and execute? Do I have to use the psycopg2-binary package like for PostgreSQL?
Thank you very much!
SQLConnection provides the
query()convenience method, which can be used to run simple read-only queries with both caching and simple error handling/retries. More complex DB interactions can be performed by using the.sessionproperty to receive a regular SQLAlchemy Session.