SQL

ROM supports SQL databases via rom-sql adapter which currently uses Sequel under the hood. The adapter ships with an enhanced Relation that supports sql-specific query DSL and association macros that simplify constructing joins.

Refer to the Getting Started and Explicit Setup pages for information on how to setup ROM with a specific adapter.

Following connection URI schemes are supported:

• ado
• amalgalite
• cubrid
• db2
• dbi
• do
• fdbsql
• firebird
• ibmdb
• informix
• jdbc
• mysql
• mysql2
• odbc
• openbase
• oracle
• postgres
• sqlanywhere
• sqlite
• swift
• tinytds

For details on specifying database connection URLs please refer to the Connecting to a database Sequel page.