How to compile and install spatialite on iOS

_howto.md

Spatialite for iOS

Install compiler dependencies

brew install automake autoconf libtool libxml2 pkg-config
brew link libxml2

Build libspatialite

git clone https://github.com/gstf/libspatialite-ios.git
cd libspatialite-ios
make

The result is a folder, lib, containing several .a files, as well as an include folder containing many .h files.

Create a new XCode project

Copy the libspatialite binaries and "include" folder into a folder named "libspatialite" in the XCode project folder.

In the XCode project's "Build Settings", you'll need to set the library and header search paths:

Library Search Paths: $(PROJECT_DIR)/AppName/libspatialite Header Search Paths: $(PROJECT_DIR)/AppName/libspatialite/include

Drag the .a files into your project.

From the "Build Phases" window, add the following to the section "Link Binary With Libraries":

• libz.dylib
• libxml2.2.dylib
• libc++.dylib
• libcharset.1.0.0.dylib
• libiconv.dylib

Now you should be able to use spatialite! To test if everything worked, just make your AppDelegate output the spatialite version.

Add the following to AppDelegate.m

#include <sqlite3.h>
#include <spatialite/gaiageo.h>
#include <spatialite.h>

In your application:didFinishLaunchingWithOptions: method, add:

spatialite_init (0);
printf("Spatialite version: %s\n", spatialite_version());

Compile and run and you should see the version output in the console!

filesystem.png

search-paths.png

xcode-project.png

@ali711 Hi) Have you figured this out?! I faced with the same issue( This is my code:

func my() {
        let dbName: String = "country_boundaries123.db"
        let docsPath = FileManager.default.urls(for: .applicationSupportDirectory, in: .userDomainMask).first!.path
        let fullname = docsPath + "/" + dbName

        do {
            let dbQueue = try DatabaseQueue(path: fullname)
            try dbQueue.inDatabase { db in
                spatialite_initialize()
                var spconnect = spatialite_alloc_connection()
                spatialite_init_ex(db.sqliteConnection, &spconnect, 1)
                print("Before execute")
                let query: String = """
                SELECT boundaries.alpha2Code FROM boundaries WHERE ST_Within(ST_PointFromText('POINT(25.276496038 54.684885945)'), geometry)==1;
                """
                let row = try Row.fetchOne(db, sql: query)
                print(row)
                print("After execute")
            }
        } catch let error as NSError {
            let str = "\(error.debugDescription)"
            print(str)
            return
        }
    }

Row.fetchOne, Row.fetchAll, Row.fetchCursor - all of this didn't give me any results. There are no errors, that can be caught in "do{} catch{}" block. So it looks like these functions for Geos and Proj are present but do nothing.

@Tybion You write code-snippets above, maybe you can know what's wrong?
I'm stuck here and need some help please, from anybody. Any ideas?

Sorry, after upgrading GRDB my code stopped working, and I had to fix it quickly, so I reverted my code to the sqlite3 code that I have listed above.

@Tybion Do you still have these generated libs? Can you share it, please? Maybe, if I can compare yours and mine I will find the solution.

I am travelling, only have a phone, but my working code was based completely on the sample code above.

It took some time to find a solution, but it was worth it.
I wrote an article with explanations to help developers like us avoid the same struggle.
Long story short - for proper work SpatiaLite needs to be initialized on the C level.