Taboo

Simple tabular data manipulation in Javascript, providing:

• Column insert and delete
• Row insert and delete
• Update and delete rows where constraints satisfied
• Left and inner join
• Pretty print

Gzipped it comes in at less than 3kb.

Docs at http://mrmagooey.github.io/taboo/

Installation

Bower:

bower install taboo

NPM:

npm install taboo

Requires Lodash.js to be available.

Get Started

Make a table

> var table1 = new Taboo();
    

Put some stuff in said table

> table1.addRows([
{animal:"cow", sound:"moo", color:"white"},
{animal:"pig", sound:"oink", color:"pink"},
{animal:"duck", sound:"quack", color:"brown"},
{animal:"horse", sound:"neigh", color:"brown"},
{animal:"dog", sound:"woof", color:"brown"},
]); 

Pretty print the table

> table1.print()
animal          | sound           | color           | 
cow             | moo             | white           | 
pig             | oink            | pink            | 
duck            | quack           | brown           | 
horse           | neigh           | brown           | 
dog             | woof            | brown           | 

Get a list of all animals

> table1.getColumn('animal')
['cow', 'pig', 'duck', 'horse', 'dog'] 

Get the rows containing brown animals

> table1.getRowsWhere({'color':'brown'}, {objects:false})

[
 [
  "duck",
  "quack",
  "brown"
 ],
 [
  "horse",
  "neigh",
  "brown"
 ],
 [
  "dog",
  "woof",
  "brown"
 ]
] 

Make a second table, using arrays rather than objects

> var table2 = new Taboo();
// need to tell it what the columns are before adding arrays
> table2.addColumns(['animal', 'in animal farm?']);
> table2.addRows([
['cow', true], 
['pig', true], 
['dog', false],
['porcupine', false]
]);
> table2.print();
animal          | in animal farm? | 
cow             | true            | 
pig             | true            | 
dog             | false           | 
porcupine       | false           | 

Join the two tables

> var joinTable = table1.joinLeft('animal', table2, 'animal');
> joinTable.print()

animal          | sound           | in animal farm? | 
cow             | moo             | true            | 
pig             | oink            | true            | 
duck            | quack           | undefined       | 
horse           | neigh           | undefined       | 
dog             | woof            | false           | 

Performance

It's probably two orders of magnitude slower than a real database, but this seems to be fine for tables with less than a 1000 rows. If this is a problem, consider using [sql.js] (https://github.com/kripken/sql.js) if you need better performance or features.