similar to: rails & mysql

Hi, I have been using myisam tables in mysql with rails because my client will soon want fulltext searchable content, however when I migrated my development db from schema.rb all of the tables generated were innodb. I understand that I can override this, but also like the transactions and foreign keys of innodb. So 2 questions really: 1. are transactions in activerecord dependent on innodb or do

Dear R Developers, In the same way that MySQL/MariaDB's Engine InnoDB or MyISAM/Aria have the innodb_buffer_pool_size or the key_buffer_size for setting the maximum amount of RAM which can be used by a Server Instance: ?Would it be possible to create an R Configuration Variable which fixes the maximum amount of RAM memory to be used as Commit / Dynamic Memory Allocation? Thank you. Juan

I tried adding a FULLTEXT search index to a table of mine in MySQL, only to discover that the InnoDB table format doesn''t seem to support this feature. Switching to the MyISAM table type seemed to work, but I seem to have some recollection that ActiveRecord transactions aren''t fully atomic on MyISAM tables. Is this true or am I just remembering wrong? If so, does anyone have

Ok, So I followed the directions.. I did a ''gem install markaby'' (which sounds like its enough to get me going for rails), but I wasn''t sure, so I tried to install the plugin as well. Plugin installation fails looking for a file: Script/plugin install http://code.whytheluckystiff.net/svn/markaby/trunk Outputs this error: + ./trunk/svnindex.xsl

I just got a Google Groups notification that I had been subscribed to http://groups.google.com/group/rubyonrails-talk. Looking at the page, it appears that about 4300 folks have been subscribed. However, I saw nothing about this on rails@lists.rubyonrails.org. Wazzup? -r -- http://www.cfcl.com/rdm Rich Morin http://www.cfcl.com/rdm/resume rdm@cfcl.com

One should be able to change the value of a primary key, right? But it''s not working for me. If I do this: @drug = Drug.find(tid1) @drug.id = tid2 @drug.category = ''Test2'' if @drug.save savedok = ''Saved successfully'' else savedok = ''Not saved'' end I get ''Saved successfully''

Hello there, So I''m still struggling with this fastcgi stuff. I''m trying to upload and process a decent sized ZIP file, but the request dies before it finishes and I get the following error: FastCGI: comm with (dynamic) server "/Users/ryan/Workspace/rails/photos/public/dispatch.fcgi" aborted: (first read) idle timeout (30 sec), referer: http://photos/album/new/4

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

Help me!!!Lol I''ve been working with RedCloth but it''s runed my layout because it put the <p> and </p> is there a way to remove this without gsubing it up or if I do what the prettiest I can make it? -- Posted via http://www.ruby-forum.com/.

Hi, I am a RoR newbie and I''ve been experimenting with different databases (mySQL, PostgreSQL, etc.) and different table types (MyISAM vs. InnoDB). Is there a preferred database/table type for RoR development. I like how MySQL''s InnoDB tables enforce referential integrity, but these tables require a lot more storage space then MyISAM tables. For everyone with a lot of RoR

I''ve been creating my tables using the command line approach Dave advocates in AWD. I just noticed that they''re being created as MyISAM-type tables. I remember reading (but not where) that I should be creating these as InnoDB-type tables. So, two questions... 1) Is the table type important? (a "why" component to the answer would be nice too ;-) ) 2) If so, is

Hi, Could anyone point to some TextMate resources ? I found a few bundles, but they were all corrupted... JEtienne -- Posted via http://www.ruby-forum.com/.

I needed to install rmagick/GraphicsMagick on an IntelMac and did so from Darwinports. Some things work and others don''t work, like rendering fonts which needs X11 fonts and X server. The rmagick page at rubyforge points to .. http://developer.apple.com/opensource/tools/runningx11.html where X11 link to Apple is broken. X11User.pkg talked about on the page above no longer exists at

I am working on an application where there are many different screens to access the data in a particular record/row. I have links to each data entry screen at the top. Is there a way to detect whether the current hash has been changed from the stored record so I can prompt the user if they attempt to change screens without having saved their changes to the data? Craig

Hi All, Just a quick note to say that I''ve released an intial version of the request routing plugin which essentially allows you to use various request object properties as requirements in routes. Most notably you can do: map.connect "thing", :controller => ''main'', :requirements => { :subdomain => ''whatever'' } ..just like the wiki

Can someone please tell me the best approach to adding support for editing MySQL decimal types in rails? I have a field in the DB that represents currency, and the view will not let save anything past the decimal place so, 10.99 becomes 10.00 automatically. Any help is appreciated. -- Posted via http://www.ruby-forum.com/.

Ok so I am at a point that I read my entire book front to back and around and a around. And now digging through it again .. But I am now missing a key piece to the clues is the api. I found http://www.gotapi.com/index.html as a great search tool. But I can''t make heads or tails of it besides a basic search for exactly what I am looking for by word. But if I dont know the word I am

I''ve been using the Business::FedEx::DirectConnect perl module to track and ship packages via FedEx for awhile now. I''m wanting to convert some of this functionality over to ROR, mostly just the package tracking part. Has anyone successfully tracked a package using the Shipping API out on RubyForge? It seems like the functionality is there since it''s just another

i''m using a table, that uses fulltext search and therefore the table type MyISAM everything works fine in production mode, but tests fail with ActiveRecord::StatementInvalid: Mysql::Error: The used table type doesn''t support FULLTEXT indexes when looking in the test db it''s clear, that it''s using InnoDB, but even manually changing the table type does not help,

I''ve got a nice XML view of my data that works just fine when I call it from the browser. Now I''d like a different controller method to take that XML and write it to the file system. Since the XML view lives in an RXML file, is there a trick to telling the controller "Get your output into a string" instead of writing it back to the browser? After writing it out