QGIS and Spatialite: Is it usable?

[المشرف العام]

I am somewhat disheartened by my experience with Spatialite databases in QGIS. In theory, it could be what personal geodatabases are for ArcGIS: a consolidated, portable format that keeps projects clean. In reality, I run into problems though, that make it very cumbersome to use Spatialite in QGIS:

• Data types do not get assigned properly, most fields get TEXT, even if the CREATE statement stated otherwise. This makes form creation impossible since it depends on the data type of a field.
• Most GUI operations a designed for Shapefiles and do not allow Spatialite as the Input layer...

Is there a good way to use Spatialite in QGIS at all?

Thank youn for your workflow suggestions.

Cheers

Lars



أكثر...