SQLite Memory Database Benefits

Question

I read about the keyword ": memory:" from a SQLite book today, but it only says what it is like to use and the explanations were too short. Therefore, I was looking for additional information here, but could not get specific SQLite information.

• What are the advantages of the ": memory:" mode? (When do I need it?)

• In-memory database performance faster?

• Should I use transactions in an in-memory database?

Answer 1

A SQLite - : . , . , SSD.

. , , .

- , . .

, , , .

, SQLite, , , .

- - , , , . '' . , . , , .

, , , , , ": " , . , ": memory:" , , SQLite .

, , , , , , , .