[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-dev
Subject:    [sqlite-dev] tree explain
From:       Roger Binns <rogerb () rogerbinns ! com>
Date:       2011-12-07 7:28:44
Message-ID: 4EDF15AC.50509 () rogerbinns ! com
[Download RAW message or body]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The tree explain stuff looks rather interesting.  Could I suggest
formatting the output as LISP style s-expressions?  This would also make
it machine readable and hence possible to present in an even richer way,
provide rewriting/restructuring etc.

One thing that would be helpful to many tools is having a way to decompose
an entire statement in this way.  You'll see many of the graphical tools
have implemented something but everyone has to start from scratch and
update it as SQLite's grammar changes.  It greatly helps in showing the
user what happens to their query, and to pull subexpressions out to help
them debug.

Somewhat related is the ability to do this but without a grammatically
correct complete statement.  This is needed to do syntax highlighting as
you type, as well as provide meaningful completions/suggestions.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAk7fFagACgkQmOOfHg372QTzvQCgivQdSnhKssZFYzfseiELB4uW
lpcAn3mYrsYfmdjw6X3vs4Hb/buMZTTo
=h3p1
-----END PGP SIGNATURE-----

[prev in list] [next in list] [prev in thread] [next in thread]