[Qgis-user] SELECT from Spatialite database

[Alex Mandel]

Rahkonen Jukka wrote:
> Hi,
> 
> I had a try with QGis and Spatialite database. It works fine and fast
> but is is really so that there is no query option and I must always
> fetch the whole database layer?  I would like to create layers with
> queries "like SELECT * FROM osm_lines WHERE highway='residential' and
> name is null"
> 
> -Jukka Rahkonen-

A front end for that has been discussed but not implemented yet. The
easiest plan of which is to add sqlite support to the postgis plugin
tools that already exist

For now I use the spatialite-gui to run queries, or store views and then
access these results via loading the layer.

Alex