SequelSphere will manage the structured data within your web application at the point of the browser, providing SQL access to the data.
SQL Support (4)
The SELECT statement is the key ingredient of any good relational database systems. As such, great care has been taken to fully support the ANSI standard SELECT statement including all major clauses and features. Everything from outer joins, to many layered sub-selects, to complex grouping sets are supported. To see the full set of supported SELECT functionality, please read SequelSphere Support for the SELECT Statement .
Yes. You can write both scalar and aggregate functions, include them in the database’s catalog, and then reference them from your SQL statements. See the Installation and Usage Notes for more information.
Indexes are not currently supported, but are on the roadmap for implementation. SequelSphere has been sufficiently fast (and the client-side data sufficiently small) such that indexes are not required for speed. If indexes are desired for enforcing uniqueness, developers will need to guarantee uniqueness within their code instead (until indexes are officially supported).
Yes! Utilizing the latest HTML 5 standards ( local storage , IndexedDB , ), SequelSphere will persist the data stored onto the client’s machine to be accessed across browser restarts.
Yup. To make it work in a disconnected state, your entire web application must utilize an HTML 5 “manifest”. To find out more about this, try the following URL:
SequelSphere is a client-side database, and thus not intended to store large amounts of data. Furthermore, each browser places a limit (normally 5 megabytes) on how much data it will allow websites to store locally on the hard-drive. Never the less, SequelSphere does not place restrictions on the amount of data loaded at runtime, and thus will support whatever the client machine’s browser will allow.