The sqlean-math extension provides common math functions for SQLite versions compiled without the SQLITE_ENABLE_MATH_FUNCTIONS flag.
Provides following functions:
- rounding:
math_round,math_ceil,math_floor,math_trunc; - logarithmic:
math_ln,math_log10,math_log2,math_log; - arithmetic:
math_pow,math_sqrt,math_mod; - trigonometric:
math_cos,math_sin,math_tan; - hyperbolic:
math_cosh,math_sinh,math_tanh; - inverse trigonometric:
math_acos,math_asin,math_atan,math_atan2; - inverse hyperbolic:
math_acosh,math_asinh,math_atanh; - angular measures:
math_radians,math_degrees; - constants:
math_pi.
Adapted from SQLite source code (func.c).
SQLite command-line interface:
sqlite> .load ./math
sqlite> select math_sqrt(9);
See How to install an extension for usage with IDE, Python, etc.
↓ Download the extension.
⛱ Explore other extensions.
★ Subscribe to stay on top of new features.