JSSQL：一个完全用JavaScript框架开发的数据库引擎
openkk
12年前
JSSQL是一个数据库引擎完全采用JavaScript开发。它可以让开发人员在一个离线数据库中阐释和执行SQL语句。 It has a conversion class developed in PHP for use with relational databases (ex. PostgreSQL, MySQL, etc..) that generates a series of data files, then the database engine in JavaScript (JSSQL) accesses the data through SQL querys and return a set of records, similar to any database engine. This is useful for querying offline databases dynamically without increasing the work of the web server or better yet: without the need for a database serve。
该引擎可以解释具有以下结构JavaScriptSQL SQL查询：
SELECT [DISTINCT] * | select_expresion [ AS alias_field ] [, ...] FROM table_name [table_name] [, ...] [ WHERE where_condition ] [ GROUP BY field_number [, ... ] [HAVING having_condition ] ] [ ORDER BY field_number [ ASC | DESC ] [, ...] ] [ LIMIT amount ]它具有以下特性：
- Allows offline data query without the intervention of Web servers or database servers.
- Allows flexible SQL syntax, accepting the use of tables and fields aliases with case-insensitive terms and llows the use of multiple spaces, so that the writing of SQL querys is simple and intuitive.
- Allows use of all JavaScript functions and operators so that is totally intuitive for JavaScript developers. Allows the use of functions externally defined by users.
- Allows the definition and use of indexes to speed up the queries.
- It allows table pagination so you can use tables with lot of records without overloading the memory used by the browser.
- Includes functionality for text search within documents indexed by the indexer JSBD_Indexador and associated with link data types defined at the database tables .
- Allows creation of JavaScript databases using the converter JSBD_Conversor from PostgreSQL and MySQL engines.
- Clearly reports syntax and runtime errors, and loading of the database and SQL queries.
- Provide debug mechanisms to help the development, maintenance and testing of the engine.
- Use a clear structure for the definition of database structures, data storing and indexes. Using JSON structures.
- Use and installation is simple, with low requirements and compatible with most popular browsers.