What is JSQL?
JSQL is a JavaScript library built to provide access to the browsers IndexedDB database using SQL query strings.
What is SQL?
- SQL stands for Structured Query Language
- SQL lets you access and manipulate databases
- SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987
What Can JSQL do?
- JSQL can execute queries against a database
- JSQL can retrieve data from a database
- JSQL can insert records in a database
- JSQL can update records in a database
- JSQL can delete records from a database
- JSQL can create new databases
- JSQL can create new tables in a database
SQL is a Standard BUT....
Although SQL is an ANSI/ISO standard, there are different versions of the SQL language. To be compliant with the ANSI standard, we support at least the major commands (such as SELECT
, UPDATE
, DELETE
, INSERT
, and WHERE
) in a similar manner.