Re: [sqlite] Is the table created by "create temp table" in the database file or in memory?

[sub sk79]

Also these links which maybe easier to grok:
https://sqlite.org/tempfiles.html
 (sections  2.6 and 3)
https://sqlite.org/tempfiles.html#tempstore

-Neal

On Sat, Feb 1, 2020 at 10:09 AM J. King  wrote:

> On February 1, 2020 10:03:28 a.m. EST, Peng Yu 
> wrote:
> >But it doesn't explain what is "the temp database". Is it an actual
> >database file? Or it is just a in-memory database?
>
>
> It depends. See  for
> details ans links to further reading.
> --
> J. King
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is the table created by "create temp table" in the database file or in memory?

[J. King]

On February 1, 2020 10:03:28 a.m. EST, Peng Yu  wrote:
>But it doesn't explain what is "the temp database". Is it an actual
>database file? Or it is just a in-memory database?


It depends. See  for details 
ans links to further reading. 
-- 
J. King
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is the table created by "create temp table" in the database file or in memory?

[Peng Yu]

But it doesn't explain what is "the temp database". Is it an actual
database file? Or it is just a in-memory database?

On 2/1/20, Simon Slavin  wrote:
> On 1 Feb 2020, at 1:30pm, Peng Yu  wrote:
>
>> https://www.sqlite.org/lang_createtable.html
>>
>> "The database in which the new table is created. Tables may be created in
>> the main database, the temp database, or in any attached database."
>>
>> It is not clear to me in the doc. If a table is created by "create
>> temp table", is it temporarily a database file but later got deleted
>> upon termination of the sqlite3 session? Or it is in memory? Thanks.
>
> Further down the same page:
>
> " If the "TEMP" or "TEMPORARY" keyword occurs between the "CREATE" and
> "TABLE" then the new table is created in the temp database. "
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
Regards,
Peng
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is the table created by "create temp table" in the database file or in memory?

[Simon Slavin]

On 1 Feb 2020, at 1:30pm, Peng Yu  wrote:

> https://www.sqlite.org/lang_createtable.html
> 
> "The database in which the new table is created. Tables may be created in the 
> main database, the temp database, or in any attached database."
> 
> It is not clear to me in the doc. If a table is created by "create
> temp table", is it temporarily a database file but later got deleted
> upon termination of the sqlite3 session? Or it is in memory? Thanks.

Further down the same page:

" If the "TEMP" or "TEMPORARY" keyword occurs between the "CREATE" and "TABLE" 
then the new table is created in the temp database. "
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Is the table created by "create temp table" in the database file or in memory?

[Peng Yu]

Hi,

https://www.sqlite.org/lang_createtable.html

"The database in which the new table is created. Tables may be created
in the main database, the temp database, or in any attached database."

It is not clear to me in the doc. If a table is created by "create
temp table", is it temporarily a database file but later got deleted
upon termination of the sqlite3 session? Or it is in memory? Thanks.

-- 
Regards,
Peng
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users