detect and ping urls on certain types of sql

[tokumine]

see #6

create/drop table actions logging

etc

[javisantana]

I think if you are going to "parse" SQL its a good moment to extract tables from query too (to purge cache)

[strk]

Was the cache purge implemented in some other way already or is this still a needed feature ?

[demimismo]

We're taking about varnish cache don't we?

On 2.0 we're clearing the table cache from the rails app on this operations:

• Map modification: clears map cache, also clears all the cache related to the tables being used on the map (parses the queries using the same method we're using on the SQL API).
• Layer modification (styles, sql, kind of layer...): triggers its map cache clearing method (so same behaviour as above)
• Table modification (table privacy, name and so on): clears the table's cache and its map's too.