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.1

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.1
File Size Uploaded Provenance Actions
fsspec_db-0.4.1.tar.gz 166.5 kB Without provenance Details for fsspec_db-0.4.1.tar.gz

Built distributions (wheels)

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

Total release size: 46.4 MB

Release files / fsspec_db-0.4.1.tar.gz

Download URL fsspec_db-0.4.1.tar.gz
Size 166.5 kB
Tags Source
SHA-256 checksum
How to use checksums
9358b957f71fbcb86d2980a0aa33ebf3df1b0dc35173cccd61288f15300bbb18
BLAKE2b-256 checksum
How to use checksums
4133fe395b9d0b323dc5af4f1afafc90708c6738866e4ad8bd3be87f972dc9df
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.12.15

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

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

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

Download URL fsspec_db-0.4.1-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
e3f6936cbb27ab47b137429e0ec00397507f320e6d36981587865bb34a4180bf
BLAKE2b-256 checksum
How to use checksums
68f3639a1c8554d09820e537dc65c2223d88de542f96c34c100ddf52a1d9f03d
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.12.15

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

Download URL fsspec_db-0.4.1-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
bd6161bb76350db0c5dad0f00b598b8172c0f4aab4903e9e1b2bb52f57bc1cd4
BLAKE2b-256 checksum
How to use checksums
a38aecaf74d20b887ab13b0452ca9c86b487635181bb01fc7aa28d57d67a554f
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.12.15

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

Download URL fsspec_db-0.4.1-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
b4c3a7e20435dcf5f3267143be8b607425037da36120b9e07aae48c8f807c935
BLAKE2b-256 checksum
How to use checksums
c4862790f37cfe55503fa947fbfc2c7905f35b0b02ba21ae5aec75a1beca70e9
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.12.15

Security for fsspec-db 0.4.1

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