I was wondering if somebody has some insight on this issue.
[h]A little background:[/h]
I work for a midsize electronic manufacturing company with 2 people in
IT dept - a network admin and a developer (me).
We’ve been using rails to migrate from an old dBase and VB based system
to build internal company IntrAnet that does things like label printing,
invetory control, shipping, etc.
Right now we need to replace an old website that was done in Java, that
would connect to our internal system for out clients to use. We want to
be able to pull information like live inventory, order placement,
Does anyone have any suggestion on how to accomplish this in a better
Here are three options that I see:
a) Build a separate Rails app on a web server, that will connect to the
same DB that our internal app connects to.
Live data - same thing that our internal apps see, i.e.
orders are created in real time, inventory is depleted right away,
Potential security risk, duplication of code - i.e. I need to
duplicate all the controllers, models, views, etc. that deal with
b) Build a separate Rails app on a web server, that will connect to a
different DB from our internal app.
Less security exposure.
Extra effort to sync web DB and internal DB, extra code to
handle inventory depletion and order # creationg ,duplication of code -
i.e. I need to duplicate all the controllers, models, views, etc. that
deal with orders.
c) Expose internal app to the web
all the problems from above eliminated
A lot more security headaches. Duplication of login systems -
one for web - one for internal users using LDAP.
So any thoughts? Anyone had similar problem to solve?