Timmie, I won't guess as to the nature of your application but I can tell you that I have used Pytables as a datastore for a web-based application for over three years.]
In my application, users submit queries to the server which then pulls the data out of an HDF5 file via a Pytables layer. I wrote a domain-specific Python module that uses Pytables as the low-level interface to the data. This works very well without any need for an SQL database. I think for numerically intensive applications this is a very sound approach. In my case, any simultaneous access issues are avoided because the data is read-only. I'm running with mod_python 3.3.1 on Apache 2.2.0 Another possibility is the use of pydap (http://pydap.org). If it weren't for the lack of support for VLARRAYs I would have been very keen to use it. Just some food for thought. -- Elias Collas Stress Methods Group Gulfstream Aerospace Corp Timmie <timmichel...@gmx-topmail.de> wrote on 05/07/2009 04:43:42 AM: > [image removed] > > [Pytables-users] pytables interface to sqlite? > > Timmie > > to: > > pytables-users > > 05/07/2009 04:45 AM > > Hello, > as discussed in thread > http://thread.gmane.org/gmane.comp.python.numeric.general/15961/focus=16216 > pytables is regarded by many scientists using numpy/scipy as preferred way of > efficiently storing large data sets, I am also using it. > > For a new application I would like to bring my calculations to the > web by using > a Python-based webframework. > These normally use either a howegrown database or a DAL > (http://en.wikipedia.org/wiki/Database_abstraction_layer). Most of > these use SQL > based data bases like Postgres or SQLite. > > Therefore, I have some questions: > * Are there already examples for using pytables in a webprocessing > environment? > * Is there a interface between pytables and SQLite? > > I am thinking of something like > > mypytables.convert_to_sql > mypytables.cat.table.insert_into_sqltable > > This is very rough.... > > Thanks in advance, > Timmie > > > ------------------------------------------------------------------------------ > The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your > production scanning environment may not be a perfect world - but thanks to > Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 > Series Scanner you'll get full speed at 300 dpi even with all image > processing features enabled. http://p.sf.net/sfu/kodak-com > _______________________________________________ > Pytables-users mailing list > Pytables-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pytables-users ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ Pytables-users mailing list Pytables-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pytables-users
