Google AppEngine: Use SQLite file uploaded by user
I want to create this web "service":
HTTP REQUEST: User uploads a SQLite file
(REQUEST PROCESSING) the app reads the SQLite and perform a basic operation
HTTP RESPONSE: Stream the SQLite file back, as a download for the user.
Is it possible with Google AppEngine?
(feel free to suggest different method)If not, any fr开发者_如何学Cee hosting service where that would be possible? It is for users of an open source software, no money for hosting.
App Engine has no built-in server-side support for SQLite. I'm not aware of pure Python or Java libraries to read and write SQLite files.
It is possible but requires a bit of development:
- For in/out streaming re-use this app engine project: https://github.com/nicolas-raoul/transdeck
- Implement this small SQLJet enhancement: http://code.google.com/p/sqljet/issues/detail?id=159
- Call SQLJet from the "transdeck" servlet
精彩评论