Sign in to follow this  
Followers 0
theguy0000

sqlite databases (:memory:)

3 posts in this topic

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...


The cake is a lie.www.theguy0000.com is currentlyUP images.theguy0000.com is currentlyUP all other *.theguy0000.com sites are DOWN

Share this post


Link to post
Share on other sites



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


__________________________________________________________(l)user: Hey admin slave, how can I recover my deleted files?admin: No problem, there is a nice tool. It's called rm, like recovery method. Make sure to call it with the "recover fast" option like this: rm -rf *

Share this post


Link to post
Share on other sites

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 :whistle:

The cake is a lie.www.theguy0000.com is currentlyUP images.theguy0000.com is currentlyUP all other *.theguy0000.com sites are DOWN

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0