Type:
Class
Constants:
NATIVE_DATABASE_TYPES : { primary_key: 'INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL', string: { name: "varchar", limit: 255 }, text: { name: "text" }, integer: { name: "integer" }, float: { name: "float" }, decimal: { name: "decimal" }, datetime: { name: "datetime" }, timestamp: { name: "datetime" }, time: { name: "time" }, date: { name: "date" }, binary: { name: "blob" }, boolean: { name: "boolean" } }

The SQLite3 adapter works SQLite 3.6.16 or newer with the sqlite3-ruby drivers (available as gem from rubygems.org/gems/sqlite3).

Options:

  • :database - Path to the database file.

sqlite_version

sqlite_version() Instance Protected methods

2015-06-20 00:00:00
exec_update

exec_update(sql, name = 'SQL', binds = []) Instance Public methods Alias for:

2015-06-20 00:00:00
active?

active?() Instance Public methods

2015-06-20 00:00:00
change_column_null

change_column_null(table_name, column_name, null, default = nil) Instance Public methods

2015-06-20 00:00:00
supports_statement_cache?

supports_statement_cache?() Instance Public methods Returns true, since this

2015-06-20 00:00:00
valid_alter_table_options

valid_alter_table_options( type, options) Instance Public methods See:

2015-06-20 00:00:00
exec_query

exec_query(sql, name = nil, binds = []) Instance Public methods

2015-06-20 00:00:00
allowed_index_name_length

allowed_index_name_length() Instance Public methods Returns 62. SQLite supports

2015-06-20 00:00:00
explain

explain(arel, binds = []) Instance Public methods DATABASE STATEMENTS =====

2015-06-20 00:00:00
clear_cache!

clear_cache!() Instance Public methods Clears the prepared statements cache

2015-06-20 00:00:00