Question about db

rubyonrails-talk
1

Hello world,

I'm new in this forum.

Is it possible to sqlite and mysql coexists in same RoR app? I want to extend functionalities to an app making queries toa mysql server and I'm not sure if I can do it.

Thanks a lot,

P

2

Hello world,

I'm new in this forum.

Is it possible to sqlite and mysql coexists in same RoR app?

Individual models can be mapped to entirely different databases (running under different engines). More commonly, different applications are mapped to different databases, and Rails as of 2.something supports mounting one application inside another, so that could give you the kind of isolation you're talking about here.

I want to extend functionalities to an app making queries toa mysql server and I'm not sure if I can do it.

Are you saying you have a problem with MySQL on your server, or what?

Walter

3

Hi Walter,

Thanks a lot for your answer, Walter Davis wrote in post #1028584:

Hello world,

I'm new in this forum.

Is it possible to sqlite and mysql coexists in same RoR app?

Individual models can be mapped to entirely different databases (running under different engines). More commonly, different applications are mapped to different databases, and Rails as of 2.something supports mounting one application inside another, so that could give you the kind of isolation you're talking about here.

I want to extend functionalities to an app making queries toa mysql server and I'm not sure if I can do it.

Are you saying you have a problem with MySQL on your server, or what?

Walter

I have an application for CRM using RoR, but now, i'd like to connect to OrangeHRM (an opensource HR Management over LAMP),to send sql queries against this mysql server.

My problem is not related about onnecting mysql; I mean, at database.yml, can coexists a production for mysql and sqlite or sould I try other approach?

Thanks a lot,

P

4

Hi Walter,

Thanks a lot for your answer, Walter Davis wrote in post #1028584:

Hello world,

I'm new in this forum.

Is it possible to sqlite and mysql coexists in same RoR app?

Individual models can be mapped to entirely different databases (running under different engines). More commonly, different applications are mapped to different databases, and Rails as of 2.something supports mounting one application inside another, so that could give you the kind of isolation you're talking about here.

I want to extend functionalities to an app making queries toa mysql server and I'm not sure if I can do it.

Are you saying you have a problem with MySQL on your server, or what?

Walter

I have an application for CRM using RoR, but now, i'd like to connect to OrangeHRM (an opensource HR Management over LAMP),to send sql queries against this mysql server.

My problem is not related about onnecting mysql; I mean, at database.yml, can coexists a production for mysql and sqlite or sould I try other approach?

I haven't needed to do it myself yet (actually working on something that will need this) but I have seen many tutorials on the Web related to connecting a single Rails application to multiple databases. It is just as simple as you say, make a production_1 and production_2 database connection, and use them through the base classes to set up the appropriate targets for your queries.

But what I suspect may be even easier here is for you to use something like Sinatra to create a very simple API endpoint wrapping around the legacy database, and then send requests through that API from your Rails application. It doesn't sound to me (you did mention SQL queries, after all) as if you actually need that other database to become an ActiveRecord model store.

Walter

5

Walter Davis wrote in post #1028614: