amfs-adapter-postgres

Create a mini-application called 'DataWatcher' that monitors changes in a PostgreSQL database and logs these changes into another table within the same database using the 'amfs-adapter-postgres' package. This tool will help users keep track of modifications made to their data over time, such as insertions, deletions, and updates. Here’s a detailed breakdown of the requirements and features:

1. **Database Setup**: Set up a PostgreSQL database with at least two tables - one for the primary data and another for logging changes.
2. **Integration with 'amfs-adapter-postgres'**: Utilize the 'amfs-adapter-postgres' package to set up triggers that automatically log changes to the primary data table into the change log table whenever there is an insert, update, or delete operation.
3. **User Interface**: Develop a simple command-line interface (CLI) where users can interact with the application to view the current state of the primary data table, see recent changes logged in the change log table, and perform basic CRUD operations on the primary data table.
4. **Security Measures**: Implement basic security measures like user authentication before allowing any CRUD operations on the primary data table through the CLI.
5. **Real-time Monitoring**: Ensure that the application can monitor the database in real-time and immediately log any changes into the change log table without requiring manual intervention.
6. **Reporting Feature**: Include a feature that allows users to generate reports based on the change logs, such as identifying frequent data modifications or tracking changes over a specific period.
7. **Documentation**: Provide comprehensive documentation detailing how to install and use the 'DataWatcher' application, including setup instructions for the PostgreSQL database and the 'amfs-adapter-postgres' package.
8. **Testing**: Write unit tests to ensure that all functionalities work as expected and that the integration with 'amfs-adapter-postgres' is seamless.