provsql 1.2.3
- This Release
- provsql 1.2.3
- Date
- Status
- Stable
- Other Releases
- Abstract
- Semiring provenance and probability management for PostgreSQL
- Description
- ProvSQL is a PostgreSQL extension that adds (m-)semiring provenance and uncertainty management. It transparently rewrites SQL queries to track how each result depends on input tuples, then evaluates the provenance in any user-chosen semiring -- Boolean reachability, counting, probability, Shapley values, where-provenance, data-modification tracking, and more. The source is split between sql/provsql.common.sql (the primary file, shown in the Source view on this page, for all supported PostgreSQL versions) and sql/provsql.14.sql (additional objects requiring PostgreSQL 14 or later: data-modification tracking and temporal validity ranges). The full source is always available from the linked repository.
- Released By
- PierreSenellart
- License
- MIT
- Resources
- Special Files
- Tags
Extensions
- provsql 1.2.3
- Semiring provenance and probability management for PostgreSQL
Documentation
- CONTRIBUTING
- Contributing to ProvSQL
- SECURITY
- Security Policy
- CODE_OF_CONDUCT
- Code of Conduct
- CHANGELOG
- Changelog
README
Contents
ProvSQL
ProvSQL adds (m-)semiring provenance and uncertainty management to PostgreSQL, enabling computation of probabilities, Shapley values, and various semiring evaluations, as a PostgreSQL extension.
Website: https://provsql.org/ – Documentation: https://provsql.org/docs/
Quick Install
Prerequisites: PostgreSQL ≥ 10, a C++17 compiler, PostgreSQL development
headers, uuid-ossp, and the Boost libraries (libboost-dev,
libboost-serialization-dev).
make
make install # as a user with write access to the PostgreSQL directories
Add to postgresql.conf and restart PostgreSQL:
shared_preload_libraries = 'provsql'
Then in each database:
CREATE EXTENSION provsql CASCADE;
See the full installation guide for prerequisites, optional dependencies, testing, and Docker instructions.
License
ProvSQL is provided as open-source software under the MIT License. See LICENSE.
Contact
https://github.com/PierreSenellart/provsql
Pierre Senellart pierre@senellart.com
Bug reports and feature requests are preferably sent through the Issues feature of GitHub.