Noodle

Noodle is an in-memory database for JavaScript applications. With it, one can construct dynamic data views of tabular data. Noodle provides set-based data retrieval and updates without SQL.

Noodle may be used with any array-like object.

Noodle is built upon Roots. The Roots library provides a foundation for creating an efficient in-memory database. Its unique list processing structures simplify programming logic and allow the developer to rapidly sort, group, and select data.

Example

// Create a sample data set

var zData = [];
var i, d;
var letters = [
  'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M',
  'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'
];
var noyes = ["No", "Yes"]

for (i = 0; i < 20000; i++) {
  d = (zData[i] = {});
  d["Seq"] = i + 1;
  d["Char1"] = letters[Math.floor(Math.random() * 26)];
  d["YN"] = noyes[Math.floor(Math.random() * 2)];
  d["String3"] = letters[Math.floor(Math.random() * 26)] +
    letters[Math.floor(Math.random() * 26)] +
    letters[Math.floor(Math.random() * 26)];
  d["RNum"] = Math.random() * 10000;
  d["Num"] = Math.floor((Math.random() * 100) + 1);
  d["Date"] = Date.now();
  d["Count"] = 1;
}

// Create a sample data view with Noodle.
// In the header, group by Char1 (bfi=2).  One group per page.
// In the columnar portion, show each unique combination of String3 (bfi=4)
// and Seq (bfi=1) for that page.

var db1 = new Noodle(zData);
db1.InitializeView();
db1.EnterHeader(2);
db1.EnterColumnar(4);
db1.EnterColumnar(1);
db1.GenerateView();

// Get the number of lines on a page.  Pages are numbered, starting with 1.
var page = 1;
var nline = db1.LineCount(page);

// Get a header value.
var bfi = 2;
var text = db1.GetValue(page, 0, bfi);

// Get a columnar value.  Lines and columns are numbered, starting with 1.
line = 1;
bfi = 4;
text = db1.GetValue(page, line, bfi);

// Save a columnar value
db1.PutValue("XYZ", page, line, bfi);

// Save a header value
bfi = 2;
db1.PutValue("Z", page, 0, bfi);

Documentation

Installing Noodle

Noodle Object

Roots Library

List Processing Structures

the Tabular Data Type

Natural Merge Sort with Lists

Demo

NoodleApp - an unhosted web app that exhibits Noodle's capabilities.

Select the "Demo" link to view 20,000 rows of sample data. Try changing data views (screens) from the dropdown. Try building a new screen or modifying an existing screen. Each screen is a different representation of the same 20,000 rows.

Revise data elements from the various screens. One small edit can affect multiple data rows. Use data views to your advantage to minimize data editing chores.

View and revise your own data by selecting either "Open" or "External Link."

License

Copyright © Dan Kranz. All rights reserved.

Licensed under the MIT License.