Can I save SQLite files to disk and then use them in another SQLite session?

Question

Let's say I were to open SQLite and create a table, then insert data into it and save to disk.

Could I then import this file in another SQLite session and many queries on it?

How transferable is the data format for SQLite? Does it work with MySQL and PostgreSQL?

score 1 · Accepted Answer · answered Jan 06 '17 at 20:16

1

An SQLite database file is a simple file you can connect to it from several instances.

Accessing it from MySQL or PostgreSQL directly is not possible.

But you can surely find scripts that will import the data from one to another

answered Jan 06 '17 at 20:16

Tzook Bar Noy

"But you can surely find scripts that will import the data from one to another" Any examples? – ShanZhengYang Jan 06 '17 at 20:39
An SQLite database file *can* be opened multiple times. – CL. Jan 07 '17 at 07:38
@ShanZhengYang a simple google search will do, ie http://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql – Tzook Bar Noy Jan 07 '17 at 09:57

1 Answers1