Home

Ringo SQLstore

Ringo SQLstore is a lightweight ORM/storage implementation for RingoJS. It uses JDBC for communication with databases. Current features are:

• Creation of tables and sequences
• Transaction support
• Lazy loading
• One-to-one, one-to-many and many-to-many mappings
• Connection pooling
• Object caching
• Easy SQL-like querying

Currently supported databases are H2, MySQL (5.x), Oracle (XE) and PostgreSQL (8.x). H2 is part of the package, so you can start right off using it without the hassle of installing and configuring a database.

Status

Although Ringo SQLstore is pre-1.0, it has been used in production in various applications for several years now. Nevertheless chances are that on the way to version 1.0 there will be incompatible API changes.

Documentation

• Basics
• Mapping definition
• Queries
• Transactions
• Object and query caches

Acknowledgements

SQLstore is heavily inspired by

• ringo-hibernate by Robert Thurnher
• Helma (the predecessor of RingoJS)
• Hibernate Project