Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon.

Pages: 1-

source control and databases

Name: Anonymous 2009-09-27 15:24

How does /prog/ handle source control for database changes?  I have a DB that changes pretty frequently based on customer requests, and I'm having trouble coming up with a scheme that would handle changes to stored procedures, lookup data, table definitions, etc.  Bonus is getting it to handle both full build scripts as well as incremental patches.

inb4 lmgtfy.com, I don't know how to google.

Name: Anonymous 2009-09-27 15:31

The only time I ever did this, I just used regular version control with a sql dump of the database. Not the best solution, perhaps, but it served my needs fine.

Name: Anonymous 2009-09-27 15:31

git

Name: Anonymous 2009-09-27 15:36

>>1
http://lmgtfy.com/?q=let+me+google+that+for+you

Name: Anonymous 2009-09-28 11:09

Bumpin.  Really, no one has a good idea?

Name: Anonymous 2009-09-28 11:19

>>1
There isn't any quick answer to solve your problem. The only way is to restructure your system to meet your requirements. http://mitpress.mit.edu/sicp/

Name: Anonymous 2009-09-28 12:18

Or restructure your requirements to meet your system. http://dis.4chan.org/read/prog/1249744880

Name: Anonymous 2009-09-28 13:03

>>7
WWMDD

Name: Anonymous 2009-09-28 16:31

>>1
That is an excellent question, and makes it painfully clear that database designers are anything but programmers.

Name: Anonymous 2009-09-28 17:19

Take this keyboard, and take it to the captain..ha
Take this keyboard, and take it to the captain..ha
Take this keyboard, and take it to the captain.......ha
Tell him i'm gone
Tell him i'm gone

Name: Anonymous 2009-09-28 21:23

>>1
Try useing a vesion control system like cvs or subversion

Name: Anonymous 2009-09-28 21:39

>>11
or Walgreens

Name: Anonymous 2009-09-28 22:54

Rite aid FTW

Name: Anonymous 2009-09-28 22:56

>>13
lol, moar like Right AIDS am i rite

Name: Anonymous 2009-09-29 2:14

how do i ALTER TABLE?

Actually I really have no idea. My boss is perpetually angry at me because I'm making no attempt to integrate a migrations framework into our ORM. My post is half in jest; I really do just alter table when I want to migrate. So I am less than useless here.

Name: Anonymous 2011-02-02 23:39

Name: Anonymous 2013-08-31 7:50


The intuition behind the formal definition of cardinal is the construction of a notion of the relative size or "bigness" of a set without reference to the kind of members which it has. For finite sets this is easy; one simply counts the number of elements a set has. In order to compare the sizes of larger sets, it is necessary to appeal to more subtle notions.

Name: Anonymous 2013-08-31 8:34


Georg Cantor formalized many ideas related to infinity and infinite sets during the late 19th and early 20th centuries. In the theory he developed, there are infinite sets of different "sizes" (called cardinalities).

Name: Anonymous 2013-08-31 9:20


In 1584, the Italian philosopher and astronomer Giordano Bruno proposed an unbounded universe in On the Infinite Universe and Worlds: "Innumerable suns exist; innumerable earths revolve around these suns in a manner similar to the way the seven planets revolve around our sun. Living beings inhabit these worlds."

Name: Anonymous 2013-08-31 10:06


The above systems can be modified to allow urelements, objects that can be members of sets but that are not themselves sets and do not have any members.

Name: Anonymous 2013-08-31 10:51


However, the set existence axioms of NBG are restricted so that they only quantify over sets, rather than over all classes. This causes NBG to be a conservative extension of ZF.
Don't change these.
Name: Email:
Entire Thread Thread List
All trademarks and copyrights on this site are owned by their respective parties. All comments and posts are the responsibility of their own posters.
- Tinychan + 2ch Mode -