[Qgis-user] Qgis and sqlite

[Alex Mandel]

John C. Tull wrote:
> Hi Pedro,
> 
> My best guess is you will need to dump the table to a text file, then use the delimited text layer plugin to bring it into qgis. I don't think there is any direct interaction with sqlite in the absence of making use of spatialite. Others can correct if wrong.
> 
> Regards,
> John
> 
> On Feb 5, 2010, at 10:28 AM, ptg at clix.pt wrote:
> 
>> Hi
>>
>> Is it possible to open a sqlite database in qgis and project points based on two fields (lat, long) of the database without spatialite?
>>
>> Thank you
>> Pedro
>>
>> Área de Clientes Clix – Toda a gestão dos seus serviços online! 
>> http://cliente.clix.pt/. _______________________________________________

The ogr drive might be able to read it if you have a wkt field. I can't
seem to find the ogr docs on that though. Also v.in.ogr in the GRASS
plugin might be able to do it too.

But generally it's a pain,
Alex