Introducing st.connection for connecting to SQL database in 4 lines

[@factuallyfantastic]

arre finally what i was looking for ....for ages

[@jorge1869]

GUI customization, GUI customization is what we need.

[@cohena100]

how do I clear the cache of after calling "query" method? for example I update a table and now need to read it again

[@dv6382]

Hello. Does it work with pandas to_sql, like df.to_sql('table', conn, if_exists='append') for example?

[@joshuakcarroll]

I haven’t tried it but I think if you pass conn._instance (which is the SQLAlchemy Engine) to the df.to_sql it should work

[@rianaditro]

hi, tried it but it returns AttributeError: 'SQLConnection' object has no attribute 'cursor' any helps would appreciate

[@Doggy-m3p]

How to disable the spinner showing: Running sql.query(...) ?

[@billyhart3299]

can I use SQL to store my session state?

[@shahnawazfaridi]

please explain Oracle db connection?

[@AbhishekKumar-wf9ey]

Can anyone please tell me how to make a connection to a 3rd part API

[@michealdmouse]

I couldn't find it documented.

[@TN-cx4qi]

I’m sure by now you either know the answer or gave up on programming. This is for someone else that has the same question. If you’re using python use requests.

[@huz6381]

How can your prevent SQL injection with st.connection?

[@Rusputin-eo6tv]

how can you disconnect ???