Note: If you just need PostgreSQL you might want to have a look at ringo-pgclient.
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, Oracle (XE) and PostgreSQL. H2 is part of the package, so you can start right off using it without the hassle of installing and configuring a database.
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 is available at https://github.com/grob/ringo-sqlstore/wiki
SQLstore is heavily inspired by
- ringo-hibernate by Robert Thurnher
- Helma (the predecessor of RingoJS)
- Hibernate Project