similar to: Rails doesn't scale because RI/transactions in app not db!!!

Here''s the situation: I have a "people" table whose "id" column serves as a foreign key to several other tables (authorships, editorships, members, users, etc.). Every now and then I will find two distinct records in the "people" table that represent the same human being. They generally differ by small differences in spelling but should really be the

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

So by default to get STI, I would have something like: create_table :items do |t| t.column "type", :string t.column "title", :string end But if I want to store those type values in a separate table, such that I have ... create_table :items do |t| t.column "item_type_id", :string t.column "title", :string

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

Hi, Is rails supposed to support referential integrity? That is rails either support to be able to ensure that when a new contact is created this can only happen if a valid suberb is associated with it, and which mechanisms of the below are supposed to do this? (a) using DB foreign key constraints information as a basis? (b) using the "has_one" line in the model file to enfore? If

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

Hello folks, I use to think that a relational databases without foreign keys constraints enforced strictly by the RDBMS were no good, piece of crap, data junk. However, I''ve also learned the hard way that FKs constraints imposes serious difficulties when moving data around, specially between different DBs, or for loading test data or for upgrading DBs schemas, or for porting DBs

I''ve seen a lot of issue regarding the stability of Rails apps. I''m charged with investigation of Rails for my company and I''ve looked at numerous fourms, groups, etc. (Textdrive, here, etc.) and it *seems* like there is a stability problem with Rails (ie: crashes, etc.) Is this as common as it looks, or is this tied to things like Lighttpd (web server) or Typo

I was trying to deal with foreign key issues related to order of fixture loading when I came across this: http://techpolesen.blogspot.com/2007/04/rails-fixture-tips.html This got me looking deeper into rails and I noticed that db:fixtures:load calls Fixtures.create_fixtures once for each fixture file. However, Fixtures.create_fixtures is capable of taking multiple files and also handle the

Hi, Is there a way to use the :dependent option to set a certain attribute to null rather than destroying the records? For example, take the following models: User id, integer name, string group_id, integer belongs_to :democrats Groups id, integer name, string has_many :users If I delete a certain group, is there a way to have the ''group_id'' attribute of all the

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

Hello and happy holidays, everyone! I received the book "Enterprise Rails" by Dan Chak as a Christmas gift and started reading it; I wanted to gauge the community''s thoughts on this. Basically, Mr. Chak advocates a totally different approach to how every other Rails book/tutorial explains how to develop Rails applications. Firstly, he advocates you organize your

Hi all, I''m messing around with has_many, and has_many :through (on edge rails), using a join model. Branches and Projects join through ProjectsAtBranches. If I do @branch.projects, I can see the associated projects, and visa-versa, if I manually put them in the join table. But I cannot do @branch.projects << Branch.find(blah), or @branch.projects.clear, and then save the

OK ... there has been an awful lot of attributing problems to the 4.4 upgrade that are not really upgrade problems. The best I can tell there is really only one major problem: 1. You need to install python-sqlite before sqlite (or at nearly the same time). To accomplish this you can do this: yum update python-sqlite sqlite Then after that, a normal yum update works fine. There are 2 other

Can anyone recommend a database modelling tool for the Mac? I''m building a new Rails app and want an interface to draw out the database''s entity relationship diagram, setup foreign keys and then output DDL at the end to MySQL. I''ve previously used DBDesigner, CASE Studio and some pricier enterprise software on Windows, but can''t find anything suitable for my

I see in my overnight email spool: https://bugzilla.redhat.com/show_bug.cgi?id=726872 I am amused because this kind of request comes up time and time again with respect the package management system It is technically _possible_ to attain this kind of rollbacks, in some tightly controlled environments [something like cell phone tower control computer applications, where there are

Greetings, On 3/24/11, Akemi Yagi <amyagi at gmail.com> wrote: > I should note, however, that they are not for production use. > > Akemi Thanks Akemi very much for your always relevant and brilliant works. </rant> As an Indian, where "veda" repository of knowledge originated, I have always looked at every member of this list as a repository of knowledge.

Hello, I'm planning migration of current two clusters based on CentOS 6.x with Cman/Rgmanager going to CentOS 7.x and Corosync/Pacemaker. As the clusters and their services are on the same subnet, and there no particular security concerns differentiating them, I'm also evaluating the option to transform the two clusters into a unique 4-node one during the upgrade. Currently I'm

Is there any reason why AR has never supported foreign-key constraints? I can understand the lack of support for triggers and stored procedures since they are highly dependent on the database to create a wrap API around them. But this is not the case for foreign keys. This is specially important for open-source projects like Redmine/Chiliproject and Gitorious where you shouldn''t be

Hi all - I am having some trouble figuring out how to model self-referential entities in Rails. I have a "group" model, which can have 0 or more "group" objects or 0 or more "user" objects. I tried creating a subgroup table that has a parent_group_id and a child_group_id as foreign keys but can''t figure out how to create the mapping in my ruby model