Is there a cross database ORM mapper for Node.js which provides a consistent API for database access across different relational databases (say MySQL, MS SQL Server, Postgres, Oracle ..). The database page shows different libraries for database access, but I would like to use a library which lets me switch to any database during production.
Might also want to take a look at bookshelf.js (MySql, SQLite, PostgreSQL)
It's one of the only ones with transaction support and proper eager loading of relations.
For huge projects: http://bookshelfjs.org/ For small projects: https://github.com/knyga/light-orm
I just wrote my own ORM https://github.com/jbaylina/syncorm
Now there is only one driver for mySQL, but it should be easy to write other drivers for different databases.
The main difference with the rest of ORMs is that the whole database is loaded in memory.
You can access the database as regular javascript objects synchronously. (one object is one record). The objects can be related one each other ina one to many / many to one relation.
It is very useful to use Underscore to iterate thru the objecs.
To modify the objects, you just write in those objects and call commit() to save all the changes to the database in a single transaction.
