Home

jSQL

v1.1

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.

---

Table of Contents

• Persistence Management
  • jSQL.load
  • jSQL.persist
  • jSQL.tables
• 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.execute
  • jSQLQuery.fetch
  • jSQLQuery.fetchAll
  • jSQLQuery.values
  • jSQLQuery.set
  • jSQLQuery.where
  • jSQLQuery.from
• 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 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
• Examples
• License