SQLite Forum

Temp database
> what is the string for opening/attaching a temporary database?

<s>sqlite doesn't, to the best of my knowledge, have any APIs for managing temp databases. It has temp tables:</s>

create temp table x ...;

Edit: that said, try `""` instead of `":memory:"`. IIRC that works like memory but uses a temp database.