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.4.tar.gz (88.5 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.4-cp313-cp313-win_amd64.whl (202.3 kB view details)

Uploaded CPython 3.13Windows x86-64

sqlce-0.2.4-cp313-cp313-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (254.7 kB view details)

Uploaded CPython 3.13manylinux: glibc 2.17+ x86-64

sqlce-0.2.4-cp312-cp312-win_amd64.whl (202.2 kB view details)

Uploaded CPython 3.12Windows x86-64

sqlce-0.2.4-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (254.4 kB view details)

Uploaded CPython 3.12manylinux: glibc 2.17+ x86-64

sqlce-0.2.4-cp311-cp311-win_amd64.whl (200.6 kB view details)

Uploaded CPython 3.11Windows x86-64

sqlce-0.2.4-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (255.8 kB view details)

Uploaded CPython 3.11manylinux: glibc 2.17+ x86-64

sqlce-0.2.4-cp310-cp310-win_amd64.whl (198.5 kB view details)

Uploaded CPython 3.10Windows x86-64

sqlce-0.2.4-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (254.6 kB view details)

Uploaded CPython 3.10manylinux: glibc 2.17+ x86-64

sqlce-0.2.4-cp39-cp39-win_amd64.whl (199.0 kB view details)

Uploaded CPython 3.9Windows x86-64

sqlce-0.2.4-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (254.7 kB view details)

Uploaded CPython 3.9manylinux: glibc 2.17+ x86-64

sqlce-0.2.4-cp38-cp38-win_amd64.whl (199.0 kB view details)

Uploaded CPython 3.8Windows x86-64

sqlce-0.2.4-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (254.1 kB view details)

Uploaded CPython 3.8manylinux: glibc 2.17+ x86-64

File details

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

File metadata

  • Download URL: sqlce-0.2.4.tar.gz
  • Upload date:
  • Size: 88.5 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.4.tar.gz
Algorithm Hash digest
SHA256 bfa64a6fe5efd85199229b738c0395b976d6c5a64497a0d1c6c598f5f4b6b7fe
MD5 b2280953d3a807e568b2cdb67527247e
BLAKE2b-256 0104978be94f07bdda25c5404ba9f4b88a2c00862409375901320711ba22a7d1

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: sqlce-0.2.4-cp313-cp313-win_amd64.whl
  • Upload date:
  • Size: 202.3 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.4-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 2500971a8bca1ed39c835c0bee45939bc6c555e8655dd1c7f1276cdede21d978
MD5 980acbbaef4a030e0a19174eb4df7fb8
BLAKE2b-256 266778e909d444c20782d99266505f0e6c2248c9534cfa2862114528b126f20b

See more details on using hashes here.

Provenance

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

File metadata

File hashes

Hashes for sqlce-0.2.4-cp313-cp313-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 651963b78be71b4b006c6459e1df30da7442e93baa864174c10bb17e49b36c84
MD5 8001d94943fc92957a462356a66d44fc
BLAKE2b-256 28d96ac409ad4918a697ce4e90052352b06ad3fe825bbb14a13be634bd610dfa

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: sqlce-0.2.4-cp312-cp312-win_amd64.whl
  • Upload date:
  • Size: 202.2 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.4-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 2a002afc5012ac4e575ffcfc67fe4315138eb04be24c3361b7b185aedadef920
MD5 3c16e2157c76885e4b04c7e8a8181ff5
BLAKE2b-256 c555e8a9ea26f4d822dc46324f0cc7ad354b8d2788168a2977dd7871c2e4b812

See more details on using hashes here.

Provenance

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

File metadata

File hashes

Hashes for sqlce-0.2.4-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 0f34784d5ac9b50e15a252dbb9d1f8551fbf78a9f16599288850d3010dbad9e1
MD5 b7fd9cdc9c959fd7bddefcbefb0fd18b
BLAKE2b-256 07ae31046cac94f453cb8839e474e028222252a5d7d80dd160569372c6198d4c

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: sqlce-0.2.4-cp311-cp311-win_amd64.whl
  • Upload date:
  • Size: 200.6 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.4-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 4a22198441e7453a553a4e54cf0ea43663517c2ecf0e4ac7f2a9f7930dc42eaf
MD5 7c115af91af20a03251d161724bcc9f2
BLAKE2b-256 d97bf835b6a2087d3b0e5cd84d075397f4dec623b0635c570c0718c278959c71

See more details on using hashes here.

Provenance

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

File metadata

File hashes

Hashes for sqlce-0.2.4-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 879381c11be61f0bc5e2a09752797382d5b73fd53e5191d041404b2d93ef31be
MD5 579cddccb5c065a4328536a568400e51
BLAKE2b-256 d250dbed53e598a3d870825ef43893de0f4c380b02087efbef10b4ef555afae1

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: sqlce-0.2.4-cp310-cp310-win_amd64.whl
  • Upload date:
  • Size: 198.5 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.4-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 62824234ba1fc83628300d5cceb69795e803f33689268fc79c5c2128675fd4a2
MD5 2dc633a3efea3fb6e10febcf93011a94
BLAKE2b-256 d26f0d48b4575b9cb7d57dbfdcaa15ba1c9835a37483dbcfcd1e344c03863772

See more details on using hashes here.

Provenance

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

File metadata

File hashes

Hashes for sqlce-0.2.4-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 5cbcc17fc6238a29a8c249ed422d4bcea0a3b55fbbfa5b3e06a1c718639a80c6
MD5 98a3d1388deba2d4b7853580d8df260c
BLAKE2b-256 2b1eb42a1d1c59c465784788dfab9918f7679250746e15524021f7bc8c18a525

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: sqlce-0.2.4-cp39-cp39-win_amd64.whl
  • Upload date:
  • Size: 199.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.4-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 4d374ab86fee0a3ee92caad4937a716d8dffc7606e0e784c05ae9989c21c491e
MD5 e31e350fb86a6591a1feee5ea8dd4b72
BLAKE2b-256 eb366f1e4d3168885ff006b93bf71ee3911d11d4593dc2fbaec187f9e1758ab4

See more details on using hashes here.

Provenance

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

File metadata

File hashes

Hashes for sqlce-0.2.4-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 b69b09764f321140fdd257e121b46994fc6269cd1210100addaa0f06ced151d6
MD5 e7de25aff8fcbc3000b45063ba0f755c
BLAKE2b-256 884d6b9470a937869a493252f58f0fc658f1bc2112945c6c4af126f91fcfbed7

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: sqlce-0.2.4-cp38-cp38-win_amd64.whl
  • Upload date:
  • Size: 199.0 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.4-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 0c0e7a7aa422f1108b37b95f631abf2ff80413a94866900c74a6f7f853772bc8
MD5 f953a638d3a1129cac9c596fcb00f9da
BLAKE2b-256 c49f66c461006a8a1f2e139e745b19bbe6ceff5a47dd8a8adfbb8a209f13ef56

See more details on using hashes here.

Provenance

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

File metadata

File hashes

Hashes for sqlce-0.2.4-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 06361cc4de166cf59d9ed6abf13b44862b2b467a91c3b98dd5dfc83ffe578ff7
MD5 14384cfcf824ccca3e525d9e0db47aa2
BLAKE2b-256 fbe9053d3476468835fdaf434af82c53f5597e0fc16972fc7127520eea35fcfb

See more details on using hashes here.

Provenance

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

This release

0.2.4 This release

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