use DuckDB instead sqlite

yhat / pandasql

sqldf for pandas

MIT License

1.34k stars 185 forks source link

use DuckDB instead sqlite #82

Open seufagner opened 4 years ago

seufagner commented 4 years ago

This project seems fastly and uses most modern approach

https://www.duckdb.org/docs/current/python/api.html

https://www.youtube.com/watch?v=PFUZlNQIndo

stonebig commented 4 years ago

Select sum(1) from lineitem gives -2 on your live demo

danielvanacker commented 4 years ago

MonetDBLite is generally faster than DuckDB and supports are a larger set of SQL syntax thus could also be an option if this is ever considered.

Alex-Monahan commented 4 years ago

The DuckDB Python API completely replaces PandaSQL in my opinion! You can convert multiple data frames into DuckDB views and query them without even inserting them first! It's incredibly fast, and just as user friendly as this library. DuckDB Python API Examples