Re: [Jsonpath] Jsonpath Digest, Vol 2, Issue 1

Carsten Bormann <cabo@tzi.org> Tue, 11 August 2020 22:06 UTC

Return-Path: <cabo@tzi.org>
X-Original-To: jsonpath@ietfa.amsl.com
Delivered-To: jsonpath@ietfa.amsl.com
Received: from localhost (localhost [127.0.0.1]) by ietfa.amsl.com (Postfix) with ESMTP id 4AA6B3A0D4F for <jsonpath@ietfa.amsl.com>; Tue, 11 Aug 2020 15:06:52 -0700 (PDT)
X-Virus-Scanned: amavisd-new at amsl.com
X-Spam-Flag: NO
X-Spam-Score: -1.897
X-Spam-Level:
X-Spam-Status: No, score=-1.897 tagged_above=-999 required=5 tests=[BAYES_00=-1.9, RCVD_IN_MSPIKE_H4=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=ham autolearn_force=no
Received: from mail.ietf.org ([4.31.198.44]) by localhost (ietfa.amsl.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Nq-5G-H3x1q7 for <jsonpath@ietfa.amsl.com>; Tue, 11 Aug 2020 15:06:49 -0700 (PDT)
Received: from gabriel-vm-2.zfn.uni-bremen.de (gabriel-vm-2.zfn.uni-bremen.de [134.102.50.17]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by ietfa.amsl.com (Postfix) with ESMTPS id BA10A3A0D47 for <jsonpath@ietf.org>; Tue, 11 Aug 2020 15:06:49 -0700 (PDT)
Received: from [192.168.217.116] (p5089ae91.dip0.t-ipconnect.de [80.137.174.145]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by gabriel-vm-2.zfn.uni-bremen.de (Postfix) with ESMTPSA id 4BR6PL6ZCWz100y; Wed, 12 Aug 2020 00:06:46 +0200 (CEST)
Content-Type: text/plain; charset="utf-8"
Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.1\))
From: Carsten Bormann <cabo@tzi.org>
In-Reply-To: <CA+mwktKSMn0e3Xh5K3z-wxeC_icx3dnepWvxKu74miGqLb_wxA@mail.gmail.com>
Date: Wed, 12 Aug 2020 00:06:46 +0200
Cc: jsonpath@ietf.org
X-Mao-Original-Outgoing-Id: 618876406.275476-70e583e1d25d709e1b0027f6af947996
Content-Transfer-Encoding: quoted-printable
Message-Id: <AEE0C02D-DF63-4CEF-AC78-08180BC0B0F2@tzi.org>
References: <mailman.38.1597172408.10748.jsonpath@ietf.org> <CA+mwktKSMn0e3Xh5K3z-wxeC_icx3dnepWvxKu74miGqLb_wxA@mail.gmail.com>
To: Daniel P <danielaparker@gmail.com>
X-Mailer: Apple Mail (2.3608.120.23.2.1)
Archived-At: <https://mailarchive.ietf.org/arch/msg/jsonpath/Kht4dirOhTD8ZsihJmJEpSAKO5I>
Subject: Re: [Jsonpath] Jsonpath Digest, Vol 2, Issue 1
X-BeenThere: jsonpath@ietf.org
X-Mailman-Version: 2.1.29
Precedence: list
List-Id: A summary description of the list to be included in the table on this page <jsonpath.ietf.org>
List-Unsubscribe: <https://www.ietf.org/mailman/options/jsonpath>, <mailto:jsonpath-request@ietf.org?subject=unsubscribe>
List-Archive: <https://mailarchive.ietf.org/arch/browse/jsonpath/>
List-Post: <mailto:jsonpath@ietf.org>
List-Help: <mailto:jsonpath-request@ietf.org?subject=help>
List-Subscribe: <https://www.ietf.org/mailman/listinfo/jsonpath>, <mailto:jsonpath-request@ietf.org?subject=subscribe>
X-List-Received-Date: Tue, 11 Aug 2020 22:06:52 -0000

On 2020-08-11, at 21:56, Daniel P <danielaparker@gmail.com> wrote:
> 
> Note that there is an emerging ISO SQL/JSON standard for JSONPath that
> appears to have
> the backing of Google, Amazon, Microsoft and Oracle, cf.
> https://standards.iso.org/ittf/PubliclyAvailableStandards/c067367_ISO_IEC_TR_19075-6_2017.zip

This is a TR, but it contains a lot of useful material.  Lots of examples!

> It seems to me that a separate standardization effort would need to
> take this work into account

Definitely!  Thank you for the pointer.

> and be
> compatible with it, to have broad acceptance.

For a definition of compatible.  For instance, I would like to learn more about actual usage of the “strict mode” (*).  Also, it is not clear to me that using SQL as the underlying model will work well for all applications.  But that is exactly what we need to discuss in more detail!

The question right now is what should be written up in the charter.  Unless there is a potential for a WG lockup that can only be avoided by making a selection at WG chartering time, I generally prefer to have the WG make the decisions based on its ongoing work, instead of guessing these decisions at chartering time based on more incomplete information.

Grüße, Carsten

(*) My mental model at the moment is that a JSONPath expression can be valid or erroneous; application of a valid expression yields a result (which may be empty), but does not raise errors.  That may not be the right model for all applications.