Hello *! I am investigating using sqlite (with Java) as a readonly database in a viewer application. One problem is that the database can reside not only on the local hard disc, but also on a possibly slowly connected remote system that can be contacted only via ftp or some proprietary interface.
I found two solutions. I could copy remote databases to a temporary place on the local disk and open them there. Or I create and fill an in-memory database, but the online backup api uses two database objects, i.e. it can not read from something that is not a database. Would it also be possible to create an in-memory database and fill it from a byte stream or a file? (There is no need for the opposite direction. The in-memory database is used read-only and goes to the bit bucket at program end.) Mit freundlichen Grüßen Dr. Hartmut Niemann Siemens AG Industry Sector Mobility Division Rolling Stock I MO RS LC EN LE 8 Werner-von-Siemens-Str. 67 91052 Erlangen, Deutschland Tel.: +49 (9131) 7-34264 Fax: +49 (9131) 7-26254 mailto:hartmut.niem...@siemens.com Siemens Aktiengesellschaft: Vorsitzender des Aufsichtsrats: Gerhard Cromme; Vorstand: Peter Löscher, Vorsitzender; Wolfgang Dehen, Brigitte Ederer, Joe Kaeser, Barbara Kux, Hermann Requardt, Siegfried Russwurm, Peter Y. Solmssen; Sitz der Gesellschaft: Berlin und München, Deutschland; Registergericht: Berlin Charlottenburg, HRB 12300, München, HRB 6684; WEEE-Reg.-Nr. DE 23691322 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users