[gdal-dev] SQLite / Spatialite RDBMS

[Rahkonen Jukka]

Hi,

The SQLite driver has a long history, I guess it was originally made to support FDO https://web.archive.org/web/20240811210751/https://trac.osgeo.org/fdo/wiki/FDORfc16<https://web.archive.org/web/20240811210751/https:/trac.osgeo.org/fdo/wiki/FDORfc16>.
By that time there was no other use for SQLite so making it optional was probably natural.

-Jukka Rahkonen-

Lähettäjä: Chris Toney <jctoney at gmail.com>
Lähetetty: sunnuntai 9. maaliskuuta 2025 21.37
Vastaanottaja: Rahkonen Jukka <jukka.rahkonen at maanmittauslaitos.fi>
Kopio: gdal dev <gdal-dev at lists.osgeo.org>
Aihe: Re: [gdal-dev] SQLite / Spatialite RDBMS

Right, libsqlite3 is definitely ubiquitous, and I always want libspatialite too. But that is different from whether the GDAL vector  driver "SQLite / Spatialite RDBMS" is compiled in, which it is not by default. That would depend more on whether various package management systems choose to enable it in their distributions, for example. Or if there are reasons that custom builds would tend to exclude it sometimes. My sense is that the driver is generally available even though it's optional at build time. Just wondering if there are known exceptions to be aware of, or if my assumptions above are wrong? Why is it an optionally compiled in driver given ubiquity of SQLite? Just because GPKG mostly fulfills that need and is standard?

Chris

On Sun, Mar 9, 2025 at 1:02 PM Rahkonen Jukka <jukka.rahkonen at maanmittauslaitos.fi<mailto:jukka.rahkonen at maanmittauslaitos.fi>> wrote:
Hi,

Proj requires SQLite anyway and you may want to do coordinate transformations with GDAL. Without SpatiaLite you’ll miss only the SpatiaLite SQL functions, and of course support for SpatiaLite databases.

-Jukka Rahkonen-

Lähettäjä: gdal-dev <gdal-dev-bounces at lists.osgeo.org<mailto:gdal-dev-bounces at lists.osgeo.org>> Puolesta Chris Toney via gdal-dev
Lähetetty: sunnuntai 9. maaliskuuta 2025 20.31
Vastaanottaja: gdal dev <gdal-dev at lists.osgeo.org<mailto:gdal-dev at lists.osgeo.org>>
Aihe: [gdal-dev] SQLite / Spatialite RDBMS

Hi,
The SQLite / Spatialite RDBMS driver says "SQLite is an optionally compiled in driver. It is not compiled in by default." It seems fairly ubiquitous though. Is that a safe assumption (more or less), or are there important caveats to know about? I know that SQLite could be present without SpatiaLite support, but I'm wondering about the SQLite driver for "regular" SQLite databases, with or without SpatiaLite.

Thanks!

Chris Toney

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20250309/36e44b02/attachment-0001.htm>