Surely the best way to routinely & autocratically copy a set of data from
one database to another SQL technology would be to use a programming
language - like Java, C/C++, C#, or Python for example - so as to copy data
between two different database connections.
The only other way would be to
What's the best way to Insert or Update records from a connected SQL
database to the connected SQLite database?
I don't mean just once, but to do every so often.
Thanks.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
Quan;
If a single process/thread is dumping to the NFS, it shouldn't matter,
especially since the backup routine is one-way, and there are no
'transactions' happening which would cause locking failures. This is more
relevant when you have active transactions fighting with the live database
where
https://www.sqlite.org/faq.html#q5
“But use caution: this locking mechanism might not work correctly if the
database file is kept on an NFS filesystem. This is because fcntl() file
locking is broken on many NFS implementations. You should avoid putting SQLite
database files on NFS if multiple
Hi sqlite experts,
I am currently incorporating the sqlite online backup API (version 3.8.0.2)
into our product. I meet a tricky problem, where the sqlite3_backup_step hangs
at acquiring the BTree’s lock of the destination file.
Specifically, I am backing up in-memory database to NFS disk
5 matches
Mail list logo
