similar to: Per Session Database Connection

Hello, I have an application that access two different DBMS - Firebird and Postgres. So far, that''s ok. The problem is, depending on the customer logged, a different database (Firebird) must be selected. To make the things clearer: Postgres: 1 database shared by all customers with these tables: - user - vehicle - driver Firebird: several databases with different names and identical

My Rails application requires a very busy worker process running in the background at all times. I am launching this non-interactive process using script/runner. This process is very busy and is communicating with the MySQL server constantly. As I started putting some load on the system to test, I started running into performance issues. I have since discovered that Rails is only using 1

Hello, I need some guidance. I have a need to: a) Login, validating against a "system-level" user database - no big deal, then b) Depending upon the login, select a customer database for processing. For instance, assume that my login profile lists an area of interest: cars, motorcycles or boats. Each of these has a database, with identical table formats. If my login shows my area of

I''m coming from an Oracle and SQL Server background. I''d like to use OpenSource for my next RoR project. MySQL5.x and Postgres8.1 seem to be the most popular. I''d like some comments on which would be the better choice for a production environment and why. Here are my initial concerns in order of priority: 1. Works well with RoR. ( migrations, etc) 2. Stable enough

I''ve been looking at using mongrel for a lightweight web service I want to do in ruby. Everything looks pretty simple, but I''m wondering what would be a good way to persist database connections? Is there an easy way to use activerecord in a custom handler and use it''s connection pooling? Chris

Hi all, I have played with JRuby on Rails in the past and managed to make it work with Firebird. Although migrations did not work, I managed to do everything manually and it worked. Now, I am working with Ruby on Rails and was wondering if anyone here has managed to get Rails to work with Firebird 2.1.x. If yes, what were the steps? I installed fb and fb_adapter, and I get the following error:

I was hoping 1.1 would provide a way to map SQL "decimal" column types to BigDecimal values, since BigDecimal is part of the Ruby standard api as of 1.8. But I don''t see any support for that in the migration documentation, and when I try to let Active Record do the mapping for me, it seems to coerce the column into a Float (as the AwdwR book says). Is it really there in

Hi, I really need help to understand what is happening while Rails connect to a database, (we area actually using postgresql, so my example will be with postgresql) What I understand is Rails is able to connect to different DB. Actually, this is what we want, and we have made some tests, everything is juste fine. However, all these tests lead us to some important questions that we did find the

Hello! I experienced problems with testing transactions which are supposed to be rolled back, but are not, because of transactional fixtures eliminating the inner transaction. Can this be worked around somehow without turning off transactional fixtures? Maybe savepoints can help this? Does anyone have any experience with savepoints to achieve nested transaction functionality? Both Postgres

1. That was a part of a private email exchange. It has been suggested that more people may be interested. 2. I did use various databases (significant part of my job) for the last 15 years. Some with R for the last 3 years as a hobby. Some comments on the ones used below. Sorry, no links - I am time-constrained at the moment - please google if interested in details. The remarks are from the point

I've installed Wine 1.1.35 on a fresh Ubunti 9.10 and attempted to install the BDE. The BDE Administrator runs normally (BDEADMIN.EXE) but I'm unable to make any connections to our Firebird server - attempts to open the connection give me error "Vendor initialization failed" and "Cannot load an IDAPI service library. File GDS32.DLL". I've put this file into the

I want to copy data from one database to another using rails. But, it seems that rails only will talk to one database at a time. Is there a way around this? Any help would be greatly appreciated. -- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson -------------- next part -------------- An HTML attachment was scrubbed...

Hello Rails community I cannot seem to find via Google what I had hoped would be a simple issue On a single DB system (currently, postgres 8.1.4), I have two databases, each containing multiple tables. I would like to configure my app and database.yml to recognize these two databases. What is the corrrect config for the database.yml ? Is it something like: > production: > adapter:

I threw together a web gui for the static database configuration over the last couple of days. I built it using mod perl and the template toolkit. If enough people show an interest in this I'll put up a distribution, although it could take a few days. The interface is as generic as possible so you can throw pretty much any asterisk .conf file in and it works. The interface assumes you

Does anyone know how to make a model connect to a remote database and only for that specific model? That way I can do the typical CRUD functions on a remote server? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group,

Hi We have a rails application deployed and working fine. Along with this, we are planning to add "Opinion" forum. The url of the forum will be like http://forum.mymainsite.com Is it possible to share the session (that is, if the user is already logged in on the main site, he need not log in again on the forum section). Is it possible to add the ''opinion'' as a

Hello! I''m new to Ruby and Rails, but have been reading along here, and searched the archives and didn''t see anything addressing some concerns I have with using Rails and Firebird. I prefer Firebird when it is available, and I''m very pleased to see that others have gotten it working with Ruby. I have been trying to use it with Rails, with mixed success.

I saw that there''s a patch in the queue (http://dev.rubyonrails.com/ticket/1874) for a Firebird adapter. Just wondering if anyone is using this, the other Firebird adapter, or something else w/ Rails. My main interest is that sometimes Windows is a target platform, and Firebird is stable on Windows, whereas I''ve heard that the Windows version of PostgreSQL isn''t

I am trying to generate some scaffolding using "ruby script/generate scaffold order order". It always fails with the message "uninitialized constant CHARACTER_SET". I have an orders table in a Firebird databse called TARPRILOGISTICS.GDB. The database is in a folder named "database" in my rails app root folder. I tried FireRuby 0.4 and 0.4.1. My config file looks

I want to return my own error messages from an API instead of letting the client see the stack trace. I''m returning a custom structure so I guess I could just put a member in that structure for the error message, although that seems like kind of a hack. Any suggestions? Chris