Re: [Rails] EAV Model vs Rails

2010-03-10 Thread Michael Pavling
On 9 March 2010 18:59, Sumeet Panchal wrote: > So problem is I have to convert, the 200 table database to EAV. Has > anybody worked with > EAV model, know its pros cons, and how to do this in rails. The only EAV data model I've used in anger is the back-end of the PHP ecommerce system Magento. It

Re: [Rails] EAV Model vs Rails

2010-03-10 Thread Andy Jeffries
> > If you're doing that a lot in your database, personally I'd recommend > looking at one of the NoSQL types such as CouchDB or Cassandra. Most of my > work is neatly normalised tables, but if I had a lot of really freeform data > as you seem to, that's where I'd look. > On the other hand, if yo

Re: [Rails] EAV Model vs Rails

2010-03-10 Thread Andy Jeffries
> > I have a relational database (MySQL) with 200 tables in it. Now I want > to reduce number of tables (If it helps in improving the > application). > > One approach is to use EAV database model. In which we can use a table > to store ID and manadatory details and > other table to store rest of th

[Rails] EAV Model vs Rails

2010-03-09 Thread Sumeet Panchal
Hi, I have a relational database (MySQL) with 200 tables in it. Now I want to reduce number of tables (If it helps in improving the application). One approach is to use EAV database model. In which we can use a table to store ID and manadatory details and other table to store rest of the details