TrimQuery - A Database Query Engine in 700 Lines of JavaScript Code

JavaScriptSearch
Tuesday, May 9, 2006; 04:36 AM

If you're building the next modern, brilliantly rich web application (like GMail/OddPost/Bloglines), you may find yourself caching lots of domain objects in your browser's memory. If you want to slice and dice that local client-side data cache, try TrimQuery. It's the lightweight alternative to approaches like loading in a Java applet (perhaps with HSQL or Apache Derby) or going with an ActiveX control.

Or worse, you could manually write tons of code to search, join, group-by, aggregate and sort your in-browser data. Instead, why can't you just leverage your familiarity with SQL? TrimQuery lets you bring your SQL knowledge into the web browser.

TrimQuery is a 100% JavaScript query engine that features a powerful, embeddable SQL syntax.  For rich web application developers, the TrimQuery engine from TrimPath is a lightweight GPL open-source component that lets users have the power of SQL queries while running in a web browser. The project website is available at http://trimpath.com/project/wiki/TrimQuery .  Live demo is at http://trimpath.com/demos/test1/trimpath/query_demo.html .

TrimQuery is designed 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.