I wrote telegram bot for my uni project that receives from user spatial and non-spatial data (coordinates and user identity) and puts them in an SQLite database. Then when I extract this database and import it into QGIS an error occured that says "failed to check metadata".

Is it possible that error comes from the SQLite database because my database isn't SpatiaLite when I connect it from SpatiaLite menu i.e must my database be SpatiaLite?

enter image description here

closed as unclear what you're asking by Vince, user2856, LaughU, Jochen Schwarze, xunilk Dec 3 '18 at 13:52

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


Googling "spatialite sqlite" is quite relevant.

Among the first results, there is the good BostonGIS tutorial:

SpatiaLite is an SQLite database engine with Spatial functions added

So you would have to install the Spatialite binaries first

Not the answer you're looking for? Browse other questions tagged or ask your own question.