Hector, here's the link from official SQLite website about Flags for File opening operations:
http://www.sqlite.org/c3ref/c_open_autoproxy.html Unfortunately I don't know anything (yet!) about SQLite under Java. If you need any other kind of help, let me know. >________________________________ > From: Hector Guilarte <hector...@gmail.com> >To: sqlite-users@sqlite.org >Sent: Thursday, June 28, 2012 4:08 PM >Subject: Re: [sqlite] Load SQLite from InputStream in Java as ReadOnly > >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 > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
