Slick 3.2.1Loading… manual

Supported Databases

Other SQL databases can be accessed right away with a reduced feature set. Writing a fully featured plugin for your own SQL-based backend can be achieved with a reasonable amount of work. Support for other backends (like NoSQL) is under development but not yet available.

The following capabilities are supported by the profiles. A checkmark means that a capability is fully supported. In other cases it may be partially supported or not at all. See the individual profile’s API documentation for details.

CapabilityDB2DerbyH2HsqldbMySQLOraclePostgresSQLiteSQLServer
relational.other✅✅✅✅✅✅✅✅✅
relational.columnDefaults✅✅✅✅✅✅✅✅✅
relational.foreignKeyActions✅✅✅✅✅✅✅✅
relational.functionDatabase✅✅✅✅✅✅✅
relational.functionUser✅✅✅✅✅✅✅✅
relational.indexOf✅✅✅✅✅✅✅✅✅
relational.joinFull✅✅✅✅✅
relational.joinLeft✅✅✅✅✅✅✅✅✅
relational.joinRight✅✅✅✅✅✅✅✅
relational.likeEscape✅✅✅✅✅✅✅✅✅
relational.pagingDrop✅✅✅✅✅✅✅✅✅
relational.pagingNested✅✅✅✅✅✅✅✅
relational.pagingPreciseTake✅✅✅✅✅✅✅✅✅
relational.repeat✅✅✅✅✅✅✅✅
relational.replace✅✅✅✅✅✅✅✅
relational.reverse✅✅✅✅✅✅
relational.setByteArrayNull✅✅✅✅✅✅✅✅✅
relational.typeBigDecimal✅✅✅✅✅✅✅✅
relational.typeBlob✅✅✅✅✅✅✅✅
relational.typeLong✅✅✅✅✅✅✅✅✅
relational.zip✅✅✅✅✅✅✅
sql.other✅✅✅✅✅✅✅✅✅
sql.sequence✅✅✅✅✅✅✅
sql.sequenceCurr✅✅✅✅✅✅✅
sql.sequenceCycle✅✅✅✅✅✅✅
sql.sequenceLimited✅✅✅✅✅✅✅✅
sql.sequenceMax✅✅✅✅✅✅✅✅
sql.sequenceMin✅✅✅✅✅✅✅✅
jdbc.other✅✅✅✅✅✅✅✅✅
jdbc.booleanMetaData✅✅✅✅✅
jdbc.createModel✅✅✅✅✅✅✅✅✅
jdbc.defaultValueMetaData✅✅✅✅✅✅✅✅
jdbc.distinguishesIntTypes✅✅✅✅✅✅
jdbc.forUpdate✅✅✅✅✅✅✅✅
jdbc.forceInsert✅✅✅✅✅✅✅✅
jdbc.insertOrUpdate✅
jdbc.mutable✅✅✅✅✅✅✅✅
jdbc.nullableNoDefault✅✅✅✅✅✅✅
jdbc.returnInsertKey✅✅✅✅✅✅✅✅✅
jdbc.returnInsertOther✅✅✅✅
jdbc.supportsByte✅✅✅