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.5.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.5.0
File Size Uploaded Provenance Actions
fsspec_db-0.5.0.tar.gz 168.6 kB Without provenance Details for fsspec_db-0.5.0.tar.gz

Built distributions (wheels)

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

Total release size: 46.5 MB

Release files / fsspec_db-0.5.0.tar.gz

Download URL fsspec_db-0.5.0.tar.gz
Size 168.6 kB
Tags Source
SHA-256 checksum
How to use checksums
a9c2c680f7d683810a92742e5893bcbc293f9f3c54597654aca5b0bbf111ae8f
BLAKE2b-256 checksum
How to use checksums
6ebc167fc602df14fece39c3796cb2beabc3947c9f6c47ff7fec127b8ca485b3
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.5.0-cp311-abi3-win_amd64.whl

Download URL fsspec_db-0.5.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
136e493000f91de0e22f1195eed4a7f2af39b2f58d20a84c512c86d4724ba61f
BLAKE2b-256 checksum
How to use checksums
666ad044960e23c5c2b9c3deed5b299efd1a893017143eac62a670dc64fd1b3a
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.5.0-cp311-abi3-manylinux_2_28_x86_64.whl

Download URL fsspec_db-0.5.0-cp311-abi3-manylinux_2_28_x86_64.whl
Size 12.8 MB
Tags CPython 3.11 Linux glibc 2.28+ x86-64 abi3
SHA-256 checksum
How to use checksums
38495693f75a1413d7609906e95cc72212915296cd02e8f1293963024effdc2e
BLAKE2b-256 checksum
How to use checksums
92aaefa0b795046752ac87833036b8740fc838c2c49de60a3b5361c9368c976e
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.5.0-cp311-abi3-manylinux_2_28_aarch64.whl

Download URL fsspec_db-0.5.0-cp311-abi3-manylinux_2_28_aarch64.whl
Size 12.1 MB
Tags CPython 3.11 Linux glibc 2.28+ ARM64 abi3
SHA-256 checksum
How to use checksums
4f705f238283764ba133b48b9915db2302427a29f54f12a776a7cb1273d8daa1
BLAKE2b-256 checksum
How to use checksums
28aee6386b7a26115bc2f840149b24c4106bd50a3dab711b0333e6c18fb1834b
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.5.0-cp311-abi3-macosx_11_0_arm64.whl

Download URL fsspec_db-0.5.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
ee08fad2a44d88bc153fb123fc5b406858983b7e9f9786a50abc4c6fbedaf4e0
BLAKE2b-256 checksum
How to use checksums
fbb88cf6569438f677b7b879712c3c762e7c57419136f4cb4b3d7bedaa76f012
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.5.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