The reason why I ask this is because I have been undertaking some testing and have found that there seems to be many implementation and not all of them are interchangeable. For example:
- FME can read and write SQLite Spatial (FDO) and SpatiaLite
- MapInfo can read and write SQLite Spatial (FDO, I think)
- QGIS can read and write SpatiaLite
- MapInfo wont read QGIS' SpatiaLite
- FME will read and write anything (as usual)
- QGIS will read output from FME in either the FDO or SpatiaLite writer, but can't edit (silent fail) and the same for MapInfo written tables.
There are probably other bits of software that read/write some variation of the above but implement it differently.
So, to ask a simple question. Is it fair to expect to work in some variation of SQLite and be interoperable?
Edit: It turns out that you can read/write spatialite from MapInfo and FME in QGIS via the 'open vector' dialog. I was trying using the 'add spatialite table' dialog. It just remains that MapInfo wont read SpatiaLite from QGIS, but this isn't all that surprising...
Edit 2: I am thinking that QGIS wont edit mapinfo and qgis SQLite Spatial layers, despite being able to view them, due to the use of the generic 'geometry' spatial type, rather than 'point' or 'polygon' etc.