DBD::SQLite::Constants - common SQLite constants
| Use Case | Command | Description |
|---|---|---|
| Import all constants | use DBD::SQLite::Constants qw/:all/; | All constant groups at once |
| Import result codes only | use DBD::SQLite::Constants qw/:result_codes/; | Basic SQLite result codes (SQLITE_OK, etc.) |
| Import extended result codes | use DBD::SQLite::Constants qw/:extended_result_codes/; | Detailed error codes |
| Import authorizer action codes | use DBD::SQLite::Constants qw/:authorizer_action_codes/; | SQL actions for authorizer callbacks |
| Import authorizer return codes | use DBD::SQLite::Constants qw/:authorizer_return_codes/; | Authorizer return values (SQLITE_DENY, SQLITE_IGNORE) |
| Import datatypes | use DBD::SQLite::Constants qw/:datatypes/; | SQLite fundamental datatypes |
| Import file open flags | use DBD::SQLite::Constants qw/:file_open/; | Flags for sqlite3_open_v2 |
| Import function flags | use DBD::SQLite::Constants qw/:function_flags/; | Flags for sqlite3_create_function |
| Import version numbers | use DBD::SQLite::Constants qw/:version/; | Compile-time version number |
| Import database config options | use DBD::SQLite::Constants qw/:database_connection_configuration_options/; | Options for sqlite3_db_config |
| Import runtime limit categories | use DBD::SQLite::Constants qw/:run_time_limit_categories/; | Limits for sqlite3_limit |
| Import DBD::SQLite string modes | use DBD::SQLite::Constants qw/:dbd_sqlite_string_mode/; | String mode constants for DBD::SQLite |
| Import transaction state values | use DBD::SQLite::Constants qw/:allowed_return_values_from_sqlite3_txn_state/; | Return values from sqlite3_txn_state |
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_THREADSperl v5.34.0 2022-02-06 DBD::SQLite::Constants(3pm)
Generated by phpman v4.9.26-5-g7740029 Author: Che Dong Under GNU General Public License
2026-08-24 07:51 @216.73.216.102
CrawledBy Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)