Skip to main content

sqlce

C++ Python Platform License Reverse engineered

Ru README

Reverse engineering of the .sdf (SQL Server Compact Edition) binary file format.

Analysis of the format's internal structure based on decompiled SQL CE components. The goal is to provide a cross-platform, runtime-independent implementation for reading .sdf files.

Intended solely for interoperability with existing .sdf files. Does not contain any original product source code.

Browser version (WebAssembly, runs locally - the file never leaves your tab): boykopovar.github.io/sqlce

  • core/ - C++ parser implementation
  • bindings/ - Bindings for the C++ library to other languages
  • python/sqlce/ - Python API
  • research/ - Experimental scripts

Example

pip install sqlce
from sqlce import SqlceDatabase

db = SqlceDatabase("example.sdf", password="secret123")

for table_name in db.list_tables():
    print(table_name, db.table_schema(table_name))
    for row in db.read_table(table_name):
        print(row)

The current implementation supports reading the list of tables, table schemas, and table contents (including password-protected databases). It is implemented in C++.

Testing

pytest

The tests use a locally installed SQL CE engine (via ODBC) to generate .sdf files containing predefined data and verify that the parser produces identical results. Therefore, the test suite can only be run on Windows with SQL Server Compact 4.0 installed. Test files are created in tests/sdf/ and are automatically removed before and after each test run.

Documentation

The documentation is currently concise but includes usage examples and tests.

Documentation

Code Style Conventions (Pull requests are welcome.)

Download files

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

Source Distribution

sqlce-0.2.5.tar.gz (91.3 kB view details)

Uploaded Source

Built Distributions

If you're not sure about the file name format, learn more about wheel file names.

sqlce-0.2.5-cp313-cp313-win_amd64.whl (206.4 kB view details)

Uploaded CPython 3.13Windows x86-64

sqlce-0.2.5-cp313-cp313-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (258.3 kB view details)

Uploaded CPython 3.13manylinux: glibc 2.17+ x86-64

sqlce-0.2.5-cp312-cp312-win_amd64.whl (206.4 kB view details)

Uploaded CPython 3.12Windows x86-64

sqlce-0.2.5-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (258.0 kB view details)

Uploaded CPython 3.12manylinux: glibc 2.17+ x86-64

sqlce-0.2.5-cp311-cp311-win_amd64.whl (204.7 kB view details)

Uploaded CPython 3.11Windows x86-64

sqlce-0.2.5-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (259.1 kB view details)

Uploaded CPython 3.11manylinux: glibc 2.17+ x86-64

sqlce-0.2.5-cp310-cp310-win_amd64.whl (202.3 kB view details)

Uploaded CPython 3.10Windows x86-64

sqlce-0.2.5-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (258.0 kB view details)

Uploaded CPython 3.10manylinux: glibc 2.17+ x86-64

sqlce-0.2.5-cp39-cp39-win_amd64.whl (203.0 kB view details)

Uploaded CPython 3.9Windows x86-64

sqlce-0.2.5-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (258.2 kB view details)

Uploaded CPython 3.9manylinux: glibc 2.17+ x86-64

sqlce-0.2.5-cp38-cp38-win_amd64.whl (202.9 kB view details)

Uploaded CPython 3.8Windows x86-64

sqlce-0.2.5-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (257.7 kB view details)

Uploaded CPython 3.8manylinux: glibc 2.17+ x86-64

File details

Details for the file sqlce-0.2.5.tar.gz.

File metadata

  • Download URL: sqlce-0.2.5.tar.gz
  • Upload date:
  • Size: 91.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.14

File hashes

Hashes for sqlce-0.2.5.tar.gz
Algorithm Hash digest
SHA256 b230f3aae583143197e3cb8359a5091d3af7986292abc9f6beca2a79de0565bf
MD5 8ec44d0667b621402dc23bb341937d1e
BLAKE2b-256 c0ba479a96a1f5171927a71f227dcfafe373a4ddb5f8710b89651a76a9be19e4

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.2.5.tar.gz:

Publisher: release.yml on boykopovar/sqlce

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file sqlce-0.2.5-cp313-cp313-win_amd64.whl.

File metadata

  • Download URL: sqlce-0.2.5-cp313-cp313-win_amd64.whl
  • Upload date:
  • Size: 206.4 kB
  • Tags: CPython 3.13, Windows x86-64
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.14

File hashes

Hashes for sqlce-0.2.5-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 6fd04f31a342a4db3ba52ec6d0bc6a7dadd3eb3efb696c096152e6296e4b378a
MD5 23c5b0c77a177ce5c7efcd9783f94a19
BLAKE2b-256 ee9a0edc10da5a083a640b5004a41d401a7465436198bc2b616979fca2859e84

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.2.5-cp313-cp313-win_amd64.whl:

Publisher: release.yml on boykopovar/sqlce

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file sqlce-0.2.5-cp313-cp313-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for sqlce-0.2.5-cp313-cp313-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 2102e9262f8ab98178ed2700c5be16d0cdfa1035799a8e9c7e23d6b9be53a226
MD5 57f1809cc675d57b72a01cf87cf17d88
BLAKE2b-256 d1da9c085e067b6272980265083fba4445edbfc9d5ab2b77624da471e760a9a1

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.2.5-cp313-cp313-manylinux_2_17_x86_64.manylinux2014_x86_64.whl:

Publisher: release.yml on boykopovar/sqlce

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file sqlce-0.2.5-cp312-cp312-win_amd64.whl.

File metadata

  • Download URL: sqlce-0.2.5-cp312-cp312-win_amd64.whl
  • Upload date:
  • Size: 206.4 kB
  • Tags: CPython 3.12, Windows x86-64
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.14

File hashes

Hashes for sqlce-0.2.5-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 2b58809506b78528f3944a3a66ab84427009facaa58adadbf2fda681e1946dc6
MD5 2ffedb7976b206f79999e39d3254db2a
BLAKE2b-256 26df47848138a896e016b74dca96472756ba287ec0ba4ced95f2cef10746a80e

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.2.5-cp312-cp312-win_amd64.whl:

Publisher: release.yml on boykopovar/sqlce

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file sqlce-0.2.5-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for sqlce-0.2.5-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 15451f393b5925a7410f97344b02bcc8848d066889a396fb4e2abc32392927f3
MD5 0517781e9f3173dd024d47ec68cac5ad
BLAKE2b-256 44905c72af1de71f1b1898c031a17b816749e88617d48242b28657001b2ba9b8

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.2.5-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl:

Publisher: release.yml on boykopovar/sqlce

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file sqlce-0.2.5-cp311-cp311-win_amd64.whl.

File metadata

  • Download URL: sqlce-0.2.5-cp311-cp311-win_amd64.whl
  • Upload date:
  • Size: 204.7 kB
  • Tags: CPython 3.11, Windows x86-64
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.14

File hashes

Hashes for sqlce-0.2.5-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 b214fca4fe8e7e0438c88eb6c8951a10842b7d00b8d8ba2ee35e09cf32f0b385
MD5 2402cd91b11e75b125cff716bfe478c2
BLAKE2b-256 c3ac223ac24457873007f2950b5094c141fbcd080e08b7f3582067bd7b9af3e3

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.2.5-cp311-cp311-win_amd64.whl:

Publisher: release.yml on boykopovar/sqlce

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file sqlce-0.2.5-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for sqlce-0.2.5-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 0efe306c3de3a8cb13b999d6e7b6f4cedd4e114c6b0cd22b70bb0aec443f39b9
MD5 da8b328d6c5887610ba9dba4bd5df125
BLAKE2b-256 6baf845d891445c8447139c1ab490aa78774426c1cfa3de8a893dfbd38e01c70

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.2.5-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl:

Publisher: release.yml on boykopovar/sqlce

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file sqlce-0.2.5-cp310-cp310-win_amd64.whl.

File metadata

  • Download URL: sqlce-0.2.5-cp310-cp310-win_amd64.whl
  • Upload date:
  • Size: 202.3 kB
  • Tags: CPython 3.10, Windows x86-64
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.14

