theguy0000 Posted November 5, 2006 Posted November 5, 2006 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
/dev/null Posted November 5, 2006 Posted November 5, 2006 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.htmlInternal or temporary databasesCheersKurt __________________________________________________________(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 *
theguy0000 Posted November 5, 2006 Author Posted November 5, 2006 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.htmlInternal or temporary databasesCheersKurtthat's the answer I was looking for, thanks The cake is a lie.www.theguy0000.com is currentlyUP images.theguy0000.com is currentlyUP all other *.theguy0000.com sites are DOWN
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now