[Pytables-users] advice on data modelling

2012-03-03 Thread James Casbon
Hi, I'm new to pytables and I'm having trouble working out how to model data relationships. Now, I realise that pytables is not a relational database, but there are a few ways to go and I want some advice on which is best. I've checked the FAQ and the archives, but if this is answered before

Re: [Pytables-users] advice on data modelling

2012-03-03 Thread Anthony Scopatz
Hi James, It seems that many of your questions if you are approaching this from a SQL perspective may be answered on out Hints for SQL users page (http://www.pytables.org/moin/HintsForSQLUsers). (Yes, we need to migrate this to sphinx.) But in general I would agree with your assessment. (1)

Re: [Pytables-users] dumping filtered data from one table into another

2012-03-03 Thread Francesc Alted
On Mar 3, 2012, at 12:44 PM, Anthony Scopatz wrote: Hello Kale, This is actually pretty easy. You should look at the where() method on tables (http://pytables.github.com/usersguide/libref.html?#tables.Table.where). This will give you an iterator that then you can stick in a new

Re: [Pytables-users] dumping filtered data from one table into another

2012-03-03 Thread Anthony Scopatz
On Sat, Mar 3, 2012 at 4:48 PM, Francesc Alted fal...@pytables.org wrote: On Mar 3, 2012, at 12:44 PM, Anthony Scopatz wrote: Hello Kale, This is actually pretty easy. You should look at the where() method on tables (