pg_isok 1.4.0
- This Release
- pg_isok 1.4.0
- Date
- Status
- Stable
- Latest Stable
- pg_isok 1.4.1 —
- Latest Testing
- pg_isok 1.0.0 —
- Latest Unstable
- pg_isok 0.1.4 —
- Other Releases
- Abstract
- Query based data integrity management
- 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 values of previously accepted data, 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 1.4.0
- Query based data integrity management
Documentation
- Mitigation-Strategies
- Mitigation Strategies
- Why-Use-Isok
- Why Use Isok?
- The-SowkeDB-Acknowledgements
- The SokweDB Acknowledgments
- Creating-an-Audit-Trail
- Creating an Audit Trail
- cc0-Notice
- Notice
- A-Start-To-Finish-Set-of-Examples
- A Start-To-Finish Set of Examples
- Introduction
- A Very Short Introduction
- Developing
- G. Developing
- appendix-Periodic-Execution
- E. Periodic Execution
- Limiting-Access
- Limiting Access
- Isok-Overview
- An Overview of the Tables
- cc0-Other-Information
- Other Information
- agpl
- J. GNU Affero General Public License version 3
- The-Babase-Acknowledgements
- The Babase Acknowledgments
- Wrap-run_isok_queries
- Wrap run_isok_queries()
- run_isok_queries
- run_isok_queries
- The-Search-Path
- The Search Path
- appendix-Security-Considerations
- A. Security Considerations
- cc0-1.0-universal
- L. CC0 1.0 Universal
- The-Gombe-Mother-Infant-Project-Acknowledgements
- The Gombe Mother-Infant Project Acknowledgments
- pg_isok
- Query based data integrity management
- cc0-No-Copyright
- No Copyright
- What-Queries-Access-Matters
- What Queries Access Matters
- Some-Notes-on-Query-ID-Style
- B. Some Notes on Query ID Style
- Licensing-Terms
- I. Licensing Terms -- Licensed Under The AGPL v3.0+ (Examples Excepted)
- FAQ
- C. Frequently Asked Questions
- appendix-Techniques-For-Making-Local-Extensions-to-Isok
- F. Techniques For Making Local Extensions to Isok
- Installation
- Installing, Upgradeing, and Un-installing
- isok
- Isok -- Query Based Data Integrity Management For PostgreSQL
- index
- Isok -- Query Based Data Integrity Management For PostgreSQL
- How-Isok-Works
- How Isok Works
- Fully-Utilize-ISOK_RESULTS.QR_Extra
- Fully Utilize ISOK_RESULTS.QR_Extra
- Building-and-Distributing
- Building and Distributing
- Tool-Requirements
- Tool Requirements
- Acknowledgements-and-History
- H. Acknowledgments and History
- Local-Copies-of-the-Documentation
- D. Local Copies of the Documentation
- extend-issue-classification
- Extend Issue Classification
- Roles
- Roles
- isok-The-Support-Tables
- The Support Tables
- CC0-1.0-Universal-Deed
- K. CC0 1.0 Universal Deed
- Modify-Isoks-Generated-SQL
- Modify Isok's Generated SQL
- Example-Periodic-Reporting-via-Email-Using-systemd
- Example Periodic Reporting via Email Using systemd
- The-Main-Tables
- The Main Tables
- isok-The-Functions
- The Functions (Running Isok)