Skip to main content

New level of functionality and performance in data access via Python

Project description

Python Connector for SQLite

Python Connector for SQLite is a connectivity solution for accessing SQLite databases from Python applications. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows, macOS, and Linux.

Direct connection

The connector supports two SQLite library linking modes: static linking and dynamic linking. Static linking enables a direct connection to SQLite, so you don't have to deploy the SQLite libraries on user workstations. You can use the built-in encryption capabilities in the Direct mode to protect your data from unauthorized access?the statically linked library provides SQLite database encryption without requiring you to purchase an encryption extension.

Using the connector

To retrieve data from a database:

Import the module.

import devart.sqlite

Connect to a database using the connect() module method and obtain a connection object: If you're using the Direct mode:

my_connection = devart.sqlite.connect(
    Direct=True,
    Database="your_database"
)

If you're using a dynamically linked SQLite client library:

my_connection = devart.sqlite.connect(
    Direct=False,
    Database="your_database",
    ClientLibrary="your_sqlite_lib"
)

Create a cursor object using the cursor() connection method.

my_cursor = my_connection.cursor()

Execute the SQL statement using the execute() cursor method.

my_cursor.execute("SELECT * FROM employees")

Retrieve the result set using one of the fetch*() cursor methods.

for row in my_cursor.fetchall(): 
    print(row)

Ordering and activating the license

You can purchase a license for the connector on the ordering page:
https://www.devart.com/python/sqlite/ordering.html

To activate the license, follow the instructions in the documentation:
https://docs.devart.com/python/sqlite/activate-a-license.htm

What's new

Python Connector for SQLite 1.2

  • Added support for Python 3.13

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

devart_sqlite_connector-1.2.0-cp313-cp313-win_amd64.whl (1.3 MB view details)

Uploaded CPython 3.13 Windows x86-64

devart_sqlite_connector-1.2.0-cp313-cp313-win32.whl (1.1 MB view details)

Uploaded CPython 3.13 Windows x86

devart_sqlite_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.13 manylinux: glibc 2.34+ x86-64

devart_sqlite_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl (4.6 MB view details)

Uploaded CPython 3.13 macOS 10.13+ universal2 (ARM64, x86-64)

devart_sqlite_connector-1.2.0-cp312-cp312-win_amd64.whl (1.3 MB view details)

Uploaded CPython 3.12 Windows x86-64

devart_sqlite_connector-1.2.0-cp312-cp312-win32.whl (1.1 MB view details)

Uploaded CPython 3.12 Windows x86

devart_sqlite_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.12 manylinux: glibc 2.34+ x86-64

devart_sqlite_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl (4.6 MB view details)

Uploaded CPython 3.12 macOS 10.9+ universal2 (ARM64, x86-64)

devart_sqlite_connector-1.2.0-cp311-cp311-win_amd64.whl (1.3 MB view details)

Uploaded CPython 3.11 Windows x86-64

devart_sqlite_connector-1.2.0-cp311-cp311-win32.whl (1.1 MB view details)

Uploaded CPython 3.11 Windows x86

devart_sqlite_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.11 manylinux: glibc 2.34+ x86-64

devart_sqlite_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl (4.6 MB view details)

Uploaded CPython 3.11 macOS 10.9+ universal2 (ARM64, x86-64)

devart_sqlite_connector-1.2.0-cp310-cp310-win_amd64.whl (1.3 MB view details)

Uploaded CPython 3.10 Windows x86-64

devart_sqlite_connector-1.2.0-cp310-cp310-win32.whl (1.1 MB view details)

Uploaded CPython 3.10 Windows x86

devart_sqlite_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.10 manylinux: glibc 2.34+ x86-64

devart_sqlite_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl (4.6 MB view details)

Uploaded CPython 3.10 macOS 10.9+ universal2 (ARM64, x86-64)

devart_sqlite_connector-1.2.0-cp39-cp39-win_amd64.whl (1.3 MB view details)

Uploaded CPython 3.9 Windows x86-64

devart_sqlite_connector-1.2.0-cp39-cp39-win32.whl (1.1 MB view details)

Uploaded CPython 3.9 Windows x86

devart_sqlite_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.9 manylinux: glibc 2.34+ x86-64

devart_sqlite_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl (4.6 MB view details)

Uploaded CPython 3.9 macOS 10.9+ universal2 (ARM64, x86-64)

devart_sqlite_connector-1.2.0-cp38-cp38-win_amd64.whl (1.3 MB view details)

Uploaded CPython 3.8 Windows x86-64

devart_sqlite_connector-1.2.0-cp38-cp38-win32.whl (1.1 MB view details)

Uploaded CPython 3.8 Windows x86

devart_sqlite_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.8 manylinux: glibc 2.34+ x86-64

devart_sqlite_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl (4.6 MB view details)

Uploaded CPython 3.8 macOS 10.9+ universal2 (ARM64, x86-64)

