SQLite Forum

Temp database
Login
> 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.