Message from discussion
One database - multiple applications
Received: by 10.236.185.226 with SMTP id u62mr10362623yhm.23.1343830646122;
Wed, 01 Aug 2012 07:17:26 -0700 (PDT)
X-BeenThere: rails-oceania@googlegroups.com
Received: by 10.236.121.34 with SMTP id q22ls2942401yhh.7.gmail; Wed, 01 Aug
2012 07:17:19 -0700 (PDT)
Received: by 10.100.83.10 with SMTP id g10mr1456185anb.16.1343830639939;
Wed, 01 Aug 2012 07:17:19 -0700 (PDT)
Received: by 10.50.150.202 with SMTP id uk10msigb;
Wed, 1 Aug 2012 06:47:24 -0700 (PDT)
Received: by 10.68.233.226 with SMTP id tz2mr2815523pbc.13.1343828844614;
Wed, 01 Aug 2012 06:47:24 -0700 (PDT)
Date: Wed, 1 Aug 2012 06:47:24 -0700 (PDT)
From: marsbomber <jimji...@gmail.com>
To: rails-oceania@googlegroups.com
Message-Id: <fe018cc2-e20d-44b5-ab15-ca6b70be38ca@googlegroups.com>
In-Reply-To: <9179F5DF-41F7-4CC9-9A78-819F4BFF5F20@freelancing-gods.com>
References: <c90dc2c5-0feb-4499-b575-f9d0e3460209@googlegroups.com>
<9179F5DF-41F7-4CC9-9A78-819F4BFF5F20@freelancing-gods.com>
Subject: Re: [rails-oceania] One database - multiple applications
MIME-Version: 1.0
Content-Type: multipart/mixed;
boundary="----=_Part_1096_25314672.1343828844100"
------=_Part_1096_25314672.1343828844100
Content-Type: multipart/alternative;
boundary="----=_Part_1097_27049699.1343828844100"
------=_Part_1097_27049699.1343828844100
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Thanks Pat. I'd much prefer doing all db migration via Rails ... and it
looks like I might have to play hardball (again...) to make sure that
happens.
Re having one lang, one framework, tried and failed ...
On Wednesday, 1 August 2012 22:59:38 UTC+10, Pat Allan wrote:
>
> I'd probably put it all in Rails migrations, so at least there's
> consistency and a single point of truth. Otherwise, you may end up with
> code in one place making one change, and then code in another - unaware of
> those changes - try to do the same thing, or try something now impossible.
>
> Granted, I'd prefer just to avoid the situation completely and have it all
> one app, one language, one framework.
>
> --
> Pat
>
> On 01/08/2012, at 2:48 PM, marsbomber wrote:
>
> > Hi guys,
> >
> > I'd love to get your ideas on how to manage a database if it's used by
> multiple applications.
> >
> > Here's the scenario. A MySQL database will be used by 2 separate
> applications, one written in Ruby/Rails, the other written in Perl.
> >
> > Let's say there're 5 tables in the db, "one", "two", "three", "four" and
> "five". The Rails app uses 3 tables "one", "two" and "three". The Perl app
> uses "three", "four" and "five".
> >
> > Rails can handle "one", "two", "three" using db migration.
> > - Should it handle table creation/migration for "four" and "five"?
> > - What about table "three"? If the Perl app needs to add extra columns
> for its own purpose, should the changes be done using the Rails db migrate?
> > - What's the best approach to make the WHOLE database scriptable,
> versionable and CI-buildable?
> >
> > Thanks,
> > Jim
> >
> > --
> > You received this message because you are subscribed to the Google
> Groups "Ruby or Rails Oceania" group.
> > To view this discussion on the web visit
> https://groups.google.com/d/msg/rails-oceania/-/A4ka74XblcYJ.
> > To post to this group, send email to rails-oceania@googlegroups.com.
> > To unsubscribe from this group, send email to
> rails-oceania+unsubscribe@googlegroups.com.
> > For more options, visit this group at
> http://groups.google.com/group/rails-oceania?hl=en.
>
>
>
------=_Part_1097_27049699.1343828844100
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Thanks Pat. I'd much prefer doing all db migration via Rails ... and it loo=
ks like I might have to play hardball (again...) to make sure that happens.=
<div><br></div><div>Re having one lang, one framework, tried and failed ...=
<br><br>On Wednesday, 1 August 2012 22:59:38 UTC+10, Pat Allan wrote:<bloc=
kquote class=3D"gmail_quote" style=3D"margin: 0;margin-left: 0.8ex;border-l=
eft: 1px #ccc solid;padding-left: 1ex;">I'd probably put it all in Rails mi=
grations, so at least there's consistency and a single point of truth. Othe=
rwise, you may end up with code in one place making one change, and then co=
de in another - unaware of those changes - try to do the same thing, or try=
something now impossible.<p>Granted, I'd prefer just to avoid the situatio=
n completely and have it all one app, one language, one framework.</p><p>--=
<br>Pat</p><p>On 01/08/2012, at 2:48 PM, marsbomber wrote:</p><p>> Hi g=
uys, <br>> <br>> I'd love to get your ideas on how to manage a databa=
se if it's used by multiple applications.<br>> <br>> Here's the scena=
rio. A MySQL database will be used by 2 separate applications, one written =
in Ruby/Rails, the other written in Perl.<br>> <br>> Let's say there'=
re 5 tables in the db, "one", "two", "three", "four" and "five". The Rails =
app uses 3 tables "one", "two" and "three". The Perl app uses "three", "fou=
r" and "five".<br>> <br>> Rails can handle "one", "two", "three" usin=
g db migration. <br>> - Should it handle table creation/migration for "f=
our" and "five"? <br>> - What about table "three"? If the Perl app needs=
to add extra columns for its own purpose, should the changes be done using=
the Rails db migrate?<br>> - What's the best approach to make the WHOLE=
database scriptable, versionable and CI-buildable?<br>> <br>> Thanks=
,<br>> Jim<br>> <br>> -- <br>> You received this message becaus=
e you are subscribed to the Google Groups "Ruby or Rails Oceania" group.<br=
>> To view this discussion on the web visit <a href=3D"https://groups.go=
ogle.com/d/msg/rails-oceania/-/A4ka74XblcYJ" target=3D"_blank">https://grou=
ps.google.com/d/<wbr>msg/rails-oceania/-/<wbr>A4ka74XblcYJ</a>.<br>> To =
post to this group, send email to <a href=3D"mailto:rails-oceania@googlegro=
ups.com" target=3D"_blank">rails-oceania@googlegroups.com</a><wbr>.<br>>=
To unsubscribe from this group, send email to <a href=3D"mailto:rails-ocea=
nia%2Bunsubscribe@googlegroups.com" target=3D"_blank">rails-oceania+unsubsc=
ribe@<wbr>googlegroups.com</a>.<br>> For more options, visit this group =
at <a href=3D"http://groups.google.com/group/rails-oceania?hl=3Den" target=
=3D"_blank">http://groups.google.com/<wbr>group/rails-oceania?hl=3Den</a>.<=
br>
<br>
<br></p><p></p><p></p><p></p></blockquote></div>
------=_Part_1097_27049699.1343828844100--
------=_Part_1096_25314672.1343828844100--