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
