Re: [sqlite] Import data into a temporary table

[Dianne Dunn]

Not sure how I got this please remove me

Sent from my iPad

> On Mar 7, 2019, at 4:00 PM, Keith Medcalf  wrote:
> 
> 
> On Thursday, 7 March, 2019 14:45, Eric Tsau  asked:
> 
>> Is it possible to add the option of importing data into a temporary
>> table?
> 
>> Currently you have to create a temporary table first before importing
>> to it, or having to drop the table afterwards.
> 
>> .import dump.csv temp.table
>> or
>> .import dump.csv attach.table
> 
> Apparently not ;)  It would appear that the .import shell command does not 
> know how to create tables in schema's other than "main"
> 
> However, you can create a virtual table in the temp database using the csv 
> extension (since .import only works from the sqlite3 shell) ...
> 
> create virtual table temp.tablename using csv(filename=filename.csv, 
> header=yes);
> 
> The virtual table will be deleted when the connection is closed ... since it 
> is only a temporary thing.  You could then create a duplicate materialized 
> table if you wished (but since you have a table attached to a csv file why 
> would you want to do that?)
> 
> ---
> The fact that there's a Highway to Hell but only a Stairway to Heaven says a 
> lot about anticipated traffic volume.
> 
> 
> 
> 
> 
> ___
> 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] Site search bug - https://sqlite.org/

[Dianne Dunn]

Please remove me ASAP thx

Sent from my iPad

> On Feb 27, 2019, at 5:28 AM, Chris Locke  wrote:
> 
> The link you quote mentions SQLite 3.24 though... ?
> 
> 
> Thanks,
> Chris
> 
>> On Wed, Feb 27, 2019 at 12:44 PM niki  wrote:
>> 
>> This link demonstrates the problem:
>> 
>> https://sqlite.org/search?s=c=3.24
>> 
>> Best regards,
>> 
>> Niki
>> 
>> ___
>> 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
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Size of the SQLite library

[Dianne Dunn]

Hey there do you know how I can get off this list.??

Sent from my iPad

> On Jun 5, 2018, at 3:50 AM, Robert M. Münch  
> wrote:
> 
>> On 31 May 2018, at 19:15, Richard Hipp wrote:
>> 
>> But more recently, mobile phone designers are telling me things like
>> "try to keep the size under 5 megabytes, if you can, please."
>> 
>> Based on those more recent conversations, I'm thinking that we have
>> more headroom that we have had historically, and so I have recently
>> been allowing new features to start creeping into the core.
> 
> Size matters IMO, it’s a sign of good design and less is more WRT errors etc.
> 
> 
>> Size is still important.  But having useful features is important too.
> 
> True, and we all know that most features are not used. Do you have an idea 
> what features are used by ratio? Maybe adding a „report back feature 
> collector“ might be an idea, for those wanting to support the feature 
> selection process.
> 
> 
>> I'm continuing to work to find the right balance between these
>> competing goals.
> 
> Keeping things configurable as it is, is a very good approach, please keep it.
> 
> -- 
> 
> Robert M. Münch, CEO
> M: +41 79 65 11 49 6
> 
> Saphirion AG
> smarter | better | faster
> 
> http://www.saphirion.com
> http://www.nlpp.ch
> ___
> 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] Unable to store 500MB size of row data even after define macro SQLITE_MAX_LENGTH

[Dianne Dunn]

How,do I get off this email list?? What is it for??

Sent from my iPad

> On Dec 8, 2017, at 7:30 AM, Kees Nuyt  wrote:
> 
> On Thu, 7 Dec 2017 23:59:02 -0700 (MST), Durgesh
>  wrote:
> 
>> getting error "QSqlError("18", "Unable to bind parameters", "string or blob
>> too big")" while inserting a row data of size 500MB.
>> 
>> However insertion of 450 MB is successful.
>> 
>> Tried define the macro SQLITE_MAX_LENGTH with value of
>> SQLITE_MAX_LENGTH=20 , larger than 500MB.
>> 
>> pls suggest a way insertion can be done for more than 450 MB of data.
>> 
>> I am using Qt SQL , for interfacing with sqlite db.
> 
> What is the databases page size?
> How big is your page cache? 
> Is cache spill enabled?
> 
> See: 
> PRAGMA schema.cache_size;
> https://sqlite.org/pragma.html#pragma_cache_size
> PRAGMA cache_spill; 
> https://sqlite.org/pragma.html#pragma_cache_spill
> PRAGMA schema.page_size; 
> https://sqlite.org/pragma.html#pragma_page_size
> PRAGMA schema.cache_size;
> 
> Other things to look at:
> PRAGMA schema.journal_size_limit;
> https://sqlite.org/pragma.html#pragma_journal_size_limit
> PRAGMA soft_heap_limit;
> https://sqlite.org/pragma.html#pragma_soft_heap_limit
> 
> HTH
> 
> -- 
> Regards,
> Kees Nuyt
> ___
> 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