On May 16, 2013, at 4:07 PM, Julien Cigar <jci...@ulb.ac.be> wrote: > On 05/14/2013 16:58, Michael Bayer wrote: >> When you are storing data with key/values, where the set of keys is part of >> the data. Storing configurational data is the main use case. HSTORE not >> an option because it is postgresql-specific. > > Yes it may be acceptable to store configurational data (although I would > probably use HSTORE under PostgreSQL). But "a large EAV based project" sounds > terribly bad to me.
I agree, I've seen lots of projects where they base it all on EAV, and it's a terrible idea. But I was lucky to get my "everything-is-an-EAV" thing done with by about 1998. > >> >> >> >> On May 14, 2013, at 10:49 AM, Julien Cigar <jci...@ulb.ac.be> wrote: >> >>> On 05/14/2013 16:09, Michael Bayer wrote: >>>> EAVs have a definite place and with judicious use they are extremely >>>> useful. >>> just curious: could you give an example where EAV is useful ? >>> >>>> On May 14, 2013, at 4:37 AM, Julien Cigar <jci...@ulb.ac.be> wrote: >>>> >>>>> On 05/14/2013 02:22, Lycovian wrote: >>>>>> A few months ago I watched a video conference where Mike demo'd some >>>>>> optimizations for SQLAlchemy when using EAV schemas. Does anyone know >>>>>> if these optimizations will make it into the product that we have access >>>>>> to? I'm about to start a large EAV based project with SA and I was >>>>>> curious. >>>>>> >>>>> please don't ... EAV is evil and has tons of disadvantages. I don't know >>>>> about your database, but in PostgreSQL you have HSTORE and JSON which >>>>> could often be used to replace EAV >>>>> >>>>>> Mike >>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "sqlalchemy" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>>> an email to sqlalchemy+unsubscr...@googlegroups.com. >>>>>> To post to this group, send email to sqlalchemy@googlegroups.com. >>>>>> Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. >>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>> >>>>>> >>>>> -- >>>>> No trees were killed in the creation of this message. >>>>> However, many electrons were terribly inconvenienced. >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google Groups >>>>> "sqlalchemy" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send an >>>>> email to sqlalchemy+unsubscr...@googlegroups.com. >>>>> To post to this group, send email to sqlalchemy@googlegroups.com. >>>>> Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. >>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>> >>>>> >>> >>> -- >>> No trees were killed in the creation of this message. >>> However, many electrons were terribly inconvenienced. >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "sqlalchemy" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to sqlalchemy+unsubscr...@googlegroups.com. >>> To post to this group, send email to sqlalchemy@googlegroups.com. >>> Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.