I believe it was for some work you did for Akiban. If I remember correctly
(ha!) I believe you detailed with some slides an updated join strategy that
they are using (or that you hacked) into a custom version of SA used by
them. I noted the demo as I am planning on using EAV for a personal
oh, yeah I don't have that code, that was Ori talking about a particular client
integration they had, where they went bananas with EAV. The point there was
to show how Akiban does a much better job querying structures like that, but I
had no involvement in that gig.
The EAV stuff I have, you
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
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
On 16 May 2013, at 21:21, Michael Bayer mike...@zzzcomputing.com wrote:
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
On Thu, May 16, 2013 at 7:16 PM, Simon King si...@simonking.org.uk wrote:
I don't think this would be a good match for HSTORE - I assume that
retrieving values from HSTORE won't be as efficient as retrieving them from
their own rows.
It depends on the number of attributes per test. It won't
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
EAVs have a definite place and with judicious use they are extremely 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
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
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,
storing pickles in the database is an awful idea since your data is now
specific not just to Python but to the current shape of your object model at a
point in time. Storing JSON is not acceptable for the case where you need to
audit and version each user that has made changes to particular
On Tue, May 14, 2013 at 12:38 PM, Michael Bayer
mike...@zzzcomputing.com wrote:
storing pickles in the database is an awful idea since your data is now
specific not just to Python but to the current shape of your object model at
a point in time. Storing JSON is not acceptable for the case
On May 14, 2013, at 12:05 PM, Claudio Freire klaussfre...@gmail.com wrote:
On Tue, May 14, 2013 at 12:38 PM, Michael Bayer
mike...@zzzcomputing.com wrote:
storing pickles in the database is an awful idea since your data is now
specific not just to Python but to the current shape of your
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.
Mike
what video is that ?I don't use EAV's too often. If you can point me to
something I can identify what it was.
On May 13, 2013, at 8:22 PM, Lycovian mfwil...@gmail.com wrote:
A few months ago I watched a video conference where Mike demo'd some
optimizations for SQLAlchemy when using EAV
15 matches
Mail list logo