jSQL (javascript Query Language) is a persistent client-side database and SQL engine that uses various methods to save a database to the user's hard drive for cross-browser persistence. jSQL can store nearly any type of data, from strings and numbers to functions and complex instances of custom objects. jSQL uses shims and low level APIs to support a wide range of browsers while maintaining efficiency without requiring any 3rds party libraries like jQuery.

Persistence Management

• jSQL.load
• jSQL.commit
• jSQL.rollback
• jSQL.tables

Storage APIs

• jSQL.setApiPriority
• jSQL.getApi

Querying the Database

• jSQL.query
• jSQL.createTable
• jSQL.select
• jSQL.insertInto
• jSQL.dropTable
• jSQL.update
• jSQL.deleteFrom

jSQLTable class

• jSQLTable.name
• jSQLTable.columns
• jSQLTable.data
• jSQLTable.colmap
• jSQLTable.renameColumn
• jSQLTable.addColumn
• jSQLTable.loadData
• jSQLTable.insertRow

jSQLQuery interface

• jSQLQuery.ifNotExists
• jSQLQuery.ignore
• jSQLQuery.execute
• jSQLQuery.fetch
• jSQLQuery.fetchAll
• jSQLQuery.values
• jSQLQuery.set
• jSQLQuery.where
• jSQLQuery.from
• jSQLQuery.limit
• jSQLQuery.orderBy
• jSQLQuery.asc
• jSQLQuery.desc
• jSQLQuery.distinct

jSQLWhereClause class

• jSQLWhereClause.where
• jSQLWhereClause.equals
• jSQLWhereClause.preparedLike
• jSQLWhereClause.doesNotEqual
• jSQLWhereClause.lessThan
• jSQLWhereClause.contains
• jSQLWhereClause.endsWith
• jSQLWhereClause.beginsWith
• jSQLWhereClause.and
• jSQLWhereClause.or
• jSQLWhereClause.limit
• jSQLWhereClause.orderBy
• jSQLWhereClause.asc
• jSQLWhereClause.desc
• jSQLWhereClause.execute

jSQL Helper Methods

• jSQL.reset
• jSQL.minify
• jSQL.export
• jSQL.import

jSQL Syntax

• SELECT Query syntax
• CREATE Query syntax
• UPDATE Query syntax
• INSERT Query syntax
• DROP Query syntax
• DELETE Query syntax

Fun with DataTypes

• Supported Types
• Creating custom DataTypes

Error Handling

• jSQL.onError
• jSQL_Error Exception Class
• Error Codes

Examples

License