Re: [Qgis-developer] Spatialite ’select’ statement as vector layer in QGIS

[Ricardo Filipe Soares Garcia da]

Hi all
I've added a new version of this plugin (v 0.2).
It is now possible to query spatialite and postgis layers. The results
are displayed on the map canvas or as a table. I added a small help
page to the plugin as well. I started writing some documentation on
how to use it, but it is still unfinished.

A small gotcha: if you decide to test it with postgis layers, don't
forget to include the schema name when you reference a table.

Please let me have some feedback, if you have the time to test it out. Thanks


On Thu, Dec 9, 2010 at 10:40 AM, Ricardo Filipe Soares Garcia da
<ricardo.garcia.silva at gmail.com> wrote:
> Sorry, forgot to add this:
>
> I will add a small help page explaining the functionality later.
> Probably tomorrow.
>
> Cheers
>
> On Thu, Dec 9, 2010 at 10:38 AM, Ricardo Filipe Soares Garcia da
> <ricardo.garcia.silva at gmail.com> wrote:
>> Hello
>>
>> I have uploaded my plugin to the contributed repository. I marked it
>> as experimental. It is called 'Custom DB query'. I did a bit of
>> cleaning up and even managed to get the 'normal query' feature to
>> work.
>>
>> So, by now you can:
>>
>> - run an SQL query and choose to view the result in the map canvas or
>> in a table format. This is only working for spatialite layers. Postgis
>> will come later.
>>
>> Beware that I am not parsing the SQL in any way! So please be careful
>> about what SQL queries you write, that can potentially damage your
>> database. If you stick to SELECT statements it is OK.
>>
>> I didn't mean to bring one more spatial db plugin to the table, when
>> there are currently so many ;)
>> I will retire this one in due time.
>>
>>
>> --
>> ___________________________ ___ __
>> Ricardo Garcia Silva
>>
>
>
>
> --
> ___________________________ ___ __
> Ricardo Garcia Silva
>



-- 
___________________________ ___ __
Ricardo Garcia Silva