SQLite Forum

Create Sqlite file then send it remotely
Login

Create Sqlite file then send it remotely

(1) By mickae1 on 2020-12-04 08:36:11 [source]

Hi,

I would like to check if I'm using sqlite3 correctly on windows.

We are creating a large file sqlite with the sqlite3 command. ( 110MB aproximately)

the sql file contain:

PRAGMA synchronous = OFF; PRAGMA journal_mode = OFF; BEGIN;........COMMIT;

and to import te file in the db i'm using the command: sqlite3.exe data.db < request.sql

At the end of the command, I'm sending the file with libcurl. 

I would like to know if this method is safe ? I would like to be sure the file I'm sending is not opened by sqlite3. Normally, it should be safe, because the program sqlite3.exe is closed.

(2) By Richard Hipp (drh) on 2020-12-04 19:40:59 in reply to 1 [link] [source]

Probably it is safe. Lots of people do stuff like that. But the answer also depends to some extent on what you mean by "safe". Can you elaborate on what you want to be sure does not happen?