Skip to main content

sqlce

C++ Python Platform License Reverse engineered

Ru README

Reverse engineering of the .sdf (SQL Server Compact Edition 4.0) 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.

  • 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 SdfDatabase

db = SdfDatabase("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.1.3.tar.gz (52.4 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.1.3-cp313-cp313-win_amd64.whl (160.2 kB view details)

Uploaded CPython 3.13Windows x86-64

sqlce-0.1.3-cp313-cp313-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (198.1 kB view details)

Uploaded CPython 3.13manylinux: glibc 2.17+ x86-64

sqlce-0.1.3-cp312-cp312-win_amd64.whl (160.2 kB view details)

Uploaded CPython 3.12Windows x86-64

sqlce-0.1.3-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (198.1 kB view details)

Uploaded CPython 3.12manylinux: glibc 2.17+ x86-64

sqlce-0.1.3-cp311-cp311-win_amd64.whl (158.8 kB view details)

Uploaded CPython 3.11Windows x86-64

sqlce-0.1.3-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (200.2 kB view details)

Uploaded CPython 3.11manylinux: glibc 2.17+ x86-64

sqlce-0.1.3-cp310-cp310-win_amd64.whl (157.1 kB view details)

Uploaded CPython 3.10Windows x86-64

sqlce-0.1.3-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (198.9 kB view details)

Uploaded CPython 3.10manylinux: glibc 2.17+ x86-64

sqlce-0.1.3-cp39-cp39-win_amd64.whl (157.3 kB view details)

Uploaded CPython 3.9Windows x86-64

sqlce-0.1.3-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (199.2 kB view details)

Uploaded CPython 3.9manylinux: glibc 2.17+ x86-64

sqlce-0.1.3-cp38-cp38-win_amd64.whl (157.1 kB view details)

Uploaded CPython 3.8Windows x86-64

sqlce-0.1.3-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (198.4 kB view details)

Uploaded CPython 3.8manylinux: glibc 2.17+ x86-64

File details

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

File metadata

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

File hashes

Hashes for sqlce-0.1.3.tar.gz
Algorithm Hash digest
SHA256 5a3f8c4cc2f9557a39a4a4201776c019815c2debe45fadba9ba17a50b0f10722
MD5 a03680afdfbadc09e3ff9d9ae36ce132
BLAKE2b-256 901f7315c8cf28306d2e1034510ce846f0eea6b46f281ca10c7baa1da93695b7

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.1.3.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.1.3-cp313-cp313-win_amd64.whl.

File metadata

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

File hashes

Hashes for sqlce-0.1.3-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 546e93a94b0195ee2f21bb6dc5ac4d31b9329fa7a807f2955aa054dfbac0f201
MD5 1a438dc8b824f6460a6ed4e415016594
BLAKE2b-256 76258d1c9bc4998fd04ad8a4e80e728f04bc50ec9cbed183aa5e391748dfa05a

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.1.3-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.1.3-cp313-cp313-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for sqlce-0.1.3-cp313-cp313-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 86a17e1600e2b68cf656b0431087d062e48cf8b21403318394dc2a1126723b77
MD5 582b76c6299ddebc6ba2417ad0e33459
BLAKE2b-256 1624dad8f0c2320dc6de39895a67731cee6f5df33ca546c96891248bb254b51f

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.1.3-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.1.3-cp312-cp312-win_amd64.whl.

File metadata

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

File hashes

Hashes for sqlce-0.1.3-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 7dbd5ff86ce164fe50ae2871e23e4067ee0236878daeaf2a491c0c21b57845f9
MD5 ef777fb0f07b8ea01c5491bb274d1e88
BLAKE2b-256 ce68b0f9d527b18aba931598c9aafc706b7bf611a85ee39e0834ff72df59a3b0

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.1.3-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.1.3-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for sqlce-0.1.3-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 3f59241bab2e3d46814613e9875e4bde8002376fbb349989ae860878d7a1d4b9
MD5 2b5f320db044fd97b7bcafb3574cf95b
BLAKE2b-256 55af647fe589b5ae57c55483fe69a892df620582385845047b0cc0f3a5077e4c

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.1.3-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.1.3-cp311-cp311-win_amd64.whl.

File metadata

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

File hashes

Hashes for sqlce-0.1.3-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 a43d3c628e0d8573a5105c5d7c2608257631b003513bff92d7a4e49d1b0f3d44
MD5 4a2629a8c90a6aaa8a6e97a9223add97
BLAKE2b-256 15cf5b9dca6d9389e7911904adb74c3865c6d4fc10606350b2d08e3262bce180

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.1.3-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.1.3-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for sqlce-0.1.3-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 422f5a0850cd4d2dcf10448f3443ceaf0424c61d55214d262320426c3b1ab03b
MD5 99037365c30142754c68d914023b5ee6
BLAKE2b-256 8bd600b8b93881a08499cc98eb28b52f5052bb3e78ea5b4d086fb610363ef36c

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.1.3-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.1.3-cp310-cp310-win_amd64.whl.

File metadata

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

File hashes

Hashes for sqlce-0.1.3-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 ab0f36230ed02c727803aefad0cdbbedc741f3ee383027f381232041b300838c
MD5 8c21ab7709652f3ac573d6d1777771d4
BLAKE2b-256 78d6bf435b849bd53f7301778b3658c127f18eea78e4ae44d3b9218762ba228c

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.1.3-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.1.3-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for sqlce-0.1.3-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 94ff7dace5b2f1fd451ce405f8b4665f76be96cffccb218909bbf7f8fa4b675c
MD5 a6d4033a6cfea9ce0f5c3f8ad803d60d
BLAKE2b-256 a2c592156fc07c3da35c2fbb855ffb3376679dc60081fb4ec650b0396c647321

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.1.3-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.1.3-cp39-cp39-win_amd64.whl.

File metadata

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

File hashes

Hashes for sqlce-0.1.3-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 aebf21c62c1f263800fb6c7a03541553e99e6dd75cbfb96f01e9a0c2a0fb459f
MD5 42174ee2f681b43bb7616b345b80356c
BLAKE2b-256 1a9beb148c95d8e9dbe9a273f879455dd31116a17a7f92ac5b731556ee319ea6

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.1.3-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.1.3-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for sqlce-0.1.3-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 997cdb47f30518e20271ba7c15b86ca8fb1c324120bca8b4e4e2a45feac8374e
MD5 734038f79fc32433222dd976c828aa1d
BLAKE2b-256 91b2fc6d9aae79ad8a134fad8afacafc4663ee7ac92e0580bf009bd2a2b7f0a5

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.1.3-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.1.3-cp38-cp38-win_amd64.whl.

File metadata

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

File hashes

Hashes for sqlce-0.1.3-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 4b224094e1974eb458e2a29a1dd83d1b7fce95b8398c059a2a2106a6ca5aaaab
MD5 9f708bdaf359b072ab9340b41193e561
BLAKE2b-256 0eb224e96ad1cdfb4723f0775146c9fa36a3a84ce329dd0ce3c5ee14b40972b4

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.1.3-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.1.3-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for sqlce-0.1.3-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 37cc4adca238b7b697807795a7cbe5faeea2ea71312ad541d06dc3f5cc7810d8
MD5 5ed8fdd08cf71be9d1bb52ff2eb4c039
BLAKE2b-256 b5917ac7e64b8793b9320c1af4cff0884561433e31c7465ec07017e749e29f9c

See more details on using hashes here.

Provenance

The following attestation bundles were made for sqlce-0.1.3-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

0.2.5

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

This release

0.1.3 This release

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