provsql 1.2.2
- This Release
- provsql 1.2.2
- Date
- Status
- Stable
- Latest Stable
- provsql 1.2.3 —
- 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.2
- Semiring provenance and probability management for PostgreSQL
Documentation
- tutorial
- Tutorial: Who Killed Daphine?
- provenance-tables
- Adding Provenance to a Table
- aggregation
- Aggregation and Grouping
- bibliography
- Bibliography
- CONTRIBUTING
- Contributing to ProvSQL
- C/C++ API Reference
- Semiring provenance and probability management for PostgreSQL
- introduction
- Introduction
- CHANGELOG
- Changelog
- doxygen-footer
- doxygen-footer
- README
- WHERE PANEL
- memory
- Memory Management
- querying
- Querying with Provenance
- SQL API Reference
- Semiring provenance and probability management for PostgreSQL
- where-provenance
- Where-Provenance
- introduction
- Developer Guide
- probabilities
- Probabilities
- architecture
- Architecture Overview
- temporal
- Temporal Features
- data-modification
- Data-Modification Tracking
- mainpage-c
- mainpage-c
- where-provenance
- Where-Provenance
- configuration
- Configuration Reference
- debugging
- Debugging
- shapley
- Shapley and Banzhaf Values
- postgresql-primer
- PostgreSQL Extension Primer
- README
- ProvSQL Tutorial
- SECURITY
- Security Policy
- semirings
- Semiring Evaluation
- build-system
- Build System
- coding-conventions
- Coding Conventions
- getting-provsql
- Getting ProvSQL
- probability-evaluation
- Probability Evaluation
- mainpage-sql
- mainpage-sql
- testing
- Testing
- data-modification
- Data Modification Tracking
- export
- Provenance Export
- semiring-evaluation
- Semiring Evaluation
- index
- Welcome to ProvSQL's documentation!
- query-rewriting
- Query Rewriting Pipeline
- aggregation
- Aggregation Provenance
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.