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 the

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 you did

Re: [Rails] EAV Model vs Rails

2010-03-10 Thread Michael Pavling
On 9 March 2010 18:59, Sumeet Panchal sumeetpanch...@gmail.com 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

[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