LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 01-02-2006, 06:40 PM   #1
newuser455
Member
 
Registered: May 2004
Location: Texas
Posts: 277

Rep: Reputation: 30
Question Database CVS?


I am developing a project which requires a database, and I need something that will track changes made to the database. Does anyone know of some sort of cvs type thing, but for databases? Thanks.
 
Old 01-03-2006, 12:43 PM   #2
bulliver
Senior Member
 
Registered: Nov 2002
Location: Edmonton AB, Canada
Distribution: Gentoo x86_64; Gentoo PPC; FreeBSD; OS X 10.9.4
Posts: 3,760
Blog Entries: 4

Rep: Reputation: 78
Depending on your DB, this is quite often built in. For example, check out MySQL's 'binary log' which records all transactions that change the DB tables:

http://dev.mysql.com/doc/refman/4.1/en/binary-log.html

I am sure other DBs have similar features.
 
Old 01-03-2006, 01:17 PM   #3
newuser455
Member
 
Registered: May 2004
Location: Texas
Posts: 277

Original Poster
Rep: Reputation: 30
Yes, but is there any way to actually "undo" a change that is made?
 
Old 01-03-2006, 02:07 PM   #4
gilead
Senior Member
 
Registered: Dec 2005
Location: Brisbane, Australia
Distribution: Slackware64 14.0
Posts: 4,141

Rep: Reputation: 168Reputation: 168
Are you talking about changes to the db schema? If so, your create and alter scripts should be in the CVS repository (and tagged for each release).

Or are you talking about the data in the tables? In that case it's easier to look at triggers if you're inserting directly into the tables or if you're using packages (Oracle for example) and inserting via an API you can build audit code into the packages.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Running CVS Server on Fedora Core 4 with pserver as "cvs" user rupak Fedora 2 09-17-2005 02:06 PM
Running CVS Server with pserver as "cvs" user on Fedora Core 4 rupak Linux - Software 2 09-17-2005 12:10 PM
create a cvs repository with existing files to cvs powah Linux - Software 1 08-19-2005 09:19 AM
Obtaining sources by CVS - no cvs access cybrjackle *BSD 0 01-18-2005 08:28 AM
cvs wine. Unable to download. Error "cvs: command not found" gonus Debian 5 08-03-2004 07:13 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:54 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration