[sqlite] Wish list: allow developers use the power of sqliteparser

2016-01-19 Thread Hick Gunter
- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von David Barrett Gesendet: Dienstag, 19. J?nner 2016 07:28 An: SQLite mailing list Betreff: Re: [sqlite] Wish list: allow developers use the power of sqliteparser One

[sqlite] Wish list: allow developers use the power of sqliteparser

2016-01-18 Thread David Barrett
Whoaa!! This is amazing! https://www.sqlite.org/c3ref/c_alter_table.html Wow, thanks! -david On Mon, Jan 18, 2016 at 10:54 PM, Scott Hess wrote: > On Mon, Jan 18, 2016 at 10:27 PM, David Barrett > wrote: > > > One use of this I would like is to create a security framework around > >

[sqlite] Wish list: allow developers use the power of sqliteparser

2016-01-18 Thread Scott Hess
On Mon, Jan 18, 2016 at 10:27 PM, David Barrett wrote: > One use of this I would like is to create a security framework around > arbitrary SQL queries from the user. So, for example, I'd love to > determine which tables (and which columns of those tables) a particular > query is going to

[sqlite] Wish list: allow developers use the power of sqliteparser

2016-01-18 Thread David Barrett
One use of this I would like is to create a security framework around arbitrary SQL queries from the user. So, for example, I'd love to determine which tables (and which columns of those tables) a particular query is going to access, and then compare that list against a whitelist of columns the

[sqlite] Wish list: allow developers use the power of sqliteparser

2016-01-18 Thread Domingo Alvarez Duarte
Is this something crazy to ask as a developer ? I think that even for the author something like this would make several tasks easier. Ideally I would like to feed the parser with an sql string, get it's syntax tree, maybe do some rewrite and feed it execute it, this possibility can open the

[sqlite] Wish list: allow developers use the power of sqliteparser

2016-01-18 Thread Domingo Alvarez Duarte
freedom and can provide a way to reuse the parser power ? Cheers ! ? > Mon Jan 18 2016 2:15:04 pm CET CET from "Richard Hipp" >Subject: Re: [sqlite] Wish list: allow developers use the power of >sqliteparser > > On 1/18/16, Domingo Alvarez Duarte wrote: >

[sqlite] Wish list: allow developers use the power of sqliteparser

2016-01-18 Thread Hick Gunter
te.org] Im Auftrag von Simon Slavin Gesendet: Montag, 18. J?nner 2016 15:36 An: SQLite mailing list Betreff: Re: [sqlite] Wish list: allow developers use the power of sqliteparser On 18 Jan 2016, at 2:20pm, Domingo Alvarez Duarte wrote: > Can we have something that do not remove your fr

[sqlite] Wish list: allow developers use the power of sqliteparser

2016-01-18 Thread Simon Slavin
On 18 Jan 2016, at 2:20pm, Domingo Alvarez Duarte wrote: > Can we have something that do not remove your freedom and can provide a way > to reuse the parser power ? In the amalgamation source code you will find /* ** The interface to the LEMON-generated parser */ SQLITE_PRIVATE void

[sqlite] Wish list: allow developers use the power of sqliteparser

2016-01-18 Thread Domingo Alvarez Duarte
(const char *zSql); Can't you see the syntax tree ? (javascript enabled is necessary) Cheers ! > Mon Jan 18 2016 12:39:10 pm CET CET from "Keith Medcalf" > Subject: Re: [sqlite] Wish list: allow developers use >the power of sqliteparser > > What are

[sqlite] Wish list: allow developers use the power of sqliteparser

2016-01-18 Thread Simon Slavin
On 18 Jan 2016, at 11:51am, Domingo Alvarez Duarte wrote: > The idea is to have a way to get a syntax tree of a sql string through the > sqlite parser: synatx_tree sqlite3_sql_syntax_tree(const char *zSql); The vast majority of copies of SQLite don't run on normal computers, they're embedded