{"library":"sqlcipher3","title":"sqlcipher3: DB-API 2.0 interface for SQLCipher 4.x","type":"library","description":"sqlcipher3 provides a DB-API 2.0 compatible interface for SQLCipher 4.x, allowing encrypted SQLite databases. It wraps SQLCipher's C library and supports transparent 256-bit AES encryption of database files. Current version 0.6.2, requires Python >=3.9. Pre-built wheels available for many platforms; on some systems you may need to compile from source.","language":"python","status":"active","last_verified":"Fri May 01","install":{"commands":["pip install sqlcipher3","pip install sqlcipher3-binary"],"cli":null},"imports":["from sqlcipher3 import connect","from sqlcipher3 import dbapi2"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":null,"github":"https://github.com/coleifer/sqlcipher3","docs":null,"changelog":null,"pypi":"https://pypi.org/project/sqlcipher3/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"import os\nfrom sqlcipher3 import dbapi2 as sqlite\n\nconn = sqlite.connect(':memory:')\nconn.execute(\"PRAGMA key='secret'\")\nconn.execute('CREATE TABLE test (id INTEGER PRIMARY KEY, value TEXT)')\nconn.execute('INSERT INTO test VALUES (1, \"hello\")')\nprint(conn.execute('SELECT * FROM test').fetchone())\nconn.close()","lang":"python","description":"Create an in-memory encrypted database. PRAGMA key must be set before any other operations.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}