Changelog

• (Feature) OctoSQL now explicitly operates on int64 values, so integer operation results shouldn't be affected on 32-bit platforms. (#332) (Thanks @tjungblu!)

Changelog

• (Maintenance) Update Go dependecies (#324) (Thanks @jauderho!)
• (Maintenance) update badge url as per badges/shields#8671 (#322) (Thanks @phanirithvij!)
• (Bugfix) Prevent creating ~/.octosql dir if XDG dirs exists (#316) (Thanks @tony-sol!)

Changelog

• (Feature) Add support for the XDG Spec (thanks @tony-sol for the contribution!).

Changelog

• (Feature) Change the semantics of double quotes from a string literal to a literal identifier (so they work the same way as backticks).
• (Bugfix) Fix division using slash as an operator. Require a space between operands for it to be usable.

Changelog

• (Feature) Improve CSV value formatting.
• (Feature) Add configuration parameters for JSON maximum line size as well as file reader buffer size.
• (Feature) Add boolean to int conversion function.
• (Performance) Hashing optimizations to reduce unnecessary allocations.

Changelog

• (Feature) Switch to using a hashmap instead of a BTree in some (not all yet) places where ordering is not important. This yields a small performance improvement for most group by queries, and a huge one (up to 4x measured) for groupings with a lot of keys.
• (Bug) Fix bug where variables only used by a distinct node can be optimized out, making the distinct node work improperly.

Changelog

• (Feature) Parallelize JSON processing. Can result in 2x+ performance improvements for queries bottlenecked by JSON parsing.
• (Stability) Improve error message when non-SELECT statement is used.

Contributions

• Improve installation documentation (#294). Thanks @arikgrahl !

Changelog

• Internal Refactors

Changelog

• (Bug) Fix object field access for fields that have periods in them. I.e. object->`my.field`

Changelog

• (Feature) Add overloads for len function handling lists, objects and tuples.
• (Feature) Improve automatic column naming based on variable names.
• (Stability) Improve stdin reader error handling.
• (Stability) Bump the number of schema introspection rows for the CSV datasource to 100, to keep it consistent with the JSON datasource.