Tag: SQLIte

Which, Why and When. PostGIS vs SpatiaLite

Which, Why and When. PostGIS vs SpatiaLite

Applications, Database, General, Industry
Last time we talked on why PostGIS should be the database friend of a GISer , and we touched on most of the features that sets the GIS PostgreSQL extension far from any other spatial database. Of course, PostgreSQL is not the only spatial database that can get your work done, and as one of our readers had suggested, today we will be looking on why and when should choose between PostGIS and SpatiaLite. First things first. SpatiaLite is a variant of the SQLite database that also provides GIS features. It uses the GEOS, PROJ.4, etc... libraries that are also used in PostGIS, and hence the resulting feature set is similar. So what is the difference between the two ? Which one should you pick? Lets find out through a side by side comparison. 1.Scale of Project SpatiaLite is probably t...