life-db v0.0.2

LifeDB

What is LifeDB??

It is a lighweight, JSON based, no-sql formatted data base for browser and also for node environment. The program is intelligent enough to detect the environment where it is running and modify itself for performence.

How does the DB work??

In browser environment the DB use HTML5 sessionStorage for storing the data. If sessionStorage is not availeble it uses the window object of browser. In that case data will not be preserved after closing the page. Users also can avoid using sessionStorage by not backing up the database and reduce memory usage of browser

In node environment the DB works as a flat file database. i.e. the data will be stored in a text file, also user can avoid the storing of data by not backing up the database. If the data file already exists then the data will be restored autometically in time of initiation of the datbase

Version

0.0.2

Change log

• Bug fix for node environment
• Bug fix in initiating the database
• Documentation for using in node-environment

Requirements

For browser environment

• Internet Explorer ( >=8.0 )
• GoogleChrome ( >=4.0 )
• FireFox ( >=3.5 )
• Safari ( >= 4.0 )
• Opera ( >=11.5 )

For node environment

• fs (>=0.0.2)
• node (>=0.10.37) (Developped in this version)

Installation

For browser environment

• Download the Life-db files
• Unzip the archive and copy the file "life-db-min.js"
• Include "life-db-min.js" in your project (Check the usage guide for details).
• Prepare the object of LifeDB (Check the usage guide for details).
• Start using the methods and classes available under the LifeDB class to generate charts in your project.

For node environment

• Type the following command in your console inside your project folder. Note: Super user authentication may be needed

    npm install life-db

• Include life-db in your project's page wher you are going to use life-db (Check the usage guide for details).
• Prepare the object of LifeDB (Check the usage guide for details).
• Start using the metholds and classes available under the LifeDB class to generate charts in your project..

Usage Guide

For browser environment

• Step 1: Copy the life-db-min.js or life-db.js file inside your project. (Check the file description for details about the files inside the archive)
• Step 2: Write a script tag in the section of the page where you want to use LifeDB as follows

<script type="text/javascript" src="life-db-min.js"></script>

• Step 3: Prepare an object of LifeDB

  var ldb = new LifeDB("my-db"); // my-db is the database name

• Step 4: Start using methods of LifeDB

For node environment

• Step 1: Include LifeDB inside your page

var ldb = require('life-db');

• Step 2: Prepare the object of LifeDB with database name

var obj = new ldb.LifeDB("my-db");

• Step 4: Start using methods of LifeDB from the object "obj"

Function Description

This section contains the description of the public methods availeble in LifeDB class.

• 1> The constructor

When the database is initialized the constructor is called. The parameters of the constructor is described below.

Usage "Browser"

 var ldb = new LifeDB("my-db"); // my-db is the database name

Usage "node"

 var ldb = require('life-db'),
     obj = new ldb.LifeDB("my-db"); // my-db is the database name

Note: If previous backed up data exists in sessionStorage or in data file(for Node environment) the data will be restored autometically in time of initializing the database

• 2> insert

insert method can be used for inserting single or multiple data in the database

Usage "Browser"

 var ldb = new LifeDB("my-db"); // my-db is the database name
 // inserting list of records
 ldb.insert("student", [{name: "angshu", age: 27}, {name: "shyamol", age: 20}, {name: "uttam", age: 30}], true);
 // inserting a single record
 ldb.insert("student", {name: "angshu", age: 27}, true);

Usage "node"

 var ldb = require('life-db'),
     obj = new ldb.LifeDB("my-db"); // my-db is the database name
 // inserting list of records
 obj.insert("student", [{name: "angshu", age: 27}, {name: "shyamol", age: 20}, {name: "uttam", age: 30}], true);
 // inserting a single record
 obj.insert("student", {name: "angshu", age: 27}, true);

Note: You can use a insert method from inside a loop to insert multiple data as record format

• 3> find

ilnsert method can be used for inserting single or multiple data in the database

The function returns a list of records. If no records matched the query or the page is empty then empty array will be returned

Usage "Browser"

/*
* Assume that the database "my-db" is created and it holds 1 page named "student" and 3 records as follows
* {name: "angshu", age: 27}, {name: "shyamol", age: 20}, {name: "uttam", age: 30}
*/

// the following query will return all of the records of "student" page
result = ldb.find("student", "");

// Following query will return [{name: "angshu", age: 27}]
ldb.find("student", "age @eq 27");

// Following query will return []
ldb.find("student", "age @gt 27 && age @lt 30");

// Following query will return [{"name":"shyamol","age":20},{"name":"uttam","age":30}]
ldb.find("student", "",[1,2]);

// Following query will return ["name":"shyamol","age":20}, {"name":"angshu","age":27}, {"name":"uttam","age":30}]
ldb.find("student", "","",["age", "asc"]);

Usage "Node"

/*
* Assume that the database "my-db" is created and it holds 1 page named "student" and 3 records as follows
* {name: "angshu", age: 27}, {name: "shyamol", age: 20}, {name: "uttam", age: 30}
*/

// the following query will return all of the records of "student" page
result = obj.find("student", "");

// Following query will return [{name: "angshu", age: 27}]
obj.find("student", "age @eq 27");

// Following query will return []
obj.find("student", "age @gt 27 && age @lt 30");

// Following query will return [{"name":"shyamol","age":20},{"name":"uttam","age":30}]
obj.find("student", "",[1,2]);

// Following query will return ["name":"shyamol","age":20}, {"name":"angshu","age":27}, {"name":"uttam","age":30}]
obj.find("student", "","",["age", "asc"]);

Note: Check the operator description for the supported logical and comparison operators.

• 4> remove

insert method can be used for inserting single or multiple data in the database

The function returns a the number of effected rows.

Usage "Browser"

/*
* Assume that the database "my-db" is created and it holds 1 page named "student" and 3 records as follows
* {name: "angshu", age: 27}, {name: "shyamol", age: 20}, {name: "uttam", age: 30}
*/

// the following query will return 1 as 1 record is deleted from the "student" page
ldb.remove("student", "name @eq angshu");

Usage "Node"

/*
* Assume that the database "my-db" is created and it holds 1 page named "student" and 3 records as follows
* {name: "angshu", age: 27}, {name: "shyamol", age: 20}, {name: "uttam", age: 30}
*/

// the following query will return 1 as 1 record is deleted from the "student" page
obj.remove("student", "name @eq angshu");

• 5> update

Update method can be used to update record/records from page of database

The function returns a the number of effected rows.

Usage

/*
* Assume that the database "my-db" is created and it holds 1 page named "student" and 3 records as follows
* {name: "angshu", age: 27}, {name: "shyamol", age: 20}, {name: "uttam", age: 30}
*/

// the following query will return 1 as 1 record is updated from the "student" page
ldb.update("student", "name @eq angshu", {name: "angshu", age: 30});

• 6> destroy

Update method can be used to update record/records from page of database

The function returns true if the destruction successfull, false otherwise Usage

/*
* Assume that the database "my-db" is created and it holds 1 page named "student" and 3 records as follows
* {name: "angshu", age: 27}, {name: "shyamol", age: 20}, {name: "uttam", age: 30}
*/

// the following will return true if the desctruction of database successfull
ldb.destroy("my-db");

Operator description

There are two kinds of operators supported in LifeDB

• Comparison operator

• Logical operator

File Description