DuckDB is a free, open-source, fast, and performant singe machine OLAP analytical database that supports the full SQL language. It's Python API is extensive, can work with data that does NOT fit into memory, and is many times faster than pandas. I predict DuckDB will dominate the landscape soon! It is a Game-Changer!
Supporting Links
Support Me on Patreon
https://www.patreon.com/bePatron?u=63...
My Playlists: / @bryancafferky
Slides: https://github.com/bcafferky/shared/b...
Code: https://github.com/bcafferky/shared/b...
Data: Yellow Taxi Data 2024-01 (Yellow Taxi Trip Records Parquet): https://www.nyc.gov/site/tlc/about/tl...
My Video on Scaling Python Pandas: • What to Learn for Your Career Path
DuckDB Python API Documentation: https://duckdb.org/docs/api/python/ov...
My Video About Using Python Virtual Environments: • Python Virtual Environments & The Facts of...
DBeaver Documentation: https://dbeaver.io/