Re: [Pytables-users] SQLite Virtual Tables

[Anthony S. <sc...@gm...>]

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 features to obtain
this.

Also, my sense is that there would be a fair bit of overhead in this
interface
layer, which might not get you the speed boost you desire.  I could be wrong
about this though.

If I saw a proof-of-concept implementation, I may grok better the purpose.
Do you have any code to share?

Be Well
Anthony

On Thu, Apr 12, 2012 at 11:03 AM, Alvaro Tejero Cantero <al...@mi...>wrote:

> 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 could be written for PyTables,
> or if it being in Python is an obstacle to this kind of interfacing
> with SQLite.
>
> Something like that would be a truly powerful solution in use cases
> that don't require concurrency.
>
> Cheers,
>
> -á.
>
>
> ------------------------------------------------------------------------------
> For Developers, A Lot Can Happen In A Second.
> Boundary is the first to Know...and Tell You.
> Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
> http://p.sf.net/sfu/Boundary-d2dvs2
> _______________________________________________
> Pytables-users mailing list
> Pyt...@li...
> https://lists.sourceforge.net/lists/listinfo/pytables-users
>