Home

jSQL Docs

v1.4

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 Helper Methods

• jSQL.reset
• jSQL.minify

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