File hashes

Hashes for sqlce-0.2.5-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 cfb009a812c13c06890c0e0131140f94ffed24df82ad7f124ecf9cae385e2e23
MD5 205bb19743fcf15747afb203a06c6a8e
BLAKE2b-256 3d5744c137a5bb7345648cc780b61fb9e7e1be5a2a5ea9011a07c5eccf519a0a

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.2.5-cp310-cp310-win_amd64.whl:

Publisher: release.yml on boykopovar/sqlce

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file sqlce-0.2.5-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for sqlce-0.2.5-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 46899075532eafd0f9e25c30f9acd088259fd648000764e647536687818c10db
MD5 f48e1300905a985f9a591809a04d20b6
BLAKE2b-256 daa0a2eb047ecfc2b8b371590c8e14981e5c6d2a626b7ba4a42797c107f5ea74

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.2.5-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl:

Publisher: release.yml on boykopovar/sqlce

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file sqlce-0.2.5-cp39-cp39-win_amd64.whl.

File metadata

  • Download URL: sqlce-0.2.5-cp39-cp39-win_amd64.whl
  • Upload date:
  • Size: 203.0 kB
  • Tags: CPython 3.9, Windows x86-64
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.14

File hashes

Hashes for sqlce-0.2.5-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 0bcf0d88e9435679b0ada1549462b3104fb144eabdf91562c24702a9a4feb3b3
MD5 6c2676d80c57b1d1e1863ac0697ddbd9
BLAKE2b-256 398139d149c77438442984647ef2139de532f7d7da06ac5e119dbb458575f80a

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.2.5-cp39-cp39-win_amd64.whl:

Publisher: release.yml on boykopovar/sqlce

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file sqlce-0.2.5-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for sqlce-0.2.5-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 b6e50b30d9d420d493b36b6f017424a3054a568cce10abc6e192fca313d5a8b1
MD5 5a90d1a8720d14a99ecd77a98cad0778
BLAKE2b-256 d9d86de1fd32e22d941babe6b9eca28ed0da31015028b378b5875cfc79c89deb

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.2.5-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl:

Publisher: release.yml on boykopovar/sqlce

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file sqlce-0.2.5-cp38-cp38-win_amd64.whl.

File metadata

  • Download URL: sqlce-0.2.5-cp38-cp38-win_amd64.whl
  • Upload date:
  • Size: 202.9 kB
  • Tags: CPython 3.8, Windows x86-64
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.14

File hashes

Hashes for sqlce-0.2.5-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 13ab8f3b5423069f5eeeb767b90464b05406312abe85a656678af5b9065fdb8f
MD5 c331b50a380d56591f07d1fcdce24c51
BLAKE2b-256 9ed24b4d63a781b4c65804a0f91cbb054101dbeebefc9d952ed6599c4e381e16

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.2.5-cp38-cp38-win_amd64.whl:

Publisher: release.yml on boykopovar/sqlce

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file sqlce-0.2.5-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for sqlce-0.2.5-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 2d28293f675ee6f891237c90582299155f6cfc74d4a637bec191421306c47ec2
MD5 dae42188f919a36cd9485d910c6aa5d4
BLAKE2b-256 bc9b6425210f2a9acb26a9d625fc4b07a6502c31a7a087b368ef898d2aff9614

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.2.5-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl:

Publisher: release.yml on boykopovar/sqlce

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Release history Release notifications | RSS feed

0.3.1

13 files

0.3.0

13 files

0.2.9

13 files

0.2.8

13 files

0.2.7

13 files

0.2.6

13 files

This release

0.2.5 This release

13 files

0.2.4

13 files

0.2.3

13 files

0.2.2

13 files

0.2.1

13 files

0.2.0

13 files

0.1.9

13 files

0.1.8

13 files

0.1.7

13 files

0.1.6

13 files

0.1.5

13 files

0.1.4

13 files

0.1.3

13 files

0.1.2

13 files

0.1.1

8 files

0.1.0

3 files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page