log-trigger

Trigger to automatically store historical information of a table in a relational database

https://github.com/laurence-ugalde/log-trigger

Science Score: 26.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • CITATION.cff file
  • codemeta.json file
    Found codemeta.json file
  • .zenodo.json file
    Found .zenodo.json file
  • DOI references
  • Academic publication links
  • Academic email domains
  • Institutional organization owner
  • JOSS paper metadata
  • Scientific vocabulary similarity
    Low similarity (5.6%) to scientific vocabulary

Keywords

database database-trigger db2-database log-trigger mysql-database oracle-database sql sql-server-database trigger
Last synced: 6 months ago · JSON representation

Repository

Trigger to automatically store historical information of a table in a relational database

Basic Info
  • Host: GitHub
  • Owner: laurence-ugalde
  • License: cc-by-sa-4.0
  • Language: SQLPL
  • Default Branch: main
  • Homepage:
  • Size: 21.5 KB
Statistics
  • Stars: 1
  • Watchers: 1
  • Forks: 0
  • Open Issues: 0
  • Releases: 0
Topics
database database-trigger db2-database log-trigger mysql-database oracle-database sql sql-server-database trigger
Created over 3 years ago · Last pushed over 3 years ago
Metadata Files
Readme License Citation

README.md

Log trigger

Log trigger is a a pattern to create a trigger to automatically store historical information of a table in a relational database.

It works on a parallel table, creating infomation in a scheme of tuple versioning.

More detailed information: Log trigger in Wikipedia.

Repository

The intention of this repository is to mantain the definition of the Log trigger in as many database providers as possible, given that they use very different syntax and semantics, specially for triggers.

Currently, we have the defintition for the following database providers:

  • IBM DB2
  • Microsoft SQL Server
  • MySQL
  • Oracle

License

Log trigger is licensed under the CC BY-SA 4.0 license, so you can use it freely, even for commercial purposes, provided you give appropriate credit to the author.

Shield: CC BY-SA 4.0

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

CC BY-SA 4.0

Contributing

If you know how to implement the Log trigger in a database provider other than those maintained in this repository, feel free to request a pull.

Owner

  • Name: Laurence R. Ugalde
  • Login: laurence-ugalde
  • Kind: user

GitHub Events

Total
Last Year

Issues and Pull Requests

Last synced: 11 months ago

All Time
  • Total issues: 0
  • Total pull requests: 0
  • Average time to close issues: N/A
  • Average time to close pull requests: N/A
  • Total issue authors: 0
  • Total pull request authors: 0
  • Average comments per issue: 0
  • Average comments per pull request: 0
  • Merged pull requests: 0
  • Bot issues: 0
  • Bot pull requests: 0
Past Year
  • Issues: 0
  • Pull requests: 0
  • Average time to close issues: N/A
  • Average time to close pull requests: N/A
  • Issue authors: 0
  • Pull request authors: 0
  • Average comments per issue: 0
  • Average comments per pull request: 0
  • Merged pull requests: 0
  • Bot issues: 0
  • Bot pull requests: 0
Top Authors
Issue Authors
Pull Request Authors
Top Labels
Issue Labels
Pull Request Labels