Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
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>&gt; Hi g=
uys, <br>&gt; <br>&gt; I'd love to get your ideas on how to manage a databa=
se if it's used by multiple applications.<br>&gt; <br>&gt; 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>&gt; <br>&gt; 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>&gt; <br>&gt; Rails can handle "one", "two", "three" usin=
g db migration. <br>&gt; - Should it handle table creation/migration for "f=
our" and "five"? <br>&gt; - 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>&gt; - What's the best approach to make the WHOLE=
 database scriptable, versionable and CI-buildable?<br>&gt; <br>&gt; Thanks=
,<br>&gt; Jim<br>&gt; <br>&gt; -- <br>&gt; You received this message becaus=
e you are subscribed to the Google Groups "Ruby or Rails Oceania" group.<br=
>&gt; 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>&gt; 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>&gt;=
 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>&gt; 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--