Re: [Pytables-users] Main differences between PyTables and Relational

2012-04-26 Thread Alvaro Tejero Cantero
Hi Umit, Thanks for commenting. I do think that scientific/hierarchical file formats like HDF5 and > RDBMS system have their specific use cases and I don't think it makes > sense to replace one with the other. > Right. But data modeling is notoriously difficult to get right when complex and chan

Re: [Pytables-users] Main differences between PyTables and Relational

2012-04-26 Thread Alvaro Tejero Cantero
Hi Anthony, On Wed, Apr 25, 2012 at 23:19, Anthony Scopatz wrote: > Hello Alvaro, > > Thanks for writing this up. I think this would go nicely in our docs if > you are willing to let us add it ;). > Of course! Let us polish it together - maybe you want to add it then to the existing document a

Re: [Pytables-users] Performance of tables vs. arrays (out vs in core?)

2012-04-26 Thread Alvaro Tejero Cantero
Hi, I tried again, also with different chunklens and couldn't reproduce it. Unfortunately the session where I had this result was killed by a power outage and the history buffer does not go as far back, so I can't find out what exactly triggered it. -á. On Thu, Apr 26, 2012 at 04:10, Francesc

Re: [Pytables-users] Table.where and conditions across tables

2012-04-26 Thread Alvaro Tejero Cantero
On Thu, Apr 26, 2012 at 04:07, Francesc Alted wrote: > On 4/25/12 7:05 AM, Alvaro Tejero Cantero wrote: >> Hi, a minor update on this thread >> * a bool array of 10**8 elements with True in two separate slices of length 10**6 each compresses by ~350. Using .wheretrue to obtain indic

Re: [Pytables-users] Main differences between PyTables and Relational

2012-04-26 Thread Ümit Seren
Good points. Just some additional comments: I do think that scientific/hierarchical file formats like HDF5 and RDBMS system have their specific use cases and I don't think it makes sense to replace one with the other. I do also think that you shouldn't try to apply RDBMS principles to HDF5 like fo