pg_isok 0.3.0
- This Release
- pg_isok 0.3.0
- 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 can help you manage your data's integrity, especially when little technical effort can be spared, or manual review is involved, or data cleanup is done over time. It is especially suited when importing "dirty" data into PostgreSQL for cleanup, and for corner cases where business logic is "fuzzy". Isok can monitor 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. 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.3.0
- Query based data integrity management
Documentation
- cc0-Other-Information
- Other Information
- Mitigation-Strategies
- Mitigation Strategies
- The-SowkeDB-Acknowledgements
- The SokweDB Acknowledgments
- Licensing-Terms
- H. Licensing Terms -- Licensed Under The AGPL v3.0+ (Examples Excepted)
- index
- Isok -- Query Based Data Integrity Managment For PostgreSQL
- Developing
- F. Developing
- How-Isok-Works
- How Isok Works
- What-Queries-Access-Matters
- What Queries Access Matters
- pg_isok
- Query based data integrity management
- Roles
- Roles
- Example-Periodic-Reporting-via-Email-Using-systemd
- Example Periodic Reporting via Email Using systemd
- agpl
- I. GNU Affero General Public License version 3
- Tool-Requirements
- Tool Requirements
- FAQ
- B. Frequently Asked Questions
- Creating-an-Audit-Trail
- Creating an Audit Trail
- CC0-1.0-Universal-Deed
- J. CC0 1.0 Universal Deed
- cc0-Notice
- Notice
- Acknowledgements-and-History
- G. Acknowledgments and History
- cc0-1.0-universal
- K. CC0 1.0 Universal
- The-Main-Tables
- The Main Tables
- Local-Copies-of-the-Documentation
- C. Local Copies of the Documentation
- The-Search-Path
- The Search Path
- appendix-Techniques-For-Making-Local-Extensions-to-Isok
- E. Techniques For Making Local Extensions to Isok
- The-Gombe-Mother-Infant-Project-Acknowledgements
- The Gombe Mother-Infant Project Acknowledgments
- Isok-Overview
- An Overview of the Tables
- appendix-Security-Considerations
- A. Security Considerations
- Why-Use-Isok
- Why Use Isok?
- A-Start-To-Finish-Set-of-Examples
- A Start-To-Finish Set of Examples
- isok-The-Functions
- The Functions (Running Isok)
- Modify-Isoks-Generated-SQL
- Modify Isok's Generated SQL
- Building-and-Distributing
- Building and Distributing
- run_isok_queries
- run_isok_queries
- appendix-Periodic-Execution
- D. Periodic Execution
- isok-The-Support-Tables
- The Support Tables
- cc0-No-Copyright
- No Copyright
- Installation
- Installation
- The-Babase-Acknowledgements
- The Babase Acknowledgments
- extend-issue-classification
- Extend Issue Classification
- isok
- Isok -- Query Based Data Integrity Managment For PostgreSQL
- Wrap-run_isok_queries
- Wrap run_isok_queries()
- Fully-Utilize-ISOK_RESULTS.QR_Extra
- Fully Utilize ISOK_RESULTS.QR_Extra
- Limiting-Access
- Limiting Access