Simple JavaScript Database

Simple JavaScript Database

This example illustrates one way of creating a completely JavaScript database with AMASS storage.This was thrown together and just more or less illustrates the possibility of using AMASS storage and TrimPath query javascript in conjunction for an offline in browser database. Why? The possibility of an offline database would be one of the pieces needed to create an offline AJAX application, something very desirable.

To Use:

First, under the "The Data In Our Database" subheading hit "Save Changes" even if you decide to make no changes to save to AMASS

Then, under the "The SQL Expression" subheading hit "Run SQL" even if you make no changes.

Finally, scroll down to see the results.

The Data In Our Database (Basically an JS array):

Invoice : [ { id: 1, total: 100, custId: 10 }, { id: 2, total: 200, custId: 10 }, { id: 3, total: 300, custId: 10 }, { id: 4, total: 400, custId: 20 } ], Customer : [ { id: 10, acctBalance: 1000 }, { id: 20, acctBalance: 2000 }, { id: 30, acctBalance: 3000 } ]

[ Hit the save button to store to AMASS ]

The Database Structure (Format same as above, JS Array):

Invoice : { id : { type: "String" }, total : { type: "Number" }, custId : { type: "String" } }, Customer : { id : { type: "String" }, acctBalance : { type: "Number" } }

The SQL Expression:

SELECT Customer.id, Customer.acctBalance, Invoice.total FROM Customer, Invoice WHERE Customer.id = Invoice.custId ORDER BY Customer.id

[ Scroll below for results ]

Debug Output:

The Results: