Skip to main content

datasette-mask-columns

PyPI Changelog Tests License

Datasette plugin that masks specified database columns

Installation

pip install datasette-mask-columns

This depends on plugin hook changes in a not-yet released branch of Datasette. See issue #678 for details.

Usage

In your metadata.json file add a section like this describing the database and table in which you wish to mask columns:

{
    "databases": {
        "my-database": {
            "plugins": {
                "datasette-mask-columns": {
                    "users": ["password"]
                }
            }
        }
    }
}

All SQL queries against the users table in my-database.db will now return null for the password column, no matter what value that column actually holds.

The table page for users will display the text REDACTED in the masked column. This visual hint will only be available on the table page; it will not display his text for arbitrary queries against the table.

Metadata

Release files for datasette-mask-columns 0.2.2

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

Source distribution (sdist)

Source distribution for datasette-mask-columns 0.2.2
File Size Uploaded Provenance Actions
datasette-mask-columns-0.2.2.tar.gz 6.9 kB Without provenance Details for datasette-mask-columns-0.2.2.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for datasette-mask-columns 0.2.2
File Interpreter ABI Platform Actions
datasette_mask_columns-0.2.2-py3-none-any.whl Python 3 none any Details for datasette_mask_columns-0.2.2-py3-none-any.whl

Total release size: 13.9 kB

Release files / datasette-mask-columns-0.2.2.tar.gz

Download URL datasette-mask-columns-0.2.2.tar.gz
Size 6.9 kB
Tags Source
SHA-256 checksum
How to use checksums
0386263bd751a79ebf2b1fa2d767fe4b2e68dee3153db937283fae8f91494630
BLAKE2b-256 checksum
How to use checksums
e3432df25a9584e6f68d4cf72e5963101a48c6cc8dcf7d516f8f0170ef5e511c
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/4.0.2 CPython/3.11.5

Release files / datasette_mask_columns-0.2.2-py3-none-any.whl

Download URL datasette_mask_columns-0.2.2-py3-none-any.whl
Size 7.0 kB
Tags Python 3
SHA-256 checksum
How to use checksums
053eef05ad9b8975440ecd9416dd7a766f2b056bc84490dfa54471ba6d426240
BLAKE2b-256 checksum
How to use checksums
3edd5321c418f23ddf6fb1c31345d422bd3e2acb935486eb2242efbff8452b8a
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/4.0.2 CPython/3.11.5

Security for datasette-mask-columns 0.2.2

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