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.6.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.6.0
File Size Uploaded Provenance Actions
fsspec_db-0.6.0.tar.gz 170.6 kB Without provenance Details for fsspec_db-0.6.0.tar.gz

Built distributions (wheels)

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

Total release size: 46.6 MB

Release files / fsspec_db-0.6.0.tar.gz

Download URL fsspec_db-0.6.0.tar.gz
Size 170.6 kB
Tags Source
SHA-256 checksum
How to use checksums
33d06fb96c912a0351ace4a06bb3a6214e9dc4e7c650fe144fc0c533351b90d6
BLAKE2b-256 checksum
How to use checksums
7c15384834aa5f02a9afede56a8e987ab3b18f16803c3c06ddf5eb29b1421adc
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.6.0-cp311-abi3-win_amd64.whl

Download URL fsspec_db-0.6.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
cb5f05866a9e634334cfaa9b26682dc62d0d521d59fe0e9289c2c392f1e58c89
BLAKE2b-256 checksum
How to use checksums
f481e748e5c674b1d5bf1cd9e3eb5d6bb53ce6291c79c0f1364951fa503bcec5
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.6.0-cp311-abi3-manylinux_2_28_x86_64.whl

Download URL fsspec_db-0.6.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
23214fdd3f09b57f7b46169e8b8cfeb7993bd07e14e4093d8642310602b2f5ce
BLAKE2b-256 checksum
How to use checksums
c21b75ecd1da1053cb5306b61c158424d8ead440a271d258f8f00c4f2a3b5df8
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.6.0-cp311-abi3-manylinux_2_28_aarch64.whl

Download URL fsspec_db-0.6.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
ec9c07d06cd9e71b72096a00a6505e0dcab49add93fa7cf66b2d3b2ed1a27c07
BLAKE2b-256 checksum
How to use checksums
469f80d5e36e2c023931755a64795d2e35db677c3c10939293c00b8b2627ffe7
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.6.0-cp311-abi3-macosx_11_0_arm64.whl

Download URL fsspec_db-0.6.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
8d38a4a60d4880839f3efe0c0d993eac91d49abb8f8fe6471951a696440a9c93
BLAKE2b-256 checksum
How to use checksums
6b951a5e8948ec83574c3e541d3b860db05129fd6148e4eb7e55159323ba4fa0
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.6.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