[Qgis-user] Qgis and sqlite

[Peter Ersts]

Pedro,

Check out the eVis plugin. It has the ability to connect to SQLite 
databases using Qt's library so you don't have to have spatialite. It 
basically does exactly what John just mentioned and allows you to enter 
full SQL statements as well. The only downside is that the layers eVis 
creates are not persistent, so you should not save them in your project 
unless you convert them to a persistent format like a shapefile.

-pete

On 02/05/2010 02:33 PM, 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
>>
>>      

-- 
====================================
Peter J. Ersts, Software Developer
American Museum of Natural History
Center for Biodiversity and Conservation
Central Park West at 79th Street
New York, New York 10024
Web: http://biodiversityinformatics.amnh.org
Web: http://cbc.amnh.org

Open Source,
...evolving through community cooperation to change the world bit by bit

Quantum GIS Raster Development Team.