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

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

2012-04-25 Thread Anthony Scopatz
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 ;). My one comment is that in your NOTE you say that "* SQL tables do not play well with Numpy containers. *" I think that this would be better phrased as saying that when conv

[Pytables-users] Main differences between PyTables and Relational

2012-04-25 Thread Alvaro Tejero Cantero
* Hello list, The relational model has a strong foundation and I have spent a few hours thinking about what in PyTables is structurally different from it. Here are my thoughts. I would be delighted if you could add/comment/correct on these ideas. This could eventually help people with a relational/