TrimQuery - open-source query engine that features a SQL-like syntax
The TrimQuery component is a lightweight, open-source query engine that features a SQL-like syntax. For rich web application developers who want to slice and dice their browser-side, in-memory-cached data, TrimQuery is the standards-based, 100% JavaScript solution.
Bookmark:
TrimQuery
The TrimQuery engine from TrimPath is a lightweight GPL/APL open-source component that lets you have the power of SQL queries while running in a web browser. TrimQuery to run in a web browser AND also in any standalone JavaScript interpreter (such as Mozilla Rhino or Spider Monkey). The core TrimQuery engine is meant to have no critical DOM/DHTML/browser dependencies.
Visit Website - http://code.google.com/p/trimpath/wiki/TrimQuery
TrimQuery Features:
- The engine features a SQL-like query language with support for
- INSERT, UPDATE, DELETE
- SELECT ... FROM
- WHERE clauses
- LIKE support
- ORDER BY (sorting on multiple columns, ASC and DESC)
- AS (aliases)
- GROUP BY, HAVING aggregation
- SUM, COUNT, AVG aggregate functions
- self joins
- LIMIT and offsets
- parameterization
Open Souce TrimQuery Information:
- Applies To: JavaScript Framework, HTML, Rich Web Application, SQL
- Programming Language: JavaScript, SQL
- Operating System: Cross-platform
- License: GPL/APL open-source