Dear list,
a recent thread on user list was about SQLite and math functions support [1]
The specific problem was well investigated, but the second part of message
(having math support for SQLITE as GRASS default) could be interesting for
future developments. IMHO
2013/9/26 Markus Neteler <neteler at osgeo.org>
> Including SQLite math functions in the standard binary GRASS GIS
> distribuition could be a long term solution? I think this is the
choice
> SpatialLite did since 2.3 version.
You mean
http://www.gaia-gis.it/gaia-sins/spatialite-sql-3.0.0.html#math
hence
http://www.sqlite.org/contrib
--> "extension-functions.c (50.96 KB) contributed by Liam Healy on
2010-02-06 15:45:07
Provide mathematical and string extension functions for SQL queries
using the loadable extensions mechanism. Math: acos, asin, atan, atn2,
atan2, acosh, asinh, atanh, difference, degrees, radians, cos, sin,
tan, cot, cosh, sinh, tanh, coth, exp, log, log10, power, sign, sqrt,
square, ceil, floor, pi. String: replicate, charindex, leftstr,
rightstr, ltrim, rtrim, trim, replace, reverse, proper, padl, padr,
padc, strfilter. Aggregate: stdev, variance, mode, median,
lower_quartile, upper_quartile.
"
If you refer to this file, then it is more related to (your) SQLite
installation rather than GRASS itself since GRASS just calls SQLite.
best,
Markus
as math library is loaded by SQLite
SELECT load_extension('./libsqlitefunctions.so');
but it's not included in SQLite itself (consistently with SQLite
"lightness" strategy),
could be this library managed as an optional library when compiling GRASS
GIS
es: --with-sqlite-math
and then loaded by default (if available) when creating vector support db?
As SQLite is the default db, using this option when compiling GRASS for
binary packages, standard users could have a more powerful "field editor"
using v.db.update.
Please, consider that for many (power)users in Windows using MinGW is
really something arcane...
Do you think this approach might work?
Best regards
Enrico Gallo
[1] http://lists.osgeo.org/pipermail/grass-user/2013-September/068987.html
_______________________________________________
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev
