KludgeHack

TrimQuery

The TrimQuery engine from TrimPath is a lightweight GPL open-source component that lets you have the power of SQL queries while running in a web browser.

For rich web application developers, TrimQuery makes it very easy to manage local client-side data cache on the browser, instead of caching lots of objects in the browser memory.

The code is very lightweight (around 700 lines of code) and written entirely in javascript, and can really simplify the work of manually writing code to manage data. Brings the power of search, join, group-by, aggregate and sort data in SQL to the web browser.

The core TrimQuery engine is meant to have no critical DOM/DHTML/browser dependencies.

The engine features a SQL-like query language with support for…

• SELECT … FROM
• WHERE clauses
• 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

More information:

• TrimQuery API
• TrimQuery SQL Syntax
• TrimQuery Downloads
• TrimQuery Community Wiki
• TrimQuery Browser Compatibility
• TrimQuery demo page