search

cube2222 / octosql

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
Mozilla Public License 2.0
4.75k stars 201 forks source link

Add SPyQL benchmark #273

Closed dcmoura closed 2 years ago

dcmoura commented 2 years ago

Could you please add SPyQL to your benchmarks? https://github.com/dcmoura/spyql/

Installation:

pip3 install spyql

Query (haven't tried it out, but let me know if you run into trouble):

spyql "SELECT passenger_count, count_agg(*), avg_agg(total_amount) FROM csv GROUP BY passenger_count" < taxi.csv

Thanks!

cube2222 commented 2 years ago

Hey @dcmoura!

Added. And congrats on SPyQL, really cool design :)

dcmoura commented 2 years ago

Thank you! I am very impressed with octosql's performance! Congrats on writing your own engine, it's a lot more effort than relying on SQLite!