That doesn't solve either of my problems. I'm not trying to use SQLite instead of DataStore, I'm trying to use it instead of static CSV files. To paraphrase the SQLite documentation: "don't think of SQLite as a replacement for MySQL, think of it as a replacement for fopen()". I want a lightweight structured file format for *static* data. Serving static data out of DataStore is a waste of resources.
Secondly, DataStore doesn't solve the complex query problem. It can't do "JOIN", "GROUP BY", or any kind of nested queries. Lastly, a memory-only SQLite instance is a very useful abstraction for doing data transformations even when you're not worried about persistence at all. Even if we could simply load the SQLite module for memory-only databases that would be a step in the right direction, though storing my static data in SQLite format would be ideal. On Jul 18, 10:25 am, Felipe Teixeira <[email protected]> wrote: > You need use your SQLite in DataStore , use the api objectify its very > simple. > > bye > > 2011/7/18 Jim Cipar <[email protected]> > > > > > > > > > > > I'm trying to write an app that has to handle somewhat complex queries > > to a never (or very rarely) changing data set. Right now I have a > > static .csv file that my app reads, parses, and returns results from. > > This solution isn't really ideal though, I would much rather have a > > read-only SQLite file that the app can read, so that I can make use of > > all of the good things that come with using a database (indices, > > complex queries, performance ...). > > > It seems like App Engine refuses to load the sqlite3 python module, > > even if I don't try to open a file for writing. Is there some > > workaround to get read-only SQLite access in App Engine? > > > I can't imagine I'm the first person who's wanted to do this, but > > everything I've found has been about people using SQLite as a local > > store for the App Engine development kit, or wanting to use SQLite as > > a read-write datastore. > > > -- > > You received this message because you are subscribed to the Google Groups > > "Google App Engine" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group at > >http://groups.google.com/group/google-appengine?hl=en. > > -- > *Felipe Teixeira* > *Desenvolvedor Java > * > IPNET Soluções > Tel.: 55 21 3553 2717 / 21-7805-6867 > Rua Visconde de Inhaúma, 134, Sala 615 > Centro - RJ - CEP: 20091-007 > *http://www.ipnetsolucoes.com.br*** > > ** > * > * -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
