SQLite and SpatiaLite Export

Support for SQLite and SpatiaLite in HALE is based on the generic Database export based on JDBC, and thus has the same limitations. For instance HALE needs the database schema to already exist, thus you can only write to files that have already been prepared and loaded as target schema.

The database export in this version of HALE is deemed experimental. This means it does not have the full functionality we want to provide for a database export feature. However, within its limits it is functional and may be useful to you.

SpatiaLite

To support SpatiaLite the mod_spatialite extension for SQLite must be available. For Windows users the extension is provided together with HALE, for other operating systems you may find it in your package manager or can compile it yourself.

HALE specifically supports version 3 and 4 of SpatiaLite, but should also work with previous versions. Please let us know if you experience any problems working with your files.

SpatiaLite on Windows

HALE ships with the SQLite extension mod_spatialite (Version 4.2.0), which is available as DLLs in the main HALE directory. You can replace the library and its dependencies with different versions, e.g. as provided on the project page.

SpatiaLite on Linux

To compile mod_spatialite please follow the instructions on the project page. The SQLite extension is part of the libspatialite project where you can also find the source code.

You may need to install certain prerequisites to be able to compile the library. As an example, on Ubuntu 15.04 we needed to install the following packages:

After compiling/installing the library, make sure that mod_spatialite.so is available on your library path.



What is a Schema?

What is an Instance?


Save the transformation result