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.
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.
