datafuselabs / jsonb Goto Github PK

Hi there, enabling the use of jsonb-rs in stable Rust would certainly make it more accessible and easier to adopt for users. Have you considered providing a stable-compatible version? This could greatly benefit the wider Rust community.

JSON path has already implemented the basic elements accessors and comparison predicates filter expression, in order to support the full JSON Path language, the following tasks need to be done further.

• Variables:
  • Variables
• Modes:
  • lax
  • strict
• Item methods:
  • type()
  • size()
  • double()
  • ceiling()
  • floor()
  • abs()
  • datetime()
  • keyvalue()
• Arithmetic expressions
  • Unary + or -
  • Binary +, -, *, /, %
• Filter expression
  • exists path predicate
  • like_regex predicate
  • starts with predicate
  • is unknown predicate

The syntax and functionality of JSON Path should be implemented in accordance with the SQL:2016 (ISO/IEC 9075:2016) standard. Here are some references:

• SQL Technical Reports — Part 6: SQL support for JavaScript Object Notation (JSON)
• PostgreSQL Jsonpath in examples and roadmap
• Gentle Guide to JSONPATH in PostgreSQL

Adding support for functions like PostgreSQL eg:

jsonb_path_query_first('{"a":[1,2,3,4,5]}', '$.a[*] ? (@ >= $min && @ <= $max)', '{"min":2, "max":4}') → 2

Using library like https://github.com/besok/jsonpath-rust should be able to expose more JSON path functionalities.

Also some performance numbers about jsonb vs json.

Is it possible to use this as web assembly? We could then use jsonb all the way in UI layer also.

# databend maintains
jsonb = { git = "https://github.com/datafuselabs/jsonb", rev = "3fe3acd" }

Databend depends on git commits of this crate which is not good.

Add benchmarks for accessing nested fields