Timeline for How can I put a database under git (version control)?
Current License: CC BY-SA 2.5
43 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 15 at 5:32 | comment | added | php-b-grader |
I simply make a copy of each table before changing and call it table.master. Then I make the changes and make a copy of the new table structure and call it table.branch. Then when switching back and forth between branch, I just use DROP TABLE table, CREATE TABLE table LIKE table.master, INSERT INTO table SELECT * FROM table.master and vice versa.
|
|
| Feb 2, 2023 at 14:24 | answer | added | Jason Hughes | timeline score: 1 | |
| Nov 3, 2022 at 21:45 | answer | added | Zach Musgrave | timeline score: 1 | |
| Nov 12, 2021 at 18:35 | review | Close votes | |||
| Nov 16, 2021 at 0:06 | |||||
| Jun 25, 2020 at 23:01 | answer | added | OzzyTheGiant | timeline score: 1 | |
| Aug 26, 2019 at 8:06 | answer | added | Ceddy Muhoza | timeline score: 1 | |
| Apr 29, 2019 at 8:17 | answer | added | Tails | timeline score: 27 | |
| Sep 24, 2018 at 19:44 | comment | added | Dharmendar Kumar 'DK' | Summary of options for database version control - many specific to PostgreSQL: stackoverflow.com/questions/846659/… | |
| Oct 11, 2017 at 9:16 | answer | added | Ciges | timeline score: 4 | |
| Jul 9, 2017 at 2:55 | answer | added | cannadayr | timeline score: 3 | |
| Jun 7, 2017 at 20:21 | answer | added | Florian Mertens | timeline score: 1 | |
| May 16, 2016 at 12:11 | answer | added | RomCoo | timeline score: 1 | |
| Mar 19, 2016 at 11:44 | comment | added | Thorbjørn Ravn Andersen | Big binary files (like database files) do not work well with git. You can easily do so though, just be sure to check that git is not trying to fix line endings | |
| Mar 7, 2016 at 10:22 | answer | added | sibaz | timeline score: 8 | |
| May 22, 2015 at 11:34 | answer | added | CShark | timeline score: 4 | |
| May 22, 2015 at 5:01 | answer | added | AkiShankar | timeline score: 1 | |
| Apr 16, 2015 at 1:40 | comment | added | user1170868 | liquibase.org ? | |
| Jan 28, 2015 at 23:24 | comment | added | Augiwan | See: Klonio - distributed database versioning | |
| Jan 24, 2015 at 8:07 | comment | added | Kevin | Checkout my answer for a software that does this exactly : stackoverflow.com/a/28123546/1662984 | |
| Sep 11, 2014 at 11:58 | history | protected | Madara's Ghost | ||
| Jul 20, 2014 at 0:44 | comment | added | Fuhrmanator | If you consider the script (and its components) to init your database as being an artifact under version control, then 'backups' might not seem like such a bad thing. If you change your db schema in a radical branch, you need to update the script that inits the database with the data. | |
| May 13, 2014 at 20:18 | answer | added | Marko | timeline score: 1 | |
| Mar 3, 2014 at 8:21 | answer | added | Jerry M Sunny | timeline score: 1 | |
| Oct 21, 2013 at 14:00 | comment | added | VonC |
See also the git-based backup tool bup
|
|
| Mar 29, 2012 at 8:09 | answer | added | key_ | timeline score: 1 | |
| Feb 9, 2012 at 23:42 | answer | added | inf3rno | timeline score: 0 | |
| Feb 25, 2011 at 15:14 | answer | added | Peter Eisentraut | timeline score: 2 | |
| Feb 25, 2011 at 11:19 | answer | added | Hakan Deryal | timeline score: 6 | |
| Aug 11, 2010 at 1:16 | answer | added | matt b | timeline score: 0 | |
| Jul 26, 2010 at 15:00 | answer | added | unode | timeline score: 1 | |
| Feb 14, 2010 at 21:59 | vote | accept | hasen | ||
| Feb 14, 2010 at 21:57 | vote | accept | hasen | ||
| Feb 14, 2010 at 21:59 | |||||
| Feb 14, 2010 at 21:38 | answer | added | zie | timeline score: 21 | |
| Nov 27, 2009 at 23:57 | vote | accept | hasen | ||
| Feb 14, 2010 at 21:57 | |||||
| May 11, 2009 at 22:37 | answer | added | hasen | timeline score: 31 | |
| May 11, 2009 at 21:17 | comment | added | araqnid | To be honest, I just make copies of the database if I'm introducing schema changes and have to deal with multiple development branches at the same time... dev databases should hopefully be small enough to do that. I'd regard any system that tried to be clever and make DB changes just because I changed source branch with suspicion. And I'd also like to be sure things to keep on working if I simply cloned my workspace and had one branch in one location, and the other in the new one. | |
| May 11, 2009 at 20:57 | history | edited | hasen | CC BY-SA 2.5 |
added 420 characters in body
|
| May 11, 2009 at 20:51 | history | edited | hasen | CC BY-SA 2.5 |
update, changed the question a bit
|
| May 11, 2009 at 5:44 | answer | added | Dana the Sane | timeline score: 2 | |
| May 11, 2009 at 4:47 | answer | added | Dustin | timeline score: 2 | |
| May 11, 2009 at 4:19 | history | edited | hasen | CC BY-SA 2.5 |
added 208 characters in body
|
| May 11, 2009 at 3:52 | answer | added | X-Istence | timeline score: 165 | |
| May 11, 2009 at 3:49 | history | asked | hasen | CC BY-SA 2.5 |