Data Persistence¶
The modules described in this chapter support storing Python data in a
persistent form on disk. The pickle
and marshal
modules can turn
many Python data types into a stream of bytes and then recreate the objects from
the bytes. The various DBM-related modules support a family of hash-based file
formats that store a mapping of strings to other strings.
The list of modules described in this chapter is:
pickle
--- Python object serialization- Relationship to other Python modules
- Data stream format
- 模組介面
- What can be pickled and unpickled?
- Pickling Class Instances
- Custom Reduction for Types, Functions, and Other Objects
- Out-of-band Buffers
- Restricting Globals
- Performance
- 範例
copyreg
--- 註冊pickle
支援函式shelve
--- Python object persistencemarshal
--- 内部 Python 物件序列化dbm
--- Interfaces to Unix "databases"sqlite3
--- SQLite 資料庫的 DB-API 2.0 介面- Tutorial
- Reference
- Module functions
- Module constants
LEGACY_TRANSACTION_CONTROL
PARSE_COLNAMES
PARSE_DECLTYPES
SQLITE_OK
SQLITE_DENY
SQLITE_IGNORE
apilevel
paramstyle
sqlite_version
sqlite_version_info
threadsafety
version
version_info
SQLITE_DBCONFIG_DEFENSIVE
SQLITE_DBCONFIG_DQS_DDL
SQLITE_DBCONFIG_DQS_DML
SQLITE_DBCONFIG_ENABLE_FKEY
SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
SQLITE_DBCONFIG_ENABLE_QPSG
SQLITE_DBCONFIG_ENABLE_TRIGGER
SQLITE_DBCONFIG_ENABLE_VIEW
SQLITE_DBCONFIG_LEGACY_ALTER_TABLE
SQLITE_DBCONFIG_LEGACY_FILE_FORMAT
SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
SQLITE_DBCONFIG_RESET_DATABASE
SQLITE_DBCONFIG_TRIGGER_EQP
SQLITE_DBCONFIG_TRUSTED_SCHEMA
SQLITE_DBCONFIG_WRITABLE_SCHEMA
- Connection 物件
Connection
Connection.cursor()
Connection.blobopen()
Connection.commit()
Connection.rollback()
Connection.close()
Connection.execute()
Connection.executemany()
Connection.executescript()
Connection.create_function()
Connection.create_aggregate()
Connection.create_window_function()
Connection.create_collation()
Connection.interrupt()
Connection.set_authorizer()
Connection.set_progress_handler()
Connection.set_trace_callback()
Connection.enable_load_extension()
Connection.load_extension()
Connection.iterdump()
Connection.backup()
Connection.getlimit()
Connection.setlimit()
Connection.getconfig()
Connection.setconfig()
Connection.serialize()
Connection.deserialize()
Connection.autocommit
Connection.in_transaction
Connection.isolation_level
Connection.row_factory
Connection.text_factory
Connection.total_changes
- Cursor 物件
- Row 物件
- Blob 物件
- PrepareProtocol 物件
- 例外
- SQLite and Python types
- Default adapters and converters (deprecated)
- 命令列介面
- How-to guides
- How to use placeholders to bind values in SQL queries
- How to adapt custom Python types to SQLite values
- How to convert SQLite values to custom Python types
- Adapter and converter recipes
- How to use connection shortcut methods
- How to use the connection context manager
- How to work with SQLite URIs
- How to create and use row factories
- How to handle non-UTF-8 text encodings
- 解釋