Skip to main content

Overview

Installation​

// Core
libraryDependencies += "dev.vhonta" %% "scala-ql" % "0.2.0-RC4"

// CSV support
libraryDependencies += "dev.vhonta" %% "scala-ql-csv" % "0.2.0-RC4"

// JSON support
libraryDependencies += "dev.vhonta" %% "scala-ql-json" % "0.2.0-RC4"

// Excel support
libraryDependencies += "dev.vhonta" %% "scala-ql-excel" % "0.2.0-RC4"

// HTML support
libraryDependencies += "dev.vhonta" %% "scala-ql-html" % "0.2.0-RC4"

Use cases​

  • Generating data reports
  • Data exploration

Supported sources​

  • Any scala collection
  • CSV/TSV file
  • JSON file (single line / multiline)
  • Excel

ScalaQL is also able to read from multiple files at once
and walking directory (optionally by GLOB pattern)

Supported sinks​

  • Any scala collection
  • CSV/TSV file
  • JSON file (single line / multiline)
  • Excel
  • HTML

Supported operations​

  • Functional composition (map, flatMap, andThen)
  • Filtering (where, collect)
  • Sub query filtering
  • Group by / aggregate (sum, count, product, avg)
  • Joins (inner, left, cross)
  • ordering
  • distinct
  • union
  • reports