Clinton Wolfe
and 1 contributors

NAME

Class::ReluctantORM::Driver::SQLite - SQLite driver for CRO

SYNOPSIS

  # See Class::ReluctantORM::Driver

DRIVER IDIOSYNCRACIES

Supports any version of sqlite supported by DBD::SQLite.

SQLite is itself fairly idiosyncratic. Here are how they impact this driver:

No RETURNING support on INSERT/UPDATE/DELETE

Since SQLite doesn't support this SQL extension, and DBD::SQLite doesn't support using output binds to read them (a hack the Oracle DBD provides), you can't use RETURNING to get columns from INSERT/UPDATE/DELETE statements you provide in SQL, nor can you add output columns to SQL objects performing those operations. Worse, if your model uses refresh_on_update columns, they must be fetched by a separate SELECT (handled internally by the Driver, but you need to be aware of the penalty).

Column names forced to be lowercase