log-trigger
Trigger to automatically store historical information of a table in a relational database
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
Repository
Trigger to automatically store historical information of a table in a relational database
Basic Info
Statistics
- Stars: 1
- Watchers: 1
- Forks: 0
- Open Issues: 0
- Releases: 0
Topics
Metadata Files
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.
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
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
- Repositories: 1
- Profile: https://github.com/laurence-ugalde
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
