Devart Python Connector for SQLite: SQLite for Python with Built-In Encryption
Devart Python Connector for SQLite is a paid Python database module, $74.95 a year for one developer, that reads and writes SQLite 3 databases from Python 3.10-3.15 on Windows, macOS and Linux. Its main selling point is built-in database encryption (AES, Blowfish, TripleDES and others) in a statically linked SQLite engine, so you can ship encrypted database files without buying an SQLite encryption extension.
Python already ships with the free sqlite3 module, and for an unencrypted local database that's all most people need. This connector earns its price in narrower cases: an app that must keep its SQLite file encrypted on users' PCs, a team that already uses Devart's SQLite tools in .NET, Delphi or ODBC and wants Python to open the same encrypted files, or a company that wants one vendor-supported DB API driver across its databases.
Quick facts
- Version: 1.4.0, released October 22, 2026; first released December 1, 2023
- Developer: Devart
- Package:
pip install devart-sqlite-connector, or wheel files from Devart's download page (4.40 MB for Windows) - Python: 3.10 to 3.15 (1.4 dropped 3.7 to 3.9)
- Databases: SQLite 3.0 and later
- Platforms: Windows 32-bit and 64-bit (and Windows Server), macOS Intel and Apple silicon, Linux 64-bit
- Price: $74.95 a year or $149.95 perpetual for a Single (one developer) license
- Trial: 30 days, for evaluation only, not for production use
- Refund: the order page promises a 30-day money-back guarantee "if you are not satisfied", while Devart's ordering FAQ grants refunds within 30 days only when a technical problem support can't fix stops the product working
- What we checked: the order page charged $74.95 for a Single license with one year of updates on a yearly subscription, and PyPI and Devart's download page both showed version 1.4.0 with wheels for Windows, macOS and Linux, on November 18, 2026. We didn't encrypt or open a database with it
Download Free Trial Buy Now
Overview
Code looks like any DB API 2.0 module: import devart.sqlite, then devart.sqlite.connect(Direct=True, Database="app.db"), a cursor, execute() and fetchall(). Parameters use ? placeholders passed as a list or tuple, which keeps values out of the SQL text.
The connector has two linking modes. In Direct mode it uses its own statically linked SQLite engine, so nothing else has to be installed, and this is the mode that supports encryption. With Direct=False it loads an SQLite library you point to with ClientLibrary, which is useful if you need a specific SQLite build.
Features
Database encryption without an extra license
Python Connector for SQLite encrypts, opens, re-keys and decrypts SQLite databases in Direct mode. You choose the algorithm with PRAGMA ENCRYPTION (TripleDES, Blowfish, AES128, AES192, AES256, Cast128 or RC4) and set or change the key with PRAGMA REKEY. The official SQLite library has no encryption of its own, so the usual alternatives are paid extensions or custom builds.
Encrypted files shared with Devart's other SQLite tools
Python Connector for SQLite uses the same encryption as Devart's dotConnect for SQLite, LiteDAC, UniDAC, dbExpress, ODBC driver, Excel add-in and SSIS components for SQLite. A database encrypted by a Delphi or .NET app built on those can be opened from Python with the same key.
No SQLite library to deploy
Python Connector for SQLite in Direct mode carries its own engine inside the wheel, so a Python app can go to many user PCs without shipping or matching SQLite DLLs. It works with every SQLite version from 3.0.
Pooling and type mapping
Python Connector for SQLite pools connections once connection_pool.enabled = True is set, with min_size, max_size, lifetime and validate settings, and lets one connection opt out with DisablePooling. It maps every SQLite type to a Python type, with options to change the mapping, and handles Unicode text in any language.
Benefits
- Encrypted local data. Customer data in a desktop app's SQLite file stays unreadable without the key.
- One format across languages. Python scripts and Devart-based .NET or Delphi apps read the same encrypted files.
- Simple deployment. A pip install with no native SQLite dependency to manage.
- A supported driver. Paid support and yearly releases that track new Python versions.
Real-World Uses
- Desktop app with sensitive records. A Python point-of-sale or field-service app keeps its local SQLite store encrypted with AES256.
- Reporting on a Delphi app's database. An analyst's Python script reads the encrypted SQLite file written by an application built on LiteDAC.
- Rotating keys. A maintenance script runs
PRAGMA REKEY to change the encryption key on existing databases. - Decrypting for migration. A one-off job decrypts an old database before loading it into another system.
Who It's For, and Who Should Skip It
The connector suits developers who need encrypted SQLite files from Python, especially in companies that already use Devart's SQLite components elsewhere and want the same encryption everywhere.
Skip it if your SQLite database doesn't need encryption: Python's built-in sqlite3 module is free, fast and already installed. Skip it too if your encrypted files must open in other tools such as DB Browser for SQLite or SQLCipher-based apps, because Devart's encryption is only compatible with Devart products.
Usage Guide
- Install with
pip install devart-sqlite-connector, or download the zip of wheels for your Python version and run pip on the .whl file. - After buying, copy the activation key from the order email or Devart's customer portal and run
devart.sqlite.license.activate("<key>") once. - Connect:
conn = devart.sqlite.connect(Direct=True, Database="app.db"). - To encrypt a new database, run
PRAGMA ENCRYPTION with the algorithm, then PRAGMA REKEY with your key; reconnect with the key to open it later. - Query:
cur = conn.cursor(), cur.execute("SELECT * FROM orders WHERE id = ?", [42]), cur.fetchall().
Before you buy
An encrypted database written by this connector can only be opened by Devart's own SQLite products, so plan for that before you encrypt files other tools need to read. PRAGMA ENCRYPTION can't run on a database that's already encrypted: decrypt it first, then encrypt it with the new algorithm. The subscription license also checks its status online, so an offline machine needs the perpetual license.
Where it falls short
- Proprietary encryption format. Files aren't compatible with SQLCipher, SEE or other SQLite encryption tools.
- Competes with a free built-in. Without encryption,
sqlite3 does the same job at no cost. - No asyncio API. It's a synchronous DB API 2.0 driver.
- Closed licensing. The license doesn't allow building public Python packages on it; redistribution needs an OEM license.
Comparisons
Devart vs. Python's sqlite3
Python's standard sqlite3 module is free, needs no install and covers almost every unencrypted use. Devart Python Connector for SQLite costs $74.95 a year and adds built-in encryption, connection pooling and vendor support. Choose it for the encryption; otherwise stay with sqlite3.
Devart vs. SQLCipher bindings
SQLCipher is an open-source encrypted SQLite build with Python bindings and a format many other tools can open. Devart's connector needs no separate build and shares its format with Devart's .NET, Delphi and ODBC products. Pick by which tools must read the files.
Editions and Pricing
| License | 1-year subscription | Perpetual | Who can use it |
|---|
| Single | $74.95 | $149.95 | One developer at one company site |
| Team | $189.95 | On the order page | Up to 4 developers at one company site |
| Site | $339.95 | On the order page | Unlimited developers at one company site |
Buy Now opens the order for Python Connector for SQLite with a Single license on a 1-year subscription; Team, Site, the perpetual license and 2- or 3-year terms are chosen on the order page. An OEM license for shipping the connector inside your own product is arranged with Devart separately.
FAQs
Does Python Connector for SQLite work without installing SQLite?
Yes. Python Connector for SQLite in Direct mode uses its own statically linked SQLite engine, so no SQLite library is needed on the machine.
Can DB Browser for SQLite open a database encrypted by Devart's connector?
No. Python Connector for SQLite's encryption is only compatible with Devart's own SQLite products, such as dotConnect for SQLite, LiteDAC and Devart's ODBC driver for SQLite.
Which encryption algorithms does it support?
Python Connector for SQLite supports TripleDES, Blowfish, AES128, AES192, AES256, Cast128 and RC4, chosen with PRAGMA ENCRYPTION.
Does Python Connector for SQLite support Python 3.9?
No. Python Connector for SQLite 1.4 supports Python 3.10 to 3.15; version 1.4 removed 3.7, 3.8 and 3.9.
Does it run on Apple silicon Macs?
Yes. Python Connector for SQLite ships universal macOS wheels for Intel and Apple silicon, plus Windows and 64-bit Linux wheels.
Can I ship the connector inside an application I sell?
Only with an OEM license. Python Connector for SQLite's Single, Team and Site licenses cover developing and deploying your own scripts and applications within one company.
Can I get a refund on Python Connector for SQLite?
Possibly. Python Connector for SQLite's order page offers a 30-day money-back guarantee if you're not satisfied, but Devart's ordering FAQ describes refunds within 30 days only for technical problems its support can't fix. Use the 30-day trial to be sure before you buy.
System Requirements
- Python 3.10, 3.11, 3.12, 3.13, 3.14 or 3.15 with pip
- Windows 32-bit or 64-bit, Windows Server, macOS (Intel or Apple silicon) or 64-bit Linux
- SQLite 3.0 or later databases
- Internet access for activating and checking a subscription license
Conclusion
Devart Python Connector for SQLite is worth $74.95 a year when you need encrypted SQLite databases in Python, and even more so when the same files are used by Devart-based apps in other languages. For a plain local database, Python's free sqlite3 module is the better choice, and if other tools must open your encrypted files, look at SQLCipher instead. Test the encryption on your own data with the 30-day trial.
Download Free Trial Buy Now