Home

Welcome to the spleen-node wiki!

Roadmap

• 1.1.0: support for the nil literal.

• 1.2.0: support for reordering statements given an ordered set of field targets.

• 1.3.0: support for array predicate operators (any, all, none).

• 1.4.0: support for date and time literals.

• 1.5.0: support for the search and nsearch operators, which allow for full-text index queries.

• 1.6.0: support for geospatial queries:

  • Literals
    • Coordinate
    • Box
    • Polygon
    • Ellipses
    • Plane
    • Path
  • Operators
    • Compare whether or not a coordinate is within a box, polygon, or ellipses.
    • Compare whether or not two bounding boxes intersect.
    • Compare whether or not two paths intersect.

• 1.7.0: normalize() method that simplifies expressions, and standardizes the order of tuples in a Clause.

• 1.8.0: support for arithmetic operators:

  • Add
  • Subtract
  • Multiply
  • Divide
  • Modulus

• 1.9.0: support for string functions:

  • Concat
  • Substring
  • Reverse
  • Replace
  • Index of character
  • Last index of character
  • Char at index
  • Upper case
  • Lower case
  • Trim
  • Right trim
  • Left trim
  • Repeat
  • Ends with
  • Starts with
  • Pad left
  • Pad right

• 1.10.0: support for date and time functions:

  • Now
  • Add minutes
  • Add hours
  • Add days
  • Add weeks
  • Add years
  • Subtract minutes
  • Subtract hours
  • Subtract days
  • Subtract weeks
  • Subtract years
  • Year
  • Month
  • Day of week

• 1.11.0: support for math functions and constants:

  • Absolute value
  • Arccosine
  • Hyperbolic arccosine
  • Arcsine
  • Hyperbolic arcsine
  • Arctangent
  • Hyperbolic arctangent
  • Arctangent of the quotient of two numbers
  • Cube root
  • Ceiling
  • Cosine
  • Hyperbolic cosine
  • Exponent of Euler's constant
  • Floor
  • Square root of the sum of squares
  • Natural logarithm
  • Base 10 logarithm
  • Base 2 logarithm
  • Max of two or more numbers
  • Min of two ore more numbers
  • Exponents
  • Pseudo-random number
  • Round
  • Sine
  • Hyperbolic sine
  • Square root
  • Tangent
  • Hyperbolic tangent
  • Truncate