data-table

2023-10-21

A library providing a data-table class, and useful functionality around this

Upstream URL

github.com/AccelerationNet/data-table

License

BSD
README

Data Table

A Common Lisp library providing a data-table data-structure that has rows of data and column names and types

  • reading/writing values by row/column or index
  • combining data-tables as overlapping square regions
  • pulling sub tables from a data table
  • comparing data from two data-tables
  • conversion from data-tables of strings into data-tables of lisp-values, automatically guessing types if necessary
  • converting from / two other common-lisp data-structures (lists of alists/plists)

Goals

  • easier interaction with databases by having a common data-structure that can be queried and inserted
  • generating complex reports that contain multiple sections on a single spreadsheet of data
  • make getting/setting values anywhere in the results easier

Authors

;; Copyright (c) 2011 Russ Tyndall , Acceleration.net http://www.acceleration.net
;; All rights reserved.
;;
;; Redistribution and use in source and binary forms, with or without
;; modification, are permitted provided that the following conditions are
;; met:
;;
;;  - Redistributions of source code must retain the above copyright
;;    notice, this list of conditions and the following disclaimer.
;;
;;  - Redistributions in binary form must reproduce the above copyright
;;    notice, this list of conditions and the following disclaimer in the
;;    documentation and/or other materials provided with the distribution.
;;
;; THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
;; "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
;; LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
;; A PARTICULAR PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL THE COPYRIGHT
;; OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
;; SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
;; LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
;; DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
;; THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
;; (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
;; OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

Dependencies (8)

  • alexandria
  • cl-interpol
  • clsql
  • clsql-helper
  • collectors
  • iterate
  • lisp-unit2
  • symbol-munger

Dependents (1)

  • GitHub
  • Quicklisp