Isok -- Query Based Data Integrity Management For PostgreSQL
     Next

Table of Contents

A Very Short Introduction
Why Use Isok?
The One-to-One-Or-More Problem Almost Everyone Has
How Isok Works
A Start-To-Finish Set of Examples
The OS Side
Database Setup
Our First Query
Resolving Warnings
A Query That Looks For Missing Countries
Installation
Requirements
Quick-Start
Preparing, While Logged-In to Un*x
Loading Into PostgreSQL
Uninstalling
An Overview of the Tables
The Main Tables
ISOK_QUERIES
ISOK_RESULTS (Isok query Results)
The Support Tables
IQ_TYPES (Integrity Query Types)
IR_TYPES (Isok Result Types)
The Functions (Running Isok)
run_isok_queries — execute one or more of the queries stored in the ISOK_QUERIES table
A. Security Considerations
Limiting Access
What Queries Access Matters
The Search Path
Roles
Mitigation Strategies
Creating an Audit Trail
B. Some Notes on Query ID Style
C. Frequently Asked Questions
D. Local Copies of the Documentation
E. Periodic Execution
Example Periodic Reporting via Email Using systemd
F. Techniques For Making Local Extensions to Isok
Wrap run_isok_queries()
Extend Issue Classification
Fully Utilize ISOK_RESULTS.QR_Extra
Modify Isok's Generated SQL
G. Developing
Tool Requirements
Building and Distributing
H. Acknowledgments and History
The Gombe Mother-Infant Project Acknowledgments
The Babase Acknowledgments
The SokweDB Acknowledgments
I. Licensing Terms -- Licensed Under The AGPL v3.0+ (Examples Excepted)
J. GNU Affero General Public License version 3
K. CC0 1.0 Universal Deed
No Copyright
Other Information
Notice
L. CC0 1.0 Universal
     Next
     A Very Short Introduction

Page generated: 2025-07-13T14:19:35-05:00.