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.

  • 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++.

Try it in the browser (WebAssembly, runs locally - the file never leaves your tab): boykopovar.github.io/sqlce

Reading encrypted .sdf version 3.5 files is not currently supported (unencrypted files are supported).

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.5.tar.gz (64.0 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.5-cp313-cp313-win_amd64.whl (176.9 kB view details)

Uploaded CPython 3.13Windows x86-64

sqlce-0.1.5-cp313-cp313-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (217.6 kB view details)

Uploaded CPython 3.13manylinux: glibc 2.17+ x86-64

sqlce-0.1.5-cp312-cp312-win_amd64.whl (176.8 kB view details)

Uploaded CPython 3.12Windows x86-64

sqlce-0.1.5-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (217.6 kB view details)

Uploaded CPython 3.12manylinux: glibc 2.17+ x86-64

sqlce-0.1.5-cp311-cp311-win_amd64.whl (174.9 kB view details)

Uploaded CPython 3.11Windows x86-64

sqlce-0.1.5-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (218.3 kB view details)

Uploaded CPython 3.11manylinux: glibc 2.17+ x86-64

sqlce-0.1.5-cp310-cp310-win_amd64.whl (173.1 kB view details)

Uploaded CPython 3.10Windows x86-64

sqlce-0.1.5-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (217.7 kB view details)

Uploaded CPython 3.10manylinux: glibc 2.17+ x86-64

sqlce-0.1.5-cp39-cp39-win_amd64.whl (173.5 kB view details)

Uploaded CPython 3.9Windows x86-64

sqlce-0.1.5-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (217.9 kB view details)

Uploaded CPython 3.9manylinux: glibc 2.17+ x86-64

sqlce-0.1.5-cp38-cp38-win_amd64.whl (173.4 kB view details)

Uploaded CPython 3.8Windows x86-64

sqlce-0.1.5-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (217.5 kB view details)

Uploaded CPython 3.8manylinux: glibc 2.17+ x86-64

File details

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

File metadata

  • Download URL: sqlce-0.1.5.tar.gz
  • Upload date:
  • Size: 64.0 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.5.tar.gz
Algorithm Hash digest
SHA256 73e2f639bd36c61163d1d17071a618b41746bb41825956ffa7bb2294785574ee
MD5 911e1c71d4066f3762e3642147dea89b
BLAKE2b-256 284a56ca7f2f2ab557ca501aa9d0998bffa601d5b3fa41c9e40a5b01117825f4

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: sqlce-0.1.5-cp313-cp313-win_amd64.whl
  • Upload date:
  • Size: 176.9 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.5-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 44236f54692ce49760b39879fd04e25f990fd4374f37a3546e0e0713dbde91c9
MD5 517af241a6b77a3a60a92dd887c3855e
BLAKE2b-256 9a7d18f0be99f64b1585bed4e5b846e31ac87d2e07221ed36dad7baa8e1204af

See more details on using hashes here.

Provenance

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

File metadata

File hashes

Hashes for sqlce-0.1.5-cp313-cp313-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 046bbe0297d6a4a1cd7d5e57cfb67e69a1997e3fe35d45a05c1e3b86570aabdb
MD5 12668b222e6d2cf1903b5c02df4e2ba0
BLAKE2b-256 8626475cad26fda36355f8adccb2d8741bea264cdb9b2a022caf360cfc2944b0

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: sqlce-0.1.5-cp312-cp312-win_amd64.whl
  • Upload date:
  • Size: 176.8 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.5-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 f1359e9f41db1d5ad0fb0f40f961a9f43cb185ebadd6238e2c0cb326077fc341
MD5 d31873f491b448c4747f0b7d9da99065
BLAKE2b-256 893d0a1d812a9552e01ff3e82f9e4832592c2c7c43c0ea8d56b73f1c50711090

See more details on using hashes here.

Provenance

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

File metadata

File hashes

Hashes for sqlce-0.1.5-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 313cd64200d2caf1801b1dd6b1ac1e9d8b7adb01ef0d235249b2459201817784
MD5 0a17e0e037f91e2ffc8faeb1ef4714c7
BLAKE2b-256 75b0be2b4db4823149c6bc3aab50aa042e3e9689c3834fd70e8be5da95d7d755

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: sqlce-0.1.5-cp311-cp311-win_amd64.whl
  • Upload date:
  • Size: 174.9 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.5-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 5e69ba910933661396c62f1c1a88efd15ad5220935cedc0e0d27d63d5328ba1f
MD5 3e3fc214a2d98c032a9003b18cd919e7
BLAKE2b-256 5eb936a6cebb7d86577d37ac01d13275be8af70bda94037ff409fbe4f4e3343b

See more details on using hashes here.

Provenance

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

File metadata

File hashes

Hashes for sqlce-0.1.5-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 f597e5c71da8908987710b5dade3cf61b05317ac5c74de58aa8454dba5304982
MD5 4967c6a5f8ee32609598e6cb4463668f
BLAKE2b-256 b63416826199e2d60765e07b5e3642586c1c2549360711a6b0d8211c22f08231

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: sqlce-0.1.5-cp310-cp310-win_amd64.whl
  • Upload date:
  • Size: 173.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.5-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 e0db24a7ada648c865efe0207f130769fc6519574c544b4ad10bfcf9b51628c3
MD5 d9877dd85cccd08ce65835749da86aa0
BLAKE2b-256 15bd10f87726cbe0509a400f4eeaf9bacbbd3fe703c5c8891478107de328dfa5

See more details on using hashes here.

Provenance

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

File metadata

File hashes

Hashes for sqlce-0.1.5-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 73d32cdba4e7e2328cab1eab553291a10dc1400f92443e382e88cd23cf027dd8
MD5 e17a81d55ef1c8c941b4c1f616ff76e4
BLAKE2b-256 9f6f1219a8b97df263776935d741db60ab562b92752900ba4b68f4c524760d31

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: sqlce-0.1.5-cp39-cp39-win_amd64.whl
  • Upload date:
  • Size: 173.5 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.5-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 a3206507afad5705941cd6f5b67e114f8d0c9e39675c11206a055fe7e97ebb53
MD5 d45c26649b505a3c02f05b8981ba9c58
BLAKE2b-256 32976a770cc960af571045c6b7edbcb5b0a278216928c4a5b067e9988f5e867d

See more details on using hashes here.

Provenance

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

File metadata

File hashes

Hashes for sqlce-0.1.5-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 88bb4333bab39664e2c1966554a754c6dada146c2e31efa91ca3a42020eafc8d
MD5 9a35150d4a45c1b2c303caf9a18df32e
BLAKE2b-256 85fc95d0fa0adcb69493fce8a27d784f2887c58c74c2044f845f97645163c97b

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: sqlce-0.1.5-cp38-cp38-win_amd64.whl
  • Upload date:
  • Size: 173.4 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.5-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 7fc306718ab6565b3207ca59ddd480bc4bb9868b0e4bed7c2cf476a5e53b073d
MD5 c0db1183b0f39df5436b0d990a21b2da
BLAKE2b-256 a2856c454b0ff8445daa88924d792a4465addf16189fb66a2704e26927ecc0a8

See more details on using hashes here.

Provenance

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

File metadata

File hashes

Hashes for sqlce-0.1.5-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 c9afc2efdc7b5c49dcd3e8378179f1c731687d0803c9fd498434032d5585c9ef
MD5 bcf67038a10b56bef513ddb3d9253183
BLAKE2b-256 7660cceec7a38c69875c0a7239269b0627fc998135715ab6ace9627f9dcb9162

See more details on using hashes here.

Provenance

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

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

This release

0.1.5 This release

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