sqlite databases (:memory:)

[theguy0000]

I don't get what the :memory: sqlite database is for...does that mean that it's only temporary, and is deleted when the database is closed? if so, why do that instead of just creating variables?

I don't like the examples in the help file for the sqlite functions, and more info about the parameters should be provided...

[/dev/null]

I don't get what the :memory: sqlite database is for...does that mean that it's only temporary, and is deleted when the database is closed?

In memory, because of speed.

if so, why do that instead of just creating variables?

well, can you do a SELECT, JOIN or ORDER BY on variables, without reinventing the wheel?

http://www.sqlite.org/whentouse.html

Internal or temporary databases

Cheers

Kurt

[theguy0000]

In memory, because of speed.

well, can you do a SELECT, JOIN or ORDER BY on variables, without reinventing the wheel?

http://www.sqlite.org/whentouse.html

Internal or temporary databases

Cheers

Kurt

that's the answer I was looking for, thanks