The fastest tool for querying JSON files is *not* written in Python (revised)

• spyql

  23 902 0.0 Jupyter Notebook

  Query data on the command line with SQL-like SELECTs powered by Python expressions

• octosql

  34 4,695 1.2 Go

  OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

Hey, OctoSQL[0] author here.

This is an updated benchmark originally posted a week ago[1] and is a bit of an update to the assertion made at that time.

It now includes clickhouse-local, which is very very fast, as well as a new release of OctoSQL where I tackled some low hanging fruits to get a huge boost in performance (happy to expand in case somebody's interested), which resulted in substantial changes to the overall picture painted by the benchmarks.

[0]:https://github.com/cube2222/octosql

[1]:https://news.ycombinator.com/item?id=31004563

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

Suggest a related project