Forget about SQLite, Use DuckDB Instead — And Thank Me Later

Introduction to DuckDB and its Python integration

Photo by Krzysztof Niewolny on Unsplash

We, programmers, tend to default to SQLite when we want to work on local environments with an embedded database. While that works fine most of the time, it’s like using a bicycle to travel 100 km away: probably not the best option.