DBD::SQLite::Constants - common SQLite constants
| Use Case | Command | Description |
|---|---|---|
| Import all constants | use DBD::SQLite::Constants qw/:all/; | Load every available constant tag |
| Import result codes | use DBD::SQLite::Constants qw/:result_codes/; | Load basic SQLite result codes (SQLITE_OK, SQLITE_ERROR, etc.) |
| Import extended result codes | use DBD::SQLite::Constants qw/:extended_result_codes/; | Load detailed error codes (SQLITE_IOERR_READ, SQLITE_CONSTRAINT_UNIQUE, etc.) |
| Import file open flags | use DBD::SQLite::Constants qw/:file_open/; | Load flags for sqlite3_open_v2 (SQLITE_OPEN_READONLY, etc.) |
| Import data types | use DBD::SQLite::Constants qw/:datatypes/; | Load fundamental SQLite datatypes (SQLITE_INTEGER, SQLITE_FLOAT, etc.) |
| Import authorizer action codes | use DBD::SQLite::Constants qw/:authorizer_action_codes/; | Load codes for sqlite3_set_authorizer (SQLITE_CREATE_TABLE, SQLITE_INSERT, etc.) |
| Import authorizer return codes | use DBD::SQLite::Constants qw/:authorizer_return_codes/; | Load SQLITE_DENY and SQLITE_IGNORE |
| Import database configuration options | use DBD::SQLite::Constants qw/:database_connection_configuration_options/; | Load SQLITE_DBCONFIG_* constants |
| Import string mode constants | use DBD::SQLite::Constants qw/:dbd_sqlite_string_mode/; | Load DBD_SQLITE_STRING_MODE_* constants |
| Import function flags | use DBD::SQLite::Constants qw/:function_flags/; | Load SQLITE_DETERMINISTIC, SQLITE_DIRECTONLY, etc. |
| Import runtime limit categories | use DBD::SQLite::Constants qw/:run_time_limit_categories/; | Load SQLITE_LIMIT_* constants |
| Import version numbers | use DBD::SQLite::Constants qw/:version/; | Load SQLITE_VERSION_NUMBER |
| Import transaction state values | use DBD::SQLite::Constants qw/:allowed_return_values_from_sqlite3_txn_state/; | Load SQLITE_TXN_NONE, SQLITE_TXN_READ, SQLITE_TXN_WRITE |
use DBD::SQLite::Constants qw/:result_codes/;
You can import necessary SQLite constants from this module. Available tags are "all", "allowed_return_values_from_sqlite3_txn_state", "authorizer_action_codes", "authorizer_return_codes", "version" ("compile_time_library_version_numbers"), "database_connection_configuration_options", "dbd_sqlite_string_mode", "extended_result_codes", "file_open" ("flags_for_file_open_operations"), "function_flags", "datatypes" ("fundamental_datatypes"), "result_codes", "run_time_limit_categories". See http://sqlite.org/c3ref/constlist.html for the complete list of constants.
This module does not export anything by default.
SQLITE_TXN_NONESQLITE_TXN_READSQLITE_TXN_WRITESQLITE_CREATE_INDEXSQLITE_CREATE_TABLESQLITE_CREATE_TEMP_INDEXSQLITE_CREATE_TEMP_TABLESQLITE_CREATE_TEMP_TRIGGERSQLITE_CREATE_TEMP_VIEWSQLITE_CREATE_TRIGGERSQLITE_CREATE_VIEWSQLITE_DELETESQLITE_DROP_INDEXSQLITE_DROP_TABLESQLITE_DROP_TEMP_INDEXSQLITE_DROP_TEMP_TABLESQLITE_DROP_TEMP_TRIGGERSQLITE_DROP_TEMP_VIEWSQLITE_DROP_TRIGGERSQLITE_DROP_VIEWSQLITE_INSERTSQLITE_PRAGMASQLITE_READSQLITE_SELECTSQLITE_TRANSACTIONSQLITE_UPDATESQLITE_ATTACHSQLITE_DETACHSQLITE_ALTER_TABLESQLITE_REINDEXSQLITE_ANALYZESQLITE_CREATE_VTABLESQLITE_DROP_VTABLESQLITE_FUNCTIONSQLITE_COPYSQLITE_SAVEPOINTSQLITE_RECURSIVESQLITE_DENYSQLITE_IGNORESQLITE_VERSION_NUMBERSQLITE_DBCONFIG_LOOKASIDESQLITE_DBCONFIG_ENABLE_FKEYSQLITE_DBCONFIG_ENABLE_TRIGGERSQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZERSQLITE_DBCONFIG_ENABLE_LOAD_EXTENSIONSQLITE_DBCONFIG_MAINDBNAMESQLITE_DBCONFIG_NO_CKPT_ON_CLOSESQLITE_DBCONFIG_ENABLE_QPSGSQLITE_DBCONFIG_TRIGGER_EQPSQLITE_DBCONFIG_MAXSQLITE_DBCONFIG_RESET_DATABASESQLITE_DBCONFIG_DEFENSIVESQLITE_DBCONFIG_WRITABLE_SCHEMASQLITE_DBCONFIG_LEGACY_ALTER_TABLESQLITE_DBCONFIG_DQS_DMLSQLITE_DBCONFIG_DQS_DDLSQLITE_DBCONFIG_ENABLE_VIEWSQLITE_DBCONFIG_LEGACY_FILE_FORMATSQLITE_DBCONFIG_TRUSTED_SCHEMADBD_SQLITE_STRING_MODE_PVDBD_SQLITE_STRING_MODE_BYTESDBD_SQLITE_STRING_MODE_UNICODE_NAIVEDBD_SQLITE_STRING_MODE_UNICODE_FALLBACKDBD_SQLITE_STRING_MODE_UNICODE_STRICTSQLITE_IOERR_LOCKSQLITE_IOERR_READSQLITE_IOERR_SHORT_READSQLITE_IOERR_WRITESQLITE_IOERR_FSYNCSQLITE_IOERR_DIR_FSYNCSQLITE_IOERR_TRUNCATESQLITE_IOERR_FSTATSQLITE_IOERR_UNLOCKSQLITE_IOERR_RDLOCKSQLITE_IOERR_DELETESQLITE_IOERR_BLOCKEDSQLITE_IOERR_NOMEMSQLITE_IOERR_ACCESSSQLITE_IOERR_CHECKRESERVEDLOCKSQLITE_IOERR_CLOSESQLITE_IOERR_DIR_CLOSESQLITE_LOCKED_SHAREDCACHESQLITE_IOERR_SHMOPENSQLITE_IOERR_SHMSIZESQLITE_IOERR_SHMLOCKSQLITE_BUSY_RECOVERYSQLITE_CANTOPEN_NOTEMPDIRSQLITE_IOERR_SHMMAPSQLITE_IOERR_SEEKSQLITE_CORRUPT_VTABSQLITE_READONLY_RECOVERYSQLITE_READONLY_CANTLOCKSQLITE_ABORT_ROLLBACKSQLITE_CANTOPEN_ISDIRSQLITE_IOERR_DELETE_NOENTSQLITE_CANTOPEN_FULLPATHSQLITE_READONLY_ROLLBACKSQLITE_CONSTRAINT_CHECKSQLITE_CONSTRAINT_COMMITHOOKSQLITE_CONSTRAINT_FOREIGNKEYSQLITE_CONSTRAINT_FUNCTIONSQLITE_CONSTRAINT_NOTNULLSQLITE_CONSTRAINT_PRIMARYKEYSQLITE_CONSTRAINT_TRIGGERSQLITE_CONSTRAINT_UNIQUESQLITE_CONSTRAINT_VTABSQLITE_IOERR_MMAPSQLITE_NOTICE_RECOVER_WALSQLITE_NOTICE_RECOVER_ROLLBACKSQLITE_IOERR_GETTEMPPATHSQLITE_BUSY_SNAPSHOTSQLITE_WARNING_AUTOINDEXSQLITE_IOERR_CONVPATHSQLITE_CANTOPEN_CONVPATHSQLITE_CONSTRAINT_ROWIDSQLITE_READONLY_DBMOVEDSQLITE_AUTH_USERSQLITE_IOERR_VNODESQLITE_IOERR_AUTHSQLITE_IOERR_BEGIN_ATOMICSQLITE_IOERR_COMMIT_ATOMICSQLITE_IOERR_ROLLBACK_ATOMICSQLITE_ERROR_MISSING_COLLSEQSQLITE_ERROR_RETRYSQLITE_READONLY_CANTINITSQLITE_READONLY_DIRECTORYSQLITE_LOCKED_VTABSQLITE_CORRUPT_SEQUENCESQLITE_ERROR_SNAPSHOTSQLITE_CANTOPEN_DIRTYWALSQLITE_CANTOPEN_SYMLINKSQLITE_CONSTRAINT_PINNEDSQLITE_OK_SYMLINKSQLITE_IOERR_DATASQLITE_BUSY_TIMEOUTSQLITE_CORRUPT_INDEXSQLITE_IOERR_CORRUPTFSSQLITE_OPEN_READONLYSQLITE_OPEN_READWRITESQLITE_OPEN_CREATESQLITE_OPEN_NOMUTEXSQLITE_OPEN_FULLMUTEXSQLITE_OPEN_SHAREDCACHESQLITE_OPEN_PRIVATECACHESQLITE_OPEN_URISQLITE_OPEN_MEMORYSQLITE_OPEN_NOFOLLOWSQLITE_OPEN_SUPER_JOURNALSQLITE_DETERMINISTICSQLITE_DIRECTONLYSQLITE_SUBTYPESQLITE_INNOCUOUSSQLITE_INTEGERSQLITE_FLOATSQLITE_BLOBSQLITE_NULLSQLITE_OKSQLITE_ERRORSQLITE_INTERNALSQLITE_PERMSQLITE_ABORTSQLITE_BUSYSQLITE_LOCKEDSQLITE_NOMEMSQLITE_READONLYSQLITE_INTERRUPTSQLITE_IOERRSQLITE_CORRUPTSQLITE_NOTFOUNDSQLITE_FULLSQLITE_CANTOPENSQLITE_PROTOCOLSQLITE_EMPTYSQLITE_SCHEMASQLITE_TOOBIGSQLITE_CONSTRAINTSQLITE_MISMATCHSQLITE_MISUSESQLITE_NOLFSSQLITE_AUTHSQLITE_FORMATSQLITE_RANGESQLITE_NOTADBSQLITE_ROWSQLITE_DONESQLITE_NOTICESQLITE_WARNINGSQLITE_LIMIT_LENGTHSQLITE_LIMIT_SQL_LENGTHSQLITE_LIMIT_COLUMNSQLITE_LIMIT_EXPR_DEPTHSQLITE_LIMIT_COMPOUND_SELECTSQLITE_LIMIT_VDBE_OPSQLITE_LIMIT_FUNCTION_ARGSQLITE_LIMIT_ATTACHEDSQLITE_LIMIT_LIKE_PATTERN_LENGTHSQLITE_LIMIT_VARIABLE_NUMBERSQLITE_LIMIT_TRIGGER_DEPTHSQLITE_LIMIT_WORKER_THREADSGenerated by phpman v4.9.26-1-g511901d · Markdown · JSON · MCP Author: Che Dong Under GNU General Public License
2026-08-08 14:33 @216.73.216.150
CrawledBy Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Enhanced by LLM: deepseek-v4-flash / taotoken.net / www.chedong.com - original format