devart_sqlite_connector-1.2.0-cp37-cp37m-win_amd64.whl (1.3 MB view details)

Uploaded CPython 3.7m Windows x86-64

devart_sqlite_connector-1.2.0-cp37-cp37m-win32.whl (1.1 MB view details)

Uploaded CPython 3.7m Windows x86

devart_sqlite_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.7m manylinux: glibc 2.34+ x86-64

devart_sqlite_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.7m macOS 10.9+ x86-64

File details

Details for the file devart_sqlite_connector-1.2.0-cp313-cp313-win_amd64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 08d19f4fefcdde5446456a53334c0fb94c97b309a5da9f3f4e3d8cdd65475ba4
MD5 d2aa20159244e07f8ad7165b2846db8d
BLAKE2b-256 5727f5d5fd6246c27d2ca07a70a424683c2b5aadf98e6c3062e36503fe3e683b

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp313-cp313-win32.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp313-cp313-win32.whl
Algorithm Hash digest
SHA256 71fc7617b4d6bb980f38cb6034919be0b8a4e931838d19aa408ef8074a924c42
MD5 56a4b23317cc51335915790607014c61
BLAKE2b-256 48a3f2ab90b7012013dd9e03178343914b8279045d048550da5e15c35da322f6

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 165fcb336d37d7ee917820dc5754837b46f21fc2dffe2841249f146cda4f7085
MD5 62c8d60e8bfed9555c3d5e61c2b1b2b5
BLAKE2b-256 296e6695e1158fb7ee9ff6a629479e17e4e88d7bf67f05b981ca87fe894679d1

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl
Algorithm Hash digest
SHA256 4f05bf81c0c895c81ba1aafc7c0b00b1b6684f02bd89e2da145095b459738a60
MD5 5bf7965c040df4bf13ba197fbaad3386
BLAKE2b-256 4e4963ddd898013efb6f8e794f4cad57b0e0b4f9bf790c94404ca7f0f6112fd9

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp312-cp312-win_amd64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 80c5d72291c0524285db411b648c497660a70ec72bd763f2a36dbc65a3e3af2b
MD5 54b30e1a64ed4be5be08cebd717fee79
BLAKE2b-256 1ed56642a7889039dd529e2e2a9a25b2c892b7e2352de20b8ae92bbe9531d5be

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp312-cp312-win32.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 db641306101e7ce85ba8e76b2f0e9853bdd109aef3fe279f95030ca8607d2839
MD5 159d6aca2ce9645ebd9de42f13faffb5
BLAKE2b-256 fd95bac6272852359a09b0e1f75d047c2e44c403ea0f2127a74b05942e6a6b64

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 3d1e14cf59d2a827736e4a3493ad81d25c4eecf08722ff32b44648e2ad805f53
MD5 be663865eddd6b5ccab993f4ba9e9c3e
BLAKE2b-256 be50041a1f1a2722ce5095d6dcc6c7b22561e43aae4eee27a4acaaf8155a0898

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 a4dcc1e309dc6d93ee6be5e4dd18c8170c1e89024d45c15d1c88013b8d8c8b65
MD5 c8615d14b53bf8aa2084afd4cf0815f5
BLAKE2b-256 5aaeb34ef88374860fcda6974d95f5b127f420aa1a6554bf85169d913bd6aefa

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 bed777c346625a5941e74b21c7e6e0cb9f7129df865e26c2810484c89b9230a5
MD5 a67c6a0585bc785fcd9fad574e386630
BLAKE2b-256 610ad2624102afa858c6ad488e69901af6419bef8b7d7915b2411c86f826b6fa

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp311-cp311-win32.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 cf5b9e82ebf8cd09c31a431c6be08fe9816343935207156e4865957e92d79f53
MD5 678b377319d5f68bbcff98a134f09123
BLAKE2b-256 0600e65df8a7557d88652964f54b7f6b991b4da4fef8d9f2a9f502c5b13d86a4

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 43be4030c898ea9b88b56a60228a50979900916294d03a9ed40e336d9c904bfe
MD5 4765c88d0135cb9317fc3d4938257a63
BLAKE2b-256 da9beb196403ca5393d1747284ced9c758f4b367c889072be1ab432d3a9f2544

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 bb4d2cbc46f235f0324f0606bfcfba89bc4c9496ccacae27dfe66f3d15e9ffa9
MD5 0fb199c0fc25cc8d8d4447bc36ffe3a4
BLAKE2b-256 fd20cd4aafd4c5598413d0b6cf60b9ab747e9ba0fae3452f37eddc777af18ca4

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp310-cp310-win_amd64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 3ba7357d035ef0193596042fb30132cffcc6f2577e6f14296ca8c0ab9e4ef0bc
MD5 62575ffe8be61ca2bda5793834b31e1b
BLAKE2b-256 75e82237bf02b207ad21eea16a99bace2d22a8c3155d6dd9389ce7f6f1c1b112

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp310-cp310-win32.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 017ac04bfeadad5bdea2a2415192cdce18f05928a6819c15d8963eae7f177247
MD5 9fb9d9daa534cfdc1a950b55dd091ac4
BLAKE2b-256 502d27580c2b538bc568caff679c245395de7513e72778b6054636744298d6e7

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 6963a1c1b23f7480d538f61cac4485718a5886eb39e2519bfe9f335a3f2a5b52
MD5 dd4bb2f36434eb4a6c2545bbd50690e6
BLAKE2b-256 137f5c76fba7979661267cdbca335ef6b2983ba10631dda0f9ebc3e458047271

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 a9fc37d8127526c61ed179d1733a08864fb84cecca721276c497f1c3b738f587
MD5 a9634381e80df3cfa6a32bae5033570b
BLAKE2b-256 fc886dcf72035ddf11fdfba7caafc4cfae6ea8a601842d0d07e896d7038fb4e8

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp39-cp39-win_amd64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 c1f4b62b31859429c4a4b89f76683d692c046651e2f255f3a1ff38f2d016d9fd
MD5 9be8af4516794d55ab32f272624d3e5e
BLAKE2b-256 e7c5246e8532ae934ef5a4e5fa6bbf8fce4cefcea39f2255ece1e543312bcb4e

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp39-cp39-win32.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 6d351ddc3f3503b15b7d9f63eb3626f9e44fd286855c25e3d7d3962749b95f6e
MD5 b79d9e637c8c7619fd068818ef3abefa
BLAKE2b-256 0c869fc66df082483cea9173231fa217cf125f76dfc9ab7bdf10e4bd75abf5f9

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 1c687bb81df99dbb9bd0fe17dda3eb915b1c4fa98db86db6615587415cc7f52e
MD5 fbbdffac0edd1b26ed92a0c576d66522
BLAKE2b-256 8d53836847fde87a5ae7cdaac017ef4b1e21809b2ed0cd9a42a804fd55a6d9a7

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 46a2ee7c3756608f4bd0ee4b4328109059b13a41ff1151aac20c76183e34ad6a
MD5 c0f78d067f3ec7b998b0f5800bae70c2
BLAKE2b-256 e14e285d303e059db3edb4b05e2eaecf78e431c5fff266c2a0234b961c016602

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp38-cp38-win_amd64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 8608bf721be798048eadf5d7ab00e51f24650b147a41f9960795955e64496a6a
MD5 c9aac3509d07484b081fcadf862feded
BLAKE2b-256 34785678545b08f4c5071ddf1cda14417ab219e78198a97cc9e5c2bc5d0d3463

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp38-cp38-win32.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 663098ca95ecc0c6c958c292a458f1ef265cb2bdf0d5e2208e1b0ac4e40297d7
MD5 8c170b1980c8f13ccbcd80152bdfb476
BLAKE2b-256 540790ad4fcb9caf330f79bc01ae43b3f2b5cd475f56e07cfb7c8837d0e84f58

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 db67d2208c88cbf5f810d06ee5f8eef56e2b0cd152c497d6e7d12eb9d1f93cd9
MD5 c816bf1547251193f72ef8883c9daad6
BLAKE2b-256 886b77faf8c43eb3ea72d4b87ee84857a0c2335f8597c3a785cfc033b6e283b4

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 38b18ddce5878204b51b18558cc3e3ee2c990e906cd52aaabd13b8166818e983
MD5 b2aec43fff4e5e9f5b66685a00b76616
BLAKE2b-256 9b9420357115d1c725a0393fdc98b1b94300372ef3f945ddae386b649ba33c3b

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp37-cp37m-win_amd64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 355650762f535dddcfc1db2671a2506118069954089caddf339c6faacadef538
MD5 5a7eee1e691a2b78b359e932dc84808b
BLAKE2b-256 148e30c74e1b2dafae467bbe7b9629be4efda6cefa5a6733dd94a42aec070070

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp37-cp37m-win32.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 47955d9701fd7fd17a3b6eb0a73f13facb135a59d5147d20f21b0996c52e2b06
MD5 25d6850b2daa7e88ccccf310301631c0
BLAKE2b-256 ab2bd80b023f98d80bbd250e6d7499e96075779b6f2ce727bfc3037338f3fce8

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 ad20b0396838579760155145d999e8619e3a04525db163ea27afae49ef3ef6f9
MD5 d7c2bcd0edbee418505dbddb6b3a560d
BLAKE2b-256 ce123ab187bb31d6aa62748f8110f22ccea6c4e17f1fea7e4f9b43ab866d66b1

See more details on using hashes here.

File details

Details for the file devart_sqlite_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl.

File metadata

File hashes

Hashes for devart_sqlite_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm Hash digest
SHA256 3fb752ce7853ec29cd5b84896116d1b2452266870140f15292264d995ccd6542
MD5 a7762e3618fe936854f007c59d3f4c43
BLAKE2b-256 d007d6c71765819fb9856650e871878d78c810d494b95f44a9248ea9054954ec

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page