TriggerMan is intended to simplify the task of creating basic audit tables and triggers in MySQL. TriggerMan can:
• Read table and trigger definitions from the Information_Schema database. The user never has to enter table/column definition data when creating audit tables or triggers, or create scripts.
• List existing tables and TriggerMan objects in a schema, and allow the user to choose which ones to operate on.
• Given a table, it can dynamically generate a corresponding audit table. This audit table contains specified columns from the original table, plus additional auditing information columns, such as when changes were made, and by whom.
• After creating an audit table, it can create triggers on the original table which control how and when data is written to the audit table; for example, Before Update or After Insert.
• Apply processing to multiple objects in a single operation.

Features

  • • Read table and trigger definitions from the Information_Schema database. The user never has to enter table/column definition data when creating audit tables or triggers, or create scripts. • List existing tables and TriggerMan objects in a schema, and allow the user to choose which ones to operate on. • Given a table, it can dynamically generate a corresponding audit table. This audit table contains all columns from the original table, plus additional auditing information columns, such as when changes were made, and by whom. • After creating an audit table, it can create triggers on the original table which control how and when data is written to the audit table; for example, Before Update or After Insert. • Apply processing to multiple objects in a single operation.

Project Samples

Project Activity

See All Activity >

Categories

Database

License

GNU General Public License version 3.0 (GPLv3)

Follow TriggerMan

TriggerMan Web Site

Other Useful Business Software
Get Avast Free Antivirus with 24/7 AI-powered online scam detection Icon
Get Avast Free Antivirus with 24/7 AI-powered online scam detection

Get protection for today’s online threats. Free.

Award-winning antivirus protection, as well as protection against online scams, dangerous Wi-Fi connections, hacked accounts, and ransomware. It includes Avast Assistant, your built-in AI partner, which gives you help with suspicious online messages, offers, and more.
Free Download
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of TriggerMan!

Additional Project Details

Languages

English

Intended Audience

Developers

User Interface

Java Swing

Programming Language

Java

Database Environment

MySQL

Related Categories

Java Database Software

Registered

2013-04-24