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