LinuxQuestions.org
Help answer threads with 0 replies.
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 10-30-2007, 01:50 AM   #1
topcat
Member
 
Registered: Feb 2003
Distribution: ubuntu 6.06, ubuntu 7.04 AMD 64bit, 7.10 AMD 64bit
Posts: 62

Rep: Reputation: 15
subversion best practice


Hi,
just starting to use subversion and were wondering about a couple of cases/issues which may arise.

Now, our project directories will also contain images or certain binaries.
Will this be checked in/out each time or these will be ignored since they will not really change?

secondly about the database.
Now, the code trees will be checked out by each developer on his/her machine and they will work of it. but what about mysql?

Do we directly work off the main server or have local copies and then do a subversion/equivalent or synchronization?

what are the practices followed?

many thanks.
 
Old 10-30-2007, 07:20 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 913Reputation: 913Reputation: 913Reputation: 913Reputation: 913Reputation: 913Reputation: 913Reputation: 913
Quote:
Originally Posted by topcat View Post
Hi,
just starting to use subversion and were wondering about a couple of cases/issues which may arise.

Now, our project directories will also contain images or certain binaries.
Will this be checked in/out each time or these will be ignored since they will not really change?
Stuff that hasn't changed won't be touched, just like you'd
expect from a version control system; binary or not.

Quote:
Originally Posted by topcat View Post
secondly about the database.
Now, the code trees will be checked out by each developer on his/her machine and they will work of it. but what about mysql?

Do we directly work off the main server or have local copies and then do a subversion/equivalent or synchronization?

what are the practices followed?

many thanks.
Where did MySQL creep into the picture? I understand that subversion
uses BerkleyDB ....



Cheers,
Tink
 
Old 10-30-2007, 10:10 PM   #3
topcat
Member
 
Registered: Feb 2003
Distribution: ubuntu 6.06, ubuntu 7.04 AMD 64bit, 7.10 AMD 64bit
Posts: 62

Original Poster
Rep: Reputation: 15
bad subject line. sorry.

The question should have been,
"while the actual code can be version controlled using cvs/subversion, what about the database?" is there something equivalent to subversion or version control when it comes to databases?
 
Old 10-31-2007, 03:47 AM   #4
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 913Reputation: 913Reputation: 913Reputation: 913Reputation: 913Reputation: 913Reputation: 913Reputation: 913
Not really... with that you're on your own.

The question is: what is the requirement in terms of versioning?

DDL changes?

Table content?

Either way - you'll need to be scripting, and make a conscious
effort to take a status (via script for DDL) before you make a
change, or via trigger into an "audit table" for data, which you
then could back up with some means, or even tie to SVN somehow.



Cheers,
Tink
 
  


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
Practice test hlinux Linux - Certification 4 06-30-2005 08:26 AM
Practice for programming? coolguy_iiit Programming 2 12-29-2004 02:07 PM
RCS best practice? jonin Linux - Software 1 09-30-2004 06:54 PM
How to install Subversion(Version Control with Subversion) under RedHat Linux. netkiller Linux - Networking 1 07-01-2004 06:45 AM
Best Practice Question zuessh Linux - Security 3 05-02-2003 12:46 PM

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

All times are GMT -5. The time now is 10:37 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration