> However, I would very much like a "bulk insert" - call to > sqlite (Oracle > OCI does this, for example), where i can put many (thousands) > of records > into the database with one call. Is there any chance of > something like > this ever to be added to sqlite?
I can't speak authoritatively, but I don't see what the impact would be. Adding rows in bulk, with other databases, is mostly about transferring the data more optimally and/or avoiding the SQL processing engine. Both of those problems have already been solved by SQLite - you can't get any more optimal than intra-process communication, and given a prepared INSERT statement that is executed repeatedly, there is no SQL processing engine involved. It might be convenient to be able to provide arrays of inputs to a prepared statement, but the only thing you'd gain performance-wise is eliminating the function call overhead of all calls past the first, so even that doesn't provide any serious benefit. -Tom
