Hi Timmie, A Thursday 07 May 2009, Timmie escrigué: > 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....
Well, I've got the idea, and I suppose that a handful of people had it before too :) I'm sorry, but I don't think that a full SQL bridge for PyTables would be feasible (without too much work at least). In fact, exposing a SQL-like interface has never been (nor likely is going to be) a goal for PyTables. As the pytables.org home page says, PyTables is more designed to be a companion of a full-fledged SQL, relational database -- a combination that can have many advantages indeed. In this sense, I've always thought that a powerful database abstraction layer could be done around PyTables *and* a relational database. In such an abstraction, one could create special entities that are meant for performance (or to use compression or other PyTables strenghts), and these would be implemented with PyTables as backend. Also, these entities could be linked with the traditional relational database so as to provide a relatively seemless integration between both. While the above approach is definitely much less work than providing a full SQL interface to PyTables, to my knowledge nobody has stepped in yet. But it is definitely an interesting venue, IMO. Cheers, -- Francesc Alted "One would expect people to feel threatened by the 'giant brains or machines that think'. In fact, the frightening computer becomes less frightening if it is used only to simulate a familiar noncomputer." -- Edsger W. Dykstra "On the cruelty of really teaching computer science" ------------------------------------------------------------------------------ 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
