replied to this question in the email I have just sent :) On Tue, 9 Dec 2008, Daniel Russel wrote:
Why use SQL over python or C++ logic? On Dec 9, 2008, at 9:15 AM, Keren Lasker wrote:Agreed, but it might be one of those things (like storing the whole model, restraints and all) where there is unlikely to be a general solution that adds any benefit as the general case is very complex and the ad hoc solution is quite simple.we do the same - but this is an ad hoc solution.Again, I think having it act on a whole model is a really bad idea (the IMP equivalent of using global variables :-)It should not be part of Model I think but an external IndexModel class maybe or a IndexDecorator.Why not just use python or C++ rather than add another language to learn? There are a few operations which are more concise in SQL, but I don't know that we want to support them or that they make sense in our case (where would presumably have to return whole particles).I suggested SQL because your query can be complex containing often more than one attribute.Ben - you will need it in IMP.Atom - have you already started working on that?How come? I think I am missing some use case :-)On Tue, 9 Dec 2008, Dina Schneidman wrote:Hi, I need this too (surprisingly). Usually I do it with mapping between the particle and the attribute. It is simple. however it is unclear where should we put such a mapping. Putting it in a model could be the best, however not everyone needs it. So it means somewhere else or extending the Model to ProteinModel? Dina P.S. skype me, we can talk about it On Tue, Dec 9, 2008 at 7:03 AM, Keren Lasker <kerenl@salilab.org> wrote:hi all, Frido and I find ourselves many times need to query particles based on attribute values.Few such examples: a protein with a specific name, particles with a specificresidue range. I think that it would be very useful to have something similar to SQL queries on the particles DB.Bret might had something similar implemented - but it is probably obsolete.IMP.Atom will probably need such functionality as well. has anyone took a look at that before ? thank you, Keren. _______________________________________________ IMP-dev mailing list IMP-dev@salilab.org https://salilab.org/mailman/listinfo/imp-dev_______________________________________________ IMP-dev mailing list IMP-dev@salilab.org https://salilab.org/mailman/listinfo/imp-dev_______________________________________________ IMP-dev mailing list IMP-dev@salilab.org https://salilab.org/mailman/listinfo/imp-dev_______________________________________________ IMP-dev mailing list IMP-dev@salilab.org https://salilab.org/mailman/listinfo/imp-dev