Re: [Pytables-users] SQLite Virtual Tables

2012-04-16 Thread Alvaro Tejero Cantero
I'm continuing this thread on the dev list. -á. On Fri, Apr 13, 2012 at 21:17, Anthony Scopatz wrote: > > On Fri, Apr 13, 2012 at 12:30 PM, Alvaro Tejero Cantero > wrote: >> >> Hi Anthony, >> >> >> >> >> How does hierarchical help here? do you create a 'singer_name'/song >> >> table? or a 'ge

Re: [Pytables-users] SQLite Virtual Tables

2012-04-13 Thread Anthony Scopatz
On Fri, Apr 13, 2012 at 12:30 PM, Alvaro Tejero Cantero wrote: > Hi Anthony, > > > > >> How does hierarchical help here? do you create a 'singer_name'/song > >> table? or a 'genre name'/song ?. Most of the time the physical layout > >> in the form of a hierarchy is just an annoyance. > > > > I hav

Re: [Pytables-users] SQLite Virtual Tables

2012-04-13 Thread Alvaro Tejero Cantero
Hi Anthony, >> How does hierarchical help here? do you create a 'singer_name'/song >> table? or a 'genre name'/song ?. Most of the time the physical layout >> in the form of a hierarchy is just an annoyance. > > I have to say that I disagree.  The hierarchical features make it so that > the data

Re: [Pytables-users] SQLite Virtual Tables

2012-04-13 Thread Anthony Scopatz
On Fri, Apr 13, 2012 at 6:41 AM, Alvaro Tejero Cantero wrote: > Hi Anthony, > > > I can see how the virtual table interface could be made to work with > > PyTables, > > but I guess I don't understand why you would want to. It seems like in > this > > case you are querying using SQL rather than th

Re: [Pytables-users] SQLite Virtual Tables

2012-04-13 Thread Alvaro Tejero Cantero
Hi Anthony, > I can see how the virtual table interface could be made to work with > PyTables, > but I guess I don't understand why you would want to.  It seems like in this > case you are querying using SQL rather than the more expressive Python. Yes, you'd be querying using SQL. SQL is a docume

Re: [Pytables-users] SQLite Virtual Tables

2012-04-12 Thread Anthony Scopatz
Hello Alvaro, I can see how the virtual table interface could be made to work with PyTables, but I guess I don't understand why you would want to. It seems like in this case you are querying using SQL rather than the more expressive Python. Moreover, you'd be sacrificing all of the 'H' in HDF5 fe

[Pytables-users] SQLite Virtual Tables

2012-04-12 Thread Alvaro Tejero Cantero
Hi, The topic of introducing some kind of relational management in PyTables comes up with certain frequency. Would it be possible to combine the virtues of RDBMS and hdf5's speed via a mechanism such as SQLite Virtual Tables? http://www.sqlite.org/vtab.html I wonder if the required x* functions