Hello? I'm starting to feel hopeless, No luck in StackOverflow and no luck here :-(...
Well, i guess it just can't be done. On Wed, Jun 27, 2012 at 10:13 AM, Hector Guilarte <hector...@gmail.com>wrote: > Hello everyone, > > I'm new to SQLite as well as to this list. I'm writing because I was > planning on using SQLite for a personal -but public- project that I wanted > to make available through Google App Engine. It is basically a SQLite to > CSV converter and a SQLite to VCard converter. In other words, I have an > Address Book in a SQLite database and I wanted to export it to a well-known > format for importing it to some other places, as CSV and as VCard. > > I already placed my question in StackOverflow.com last friday with no > luck, it has only been seen 21 times and the only answer I received was not > helpfull since it was telling me somehing like "first use something like > what you are trying to develop yourself and then use yours with their > output" (nahh, I'm kidding, but the real answer is not far from that and it > can be seen here: > http://stackoverflow.com/questions/11155537/load-sqlite-from-inputstream-in-java-as-readonly > ) > > If somebody has an answer, even if it is "It's not possible at all, so > drop it" and is a stackoverflow user, feel free to go ahead and answer over > there to earn the points, but please post your answer here as well. Now my > question as I wrote it in StackOverflow: > > I have an App which receives a SQLite database to read some data and > export it as an CSV. I'm trying to upload it to Google App Engine but I > faced a huge problem which I think makes it impossible to use the GAE for > this app. > > The problem is that since on the GAE I can't write to the FileSystem, I > can't open the JDBC Connection to the SQLite file and therefore I can't > read the data to convert to CSV. I've been looking for other options such > as Google Cloud Storage, but I don't want to use my only "free trial" of it > on this application, and actually I don't want to have to pay ever for this > app after the Free Trial ends, so this is not an option. > > After a lot of research, my only guess is that I might be able to load the > database straight from the InputStream as I received it from the upload > form I'm using to get it, however, this is a 100% lucky guess and I've not > been able to find anything about this approach online, but I just don't > want to believe it can't be done with any of the existing JDBC libraries to > SQLite and I'm hoping somebody here will tell me how to do it. > > If the InputStream approach is not possible, but you know some other way > to open a SQLite DB in GAE to READ ONLY, and then dispose it, feel free to > comment as well... > > If there is another option like "don't use JDBC, use a socket connection > with a pipe to open the connection with the InputStream", I'd also like to > hear that, it does not HAVE to be done with JDBC. > > Thanks a lot, > > Héctor Guilarte > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
