Skip to main content

fsspec-db

Browse SQL metadata and transfer table data through fsspec.

Build Status codecov License PyPI

fsspec-db maps schemas, tables, views, and their metadata to filesystem paths. Relation extensions select Arrow IPC, Parquet, CSV, or JSONL; SQL queries return PyArrow tables. Native backends support SQLite, PostgreSQL, and MySQL. Python adapters support DuckDB, SQLAlchemy, and ODBC.

Start here

Browse a SQLite database creates a database and reads it through metadata paths, SQL, and Parquet.

How-to guides

Read and write SQLite data, connect PostgreSQL or MySQL, or connect Python database adapters. Manage tables and metadata caches covers opt-in DDL, refreshing introspection, and deferred writes. Store keyed records uses tables with a primary key as fsspec.get_mapper stores.

Reference and explanation

Consult Paths and metadata, backend configuration and types, Python backend contracts, and the Python API for exact behavior. Read Why database objects have filesystem paths for the mapping and its limits.

Database overwrite writes replace table contents. Use "ab" or mode="append" to preserve existing rows.

Metadata

Release files for fsspec-db 0.4.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for fsspec-db 0.4.0
File Size Uploaded Provenance Actions
fsspec_db-0.4.0.tar.gz 165.9 kB Without provenance Details for fsspec_db-0.4.0.tar.gz

Built distributions (wheels)

Table of built distributions (wheels) for fsspec-db 0.4.0
File Actions
fsspec_db-0.4.0-cp311-abi3-win_amd64.whl CPython 3.11 abi3 Windows x86-64 Details for fsspec_db-0.4.0-cp311-abi3-win_amd64.whl
fsspec_db-0.4.0-cp311-abi3-manylinux_2_28_x86_64.whl CPython 3.11 abi3 Linux glibc 2.28+ x86-64 Details for fsspec_db-0.4.0-cp311-abi3-manylinux_2_28_x86_64.whl
fsspec_db-0.4.0-cp311-abi3-manylinux_2_28_aarch64.whl CPython 3.11 abi3 Linux glibc 2.28+ ARM64 Details for fsspec_db-0.4.0-cp311-abi3-manylinux_2_28_aarch64.whl
fsspec_db-0.4.0-cp311-abi3-macosx_11_0_arm64.whl CPython 3.11 abi3 macOS 11.0+ ARM64 Details for fsspec_db-0.4.0-cp311-abi3-macosx_11_0_arm64.whl

Total release size: 46.4 MB

Release files / fsspec_db-0.4.0.tar.gz

Download URL fsspec_db-0.4.0.tar.gz
Size 165.9 kB
Tags Source
SHA-256 checksum
How to use checksums
fb84a4c27e4ceb6872f250ce832cd915edf3340618bfa5d59eceee3483b2c335
BLAKE2b-256 checksum
How to use checksums
4f237ae1fa9d03fc3ac8dfd76c6fa84164017ce1fb229aac5a55b9f6e1dd36f4
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.13.14

Release files / fsspec_db-0.4.0-cp311-abi3-win_amd64.whl

Download URL fsspec_db-0.4.0-cp311-abi3-win_amd64.whl
Size 11.1 MB
Tags CPython 3.11 Windows x86-64 abi3
SHA-256 checksum
How to use checksums
562a22dd152fb708204d74e736daa9d7cb3c0d66f4ce5446521d001b9d5e0f09
BLAKE2b-256 checksum
How to use checksums
185dc2adc7d264c243c5384fedaf1715cbb85b327c349f8d01df7fdbc5da9088
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.13.14

Release files / fsspec_db-0.4.0-cp311-abi3-manylinux_2_28_x86_64.whl

Download URL fsspec_db-0.4.0-cp311-abi3-manylinux_2_28_x86_64.whl
Size 12.7 MB
Tags CPython 3.11 Linux glibc 2.28+ x86-64 abi3
SHA-256 checksum
How to use checksums
4cd6ac11f888ce18d55bf7f80ab6075871d61739e964991a9b1df1881133788a
BLAKE2b-256 checksum
How to use checksums
5b99407de24346d46691cf8e645da015f9a079dfa031e3e84a678a183485ab71
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.13.14

Release files / fsspec_db-0.4.0-cp311-abi3-manylinux_2_28_aarch64.whl

Download URL fsspec_db-0.4.0-cp311-abi3-manylinux_2_28_aarch64.whl
Size 12.0 MB
Tags CPython 3.11 Linux glibc 2.28+ ARM64 abi3
SHA-256 checksum
How to use checksums
1266b42371dce90c4d9be4cb315ef9d29f11b7b26cf968b76a8fef499fd4c930
BLAKE2b-256 checksum
How to use checksums
2f809181055a9ea5203793f2e896f3b2bba4af7bb2147aca5b10cfb751b5b005
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.13.14

Release files / fsspec_db-0.4.0-cp311-abi3-macosx_11_0_arm64.whl

Download URL fsspec_db-0.4.0-cp311-abi3-macosx_11_0_arm64.whl
Size 10.4 MB
Tags CPython 3.11 abi3 macOS 11.0+ ARM64
SHA-256 checksum
How to use checksums
a36a3c39200b7ca070e16cb381efa9dbbc48412b2ecf50f7a31e70a24909f47e
BLAKE2b-256 checksum
How to use checksums
ef928d413945a637443e51e887711779765414bb2660a4838df2f6b07e057cdf
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.13.14

Security for fsspec-db 0.4.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

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