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