similar to: Database Selection

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

I''m currently using Perl, Class::DBI, Template Toolkit on top of Mysql and I''m about to try my hand at a first Rails app. The power of Rails and Ruby has me very intrigued... The O-R mapping in Class::DBI seems to be covered by AR, so I''m hoping it is a workable proposition. I plan to build a simple test case to get up to speed before converting a large production

Is there any reason to avoid using postgresql for small web apps? That is, is it''s overhead so large that the lighter MySQL will work substantially better for small apps on small machines? Or are they very similar in performance and configuration? I''ve used MySQL but postgresql has its appeals and I''m wondering if I need to keep MySQL around at all. On the other

Hi, Strange behavior here. On my dev machine code works, but on the production machine I get the dreaded: SQLite3::BusyException: database is locked INSERT INTO "comments" [...] What kind of bug could yield such behavior? It''s impossible the database times out, there are no concurrent requests coming in, and the db is only 150kB. Is there a possible race condition? Caching

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

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 All, In my companies environment, we have multiple sites in multiple geographic locations, sometimes with high latency between the sites. I''m trying to come up with a solution that could provide puppet infrastructure to all sites nodes. ----a few assumptions--- - puppet manifest / configuration is fetched from a centralized version control system. - store db is needed (ssh keys,

I have unit tests set up with "self.use_transactional_fixtures = true", so each test should roll back. Run individually, all my tests succeed. But running "rake test:units", I get the below error in 5 test cases. I''m not sure how to solve this since I''m not sure how to debug tasks run thru rake. Any ideas are appreciated. 1) Error: test_delete(OrderTest):

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

Hi folks, I''m looking for advice on how to promote RoR in my workplace. Specifically, I''d like to work out a strategy for promoting development in Rails as a new alternative to our existing technology (the usual suspects... mostly Java/Oracle, .NET, PHP, and a bit of Perl here and there). Some background: I work for a fairly large state environmental agency as a web developer.

I know this is a bit off topic but we are using Asterisk :) Since this list is full of tech gurus w/ all different sorts of backgrounds, I thought I would get the best opinions here. We have several different switches and other telecom equipment at our facilities which all have their own proprietary cdr platforms, which are rather limited. The company I work for is looking to develop their

I''ve been looking through some references but can''t seem to find the right syntax and commands. I basically just want to have a migration to convert my db and all my tables to InnoDB. Does anyone know a tutorial or the migration syntax to do this? Thanks in advance :-) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are

Hi, is this the best forum to answer this question? Is there any better source for information or another mailinglist to address this question to? Cheers, Mariano ---------- Forwarded message ---------- From: Mariano Kamp <mariano.kamp@gmail.com> Date: Jan 8, 2006 6:24 PM Subject: Migration doesn''t seem to preserve create_table options in schema To: rails@lists.rubyonrails.org

I've a weird problem with Samba. I'm using Samba to share a filesystem between two linux systems because I believe I need byte range locking to prevent multiple processes on different computers from reading/writing the same ISAM records. I have a Debian wheezy file server running Samba; no domain controller, just a simple, single share. I have a debian wheezy KVM mounting a share via

Hi, I have a self-referential has_many :through relationship setup to track relationships between users. Basically relationships are modeled as a join table with an extra column ''relation''. create table relationships ( user_id integer unsigned not null, friend_id integer unsigned not null, relation char(1) not null, ) --- relations --- f = friend r = request to

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,

Hi, I've noticed that Oracle is charging for the MySQL version that supports InnoDB (http://www.mysql.com/products/). I could not find any other link with direct confirmation of what is going to change for the existing servers/versions and I was wondering if anybody has a more detailed info. For example, is RHEL (and CentOS) going to drop support for it? Are we going to see any further

Is there a nice way in rails to automatically extract an exising database schema from an existing app and then in a new app automatically create a database based on this schema? -- 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

I have a problem with tests. I always thought that the order of tests doesn''t matter because the fixtures are reloaded before every test method. However, I''ve just discovered that this isn''t true. This is a quote from the "Guide to testing the rails" howto: "... if we had another test method, we wouldn’t have 10 users on the 2nd test because they would

Here''s an alternative in-depth treatment on setting upo rails on Debian (Ubuntu, Kubuntu, ... ), may be interesting to follow through in more detail for some: The Perfect Rails/debian/lighttpd Stack... ( http://brainspl.at/pages/perfect_vps ) Victor Kane http://awebfactory.com.ar On 3/25/06, rails-request@lists.rubyonrails.org < rails-request@lists.rubyonrails.org> wrote: >