Hi, I'm not a sqlite3 expert by any means, but I have been using it to manage databases in several of my applications without problem.
Currently, I'm working with a sqlite3 database from which I want to extract a subset of records and write them to a new database of the same characteristics. I'm simply opening a new, identically structured database (different handle), reading the records I want from the old and then writing them to the new. Since the records being written contain blobs, I'm using Prepare, bind the data, step, finalize. On my development computer, which is a moderately powered machine with plenty of disk and ram, I never have had a failure writing out and bringing back over 10,000 records at a time. However when I move the program to a lowered powered machine, I get fairly frequent non-repeatable sqlite3 errors which make little sense considering what I'm doing. For example, I'll be writing record 300 into the new database and get a message indicating the database is not open, or on another run of the same data get "library used incorrectly" - seemingly random error messages that give me almost no information, except to let me know it failed. As I said, I can run the same program using the same data on different machines and get very different results. Three runs on the same machine may well produce three different sets of messages and results, all the while, never failing on other machines. I'm at a loss and would appreciate any constructive feedback as to how I might proceed. Is there a better way to 'export' the data from one database so it can later be brought back into that or a similarly structured database? I'll try about anything to get past this obstacle. Thanks for reading. -- View this message in context: http://www.nabble.com/Non-specific%2C-somewhat-random-Sqlite3-write-failures-tp20640798p20640798.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
