similar to: How to copy between databases?

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

Hi all - New to rails... been reading as much as I can though and have yet to find a solid answer (although I think I found an unsolid negative). I''m wondering if there''s a way to split up the reads and writes in Rails so that pages/actions that don''t need to write can query from a group of mirrored databases. And my content managers can update a single master. I

Does anyone have any experience getting ODBC to work? I could really use some help here. I''m having trouble accessing a db2 database via odbc using rails. It''s an external database, that I import data from. I have placed the connection code in my model : unless connected? establish_connection( :adapter => "odbc", :dsn => "<dsn

Hi there! How can i use 2 database connections in my rails application ( if it''s possible of course ): one for reading from DB and one for writing to DB? Thanks, Dmitry -- 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

Hey, I have got a script that returns a long list of font family names, which I all want to store in a variable (array). I tried doing this with @f = font.family also in the for loop below but it only prints the last item when I want to display the results. require ''rubygems'' require ''RMagick'' include Magick for font in Magick.fonts puts font.family end

Hi everyone, I was wondering what the common practice for handling multiple db users with fine grained privileges on multiple databases is. Against the often read guideline for rails users to keep with a single db as "more dbs don''t really make sense anyway", my opinion is that it DOES make sense to use more than one db schema for a number of reasons that I won''t

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''ve now read a lot about application-level authentication in Rails, but I need to do database-level authentication. The reason is that my database needs to have the current_user (database current_user, not current_user defined in an ActiveRecord Model) set to execute triggers for automatically updating audit tables. So it is not enough to have a session check against a User

Hi, I have a legacy database ''old'' and a new database ''new'' which rails uses. I set up models using old with establish_connection(old), and this works well, except for include: class OldModel < ActiveRecord::Base establish_connection(old) end class NewModel < ActiveRecord::Base has_one :old_model end a = OldModel.find :first NewModel.find(:all,

I saw this mentioned on Dave Thomas''s blog http://blogs.pragprog.com/cgi-bin/pragdave.cgi/Tech/Ruby/EIR.html and don''t remember having seen it announced on this mailing list. This new Beta Book is at http://pragmaticprogrammer.com/titles/fr_eir/index.html regards Justin

Hi, My application spans 2 (or more) databases for some very specific reasons... My models are working fine, even dynamically establishing connections as needed at runtime, and spanning relationships across the databases (which really impressed me). The problem is, I can''t seem to force Units for these models (that use a secondary db) to load their fixtures into and use the

Dear list, This weeks RCW has a slightly different format than before. After all, since what we want is less bloat, this RCW is less verbose. Please do let me know what you think off-list. *Interesting stuff on the Rails Timeline* _Fixed and commited to trunk:_ An issue with not null columns in SQLite3 migrations(<a

Hey Folks, This is a quick release that fixes a major bug. I forgot to require the timeout library properly in mongrel.rb so people using Mongrel outside of Rails would see pauses. 0.3.3 fixes this all up. The 0.3.3 release also has a small change to the examples/simpletest.rb file with some gzip response using Ruby''s zlib support. Curious what people think about this and whether it

Hello all. I am currently running a very simple ruby app. It connects to an Oracle server using the OCI8 adapter. I have two controllers, each one connects to a different schema on the server, I looked at the WIKI that had details of multiple database connections (http://wiki.rubyonrails.com/rails/pages/HowtoUseMultipleDatabases), I moved the code from the application controller into each

Recently discovered Markaby. Before I use it on a production system, I''d like to know if it is still being maintained? According to the change log, the last change was in February of 2006. Does this mean that the project has been abandoned? Or, at version 0.3 it was considered production stable and complete? -- Best Regards, -Larry "Work, work, work...there is no satisfactory

Hi, We have experienced some problems with ActiveRecord::Base class of Ruby-Rails. We are building a web-application based on the Ruby-rails framework and the web-application needs to access to difference databases, so we do not pre-define our database accesses in the database.yml file. In fact, we are using the ActiveRecord::Base.establish_connection() to connect to our database, the function

Not sure if this is old news or not, but it would appear that both the Ruby Cookbook and a Rails book are now available for purchase at O''Reilly Rough Cuts (something akin to PragProg''s beta book program): http://rubyurl.com/nHz http://my.safaribooksonline.com/?mode=roughcuts&srchtext=ROUGHCUTS I haven''t tried them yet, but it definitely seems worth checking out.

So, is there a summary of the changes since the first edition? It would be helpful to see just exactly what in Ruby on Rails has changed before ordering the second edition of the book. Could somebody briefly describe changes to Rails since the version covered in the first edition of the book?

With after triggers in Postgres, there are special NEW and OLD vars accessible to trigger functions. Any such thing in Rails? Or would it entail doing something like setting a class var in before_update? Jack -- Posted via http://www.ruby-forum.com/.

Hi everybody, I''m experiencing trouble when trying to use ruby-postgres with a legacy database I need access to. To me it seems the problem is the VARCHAR columns used there as primary keys. On a simple me = User.find(''PS12345'') I get a type error exception with the message ''can''t convert String into Integer''. The trace is: