pg_isok 0.2.1
- This Release
- pg_isok 0.2.1
- Date
- Status
- Testing
- Latest Stable
- pg_isok 1.4.0 —
- Latest Testing
- pg_isok 1.0.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
- Limiting-Access
- Limiting Access
- Creating-an-Audit-Trail
- Creating an Audit Trail
- Roles
- Roles
- isok-The-Support-Tables
- The Support Tables
- The-Search-Path
- The Search Path
- What-Queries-Access-Matters
- What Queries Access Matters
- Wrap-run_isok_queries
- Wrap run_isok_queries()
- Local-Copies-of-the-Documentation
- C. Local Copies of the Documentation
- appendix-Techniques-For-Making-Local-Extensions-to-Isok
- E. Techniques For Making Local Extensions to Isok
- 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-No-Copyright
- No Copyright
- Tool-Requirements
- Tool Requirements
- index
- Isok -- A query centered change monitoring tool for PostgreSQL
- Isok-Overview
- An Overview of the Tables
- Modify-Isoks-Generated-SQL
- Modify Isok's Generated SQL
- appendix-Periodic-Execution
- D. Periodic Execution
- cc0-1.0-universal
- K. CC0 1.0 Universal
- Example-Periodic-Reporting-via-Email-Using-systemd
- Example Periodic Reporting via Email Using systemd
- isok
- Isok -- A query centered change monitoring tool for PostgreSQL
- cc0-Other-Information
- Other Information
- The-Babase-Acknowledgements
- The Babase Acknowledgments
- Installation
- Installation
- The-SowkeDB-Acknowledgements
- The SokweDB Acknowledgments
- Licensing-Terms
- H. Licensing Terms -- Licensed Under The AGPL v3.0+ (Examples Excepted)
- agpl
- I. GNU Affero General Public License version 3
- Mitigation-Strategies
- Mitigation Strategies
- CC0-1.0-Universal-Deed
- J. CC0 1.0 Universal Deed
- isok-The-Functions
- The Functions (Running Isok)
- 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