So impressed with A(rrow)DBC for database connections. It is optimized for columnar data but can read row oriented DB's like Postgres very efficiently.

I made a Streamlit app to just show you what you can do with it. For all the DB connections I'm just using pyarrow and ADBC drivers. The footprint is so small!