[gdal-dev] SQLite / Spatialite RDBMS

[Chris Toney]

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> 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> *Puolesta *Chris
> Toney via gdal-dev
> *Lähetetty:* sunnuntai 9. maaliskuuta 2025 20.31
> *Vastaanottaja:* gdal dev <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/fba89397/attachment.htm>