[osgeo4w-dev] [osgeo4w] #906: Adding Sqlean SQLite extension set to OSGeo4W distribution?

[OSGeo4W]

#906: Adding Sqlean SQLite extension set to OSGeo4W distribution?
------------------------+-----------------------------------------------
Reporter:  phidrho      |      Owner:  osgeo4w-dev@…
    Type:  enhancement  |     Status:  new
Priority:  normal       |  Component:  Package
 Version:               |   Keywords:  GPKG Geopackage SQLite SpatiaLite
------------------------+-----------------------------------------------
 Hi,

 I have again stumbled upon need for Sqlean extension set for SQLite
 (Geopackage to be precise) in my project.

 So I would like to bump up my enhancement request from mailing list:
 https://lists.osgeo.org/pipermail/osgeo4w-dev/2024-November/004990.html

 I also commented this with jef in QGIS contributor meeting last year.
 Home page of project is on github, and it is actively maintained:
 https://github.com/nalgeon/sqlean

 It would be very nice to have Sqlean (set of SQLite extensions) available
 to install from OSGeo4W network setup and to load them directly from
 OSGeo4W Shell.

 I find many of these extensions useful when working with GPKG files.

 Since GDAL 3.5.0 we can load SQLite extensions using
 OGR_SQLITE_LOAD_EXTENSIONS (see
 https://gdal.org/en/latest/drivers/vector/sqlite.html#configuration-
 options for details)

 Would it be possible and make sense to package this libraries with
 OSGeo4W?


 Additional resources:

 https://grasswiki.osgeo.org/wiki/Build_SQLite_extension_on_windows

 https://pypi.org/project/sqlite-sqlean/

 https://sqlpkg.org/
-- 
Ticket URL: <https://trac.osgeo.org/osgeo4w/ticket/906>
OSGeo4W <http://trac.osgeo.org/osgeo4w>
OSGeo4W is the Windows installer and package environment for the OSGeo stack.