pg_isok 0.2.1

This Release
pg_isok 0.2.1
Date
Status
Testing
Latest Testing
pg_isok 0.4.0 —
Latest Unstable
pg_isok 0.1.4 —
Other Releases
Abstract
A query centered monitoring tool
Description
Isok is for monitoring anything that can be reported with an SQL query. Unlike simply running a query, which reports the _existence_ of questionable data patterns, Isok produces reports alerting you of _changes_ to questionable data patterns, so that only new problems need be reviewed. To use Isok you write SQL queries, which produce reports alerting you of questionable data patterns. Then, on a row by row basis, you can defer, possibly forever, the appearance of individual alerts on future reports. Isok's expected usage targets data integrity maintenance and data cleanup. It is especially suited for corner cases where business logic is "fuzzy". There is also a potential use-case for simplistic monitoring of PostgreSQL itself. Isok can be built as pure SQL, for installation in the cloud or other managed PostgreSQL instances. It targets PostgreSQL 10 or later.
Released By
kop
License
agpl_3
Resources
Special Files
Tags

Extensions

pg_isok 0.2.1
A query centered change monitoring tool

Documentation

isok-The-Functions
The Functions (Running Isok)
Modify-Isoks-Generated-SQL
Modify Isok's Generated SQL
Example-Periodic-Reporting-via-Email-Using-systemd
Example Periodic Reporting via Email Using systemd
Roles
Roles
A-Start-To-Finish-Set-of-Examples
A Start-To-Finish Set of Examples
Installation
Installation
The-Babase-Acknowledgements
The Babase Acknowledgments
Tool-Requirements
Tool Requirements
isok-The-Support-Tables
The Support Tables
cc0-No-Copyright
No Copyright
appendix-Periodic-Execution
D. Periodic Execution
agpl
I.  GNU Affero General Public License version 3
Building-and-Distributing
Building and Distributing
run_isok_queries
run_isok_queries
isok-introduction
Introduction
extend-issue-classification
Extend Issue Classification
FAQ
B. Frequently Asked Questions
Creating-an-Audit-Trail
Creating an Audit Trail
Limiting-Access
Limiting Access
Wrap-run_isok_queries
Wrap run_isok_queries()
CC0-1.0-Universal-Deed
J. CC0 1.0 Universal Deed
isok
Isok -- A query centered change monitoring tool for PostgreSQL
Fully-Utilize-ISOK_RESULTS.QR_Extra
Fully Utilize ISOK_RESULTS.QR_Extra
cc0-1.0-universal
K.  CC0 1.0 Universal
Mitigation-Strategies
Mitigation Strategies
Acknowledgements-and-History
G. Acknowledgments and History
cc0-Other-Information
Other Information
cc0-Notice
Notice
Local-Copies-of-the-Documentation
C. Local Copies of the Documentation
Licensing-Terms
H. Licensing Terms -- Licensed Under The AGPL v3.0+ (Examples Excepted)
The-Main-Tables
The Main Tables
The-SowkeDB-Acknowledgements
The SokweDB Acknowledgments
The-Gombe-Mother-Infant-Project-Acknowledgements
The Gombe Mother-Infant Project Acknowledgments
The-Search-Path
The Search Path
appendix-Techniques-For-Making-Local-Extensions-to-Isok
E. Techniques For Making Local Extensions to Isok
index
Isok -- A query centered change monitoring tool for PostgreSQL
pg_isok
A query centered change monitoring tool
What-Queries-Access-Matters
What Queries Access Matters
Isok-Overview
An Overview of the Tables
appendix-Security-Considerations
A. Security Considerations
Developing
F. Developing