Compile with sqlite driver

[yeesian]

Discourse discussion.

[visr]

Yeah another good one to add. Shouldn't be too much work since this already exists:

https://github.com/JuliaDatabases/SQLiteBuilder

[niclasmattsson]

Bump. My use case is that I need to perform a SQL UPDATE command in ogrinfo to create an integer field (so that I can use this field for rasterization later). Apparently UPDATE is not supported in OGR SQL and requires SQlite instead.

julia> run(`$gdalpath/ogrinfo globtest.shp -dialect SQLite -sql "UPDATE globtest SET FID=CAST(substr(GID_1,5) AS INTEGER)"`)                                                                                                                
INFO: Open of `globtest.shp'                                                                                              
      using driver `ESRI Shapefile' successful.                                                                           
ERROR 6: The SQLite driver needs to be compiled to support the SQLite SQL dialect                                         
Process(`'C:\Users\niclas\.julia\packages\GDAL\vec6Y\deps\usr\bin/ogrinfo' globtest.shp -dialect SQLite -sql 'UPDATE globtest SET FID=CAST(substr(GID_1,5) AS INTEGER)'`, ProcessExited(0))                                                                                                                                                                      

[yeesian]

@niclasmattsson might you be interested in giving it a shot?

[robot144]

i would like to use the gpkg format, which uses sqlite for storage. would this also help for my issue?

[visr]

Yes, I assume that GeoPackage support is also added with this.

So in 4aa05a9 I added libsqlite3. But it is not yet live due to several issues with the builds:

JuliaGeo/LibGEOS.jl#56
https://travis-ci.org/JuliaGeo/PROJBuilder/builds/442663332

JuliaGeo/GDAL.jl#60

[visr]

Closing this as the v3.0.0-3 build used in JuliaGeo/GDAL.jl#66 is compiled with this driver (still adding this as a test in the PR).

Some relevant lines from the build.log:

checking for sqlite3_open in -lsqlite3... yes
checking for SQLite3 library >= 3.0.0... yes
checking for sqlite3_column_table_name in -lsqlite3... no
configure: rasterlite2 support disabled

  SQLite support:            yes

So yes it is supported. But there are also more SQLite extensions that can be used that are currently not built in the SQLiteBuilder, like sqlite3_column_table_name for rasterlite2. Or GPKG can use the SQLite rtree extension:

https://gdal.org/drivers/vector/gpkg.html
http://www.geopackage.org/guidance/extensions/rtree_spatial_indexes.html

Probably best to open seperate issues about those when we need them.