Re: [sqlite] sqlite shell: arrow keys

[Fehmi Noyan ISI]

Depends on your system I think. Here is what is contained in shell.c
readline.h is the thing making all those history and similar things you use in 
your linux command line shell available.

#ifdef HAVE_EDITLINE
# include 
#endif
#if defined(HAVE_READLINE) && HAVE_READLINE==1
# include 
# include 
#endif





 From: Roman Fleysher 
To: General Discussion of SQLite Database  
Sent: Friday, May 17, 2013 11:49 AM
Subject: [sqlite] sqlite shell: arrow keys
 

Dear SQLiters,

I am new to SQLite and learning it (and SQL) using shell. It would make life 
easier if arrow keys on keyboard could be used to scroll through command 
history and along command for editing. Is there a way to enable this?

Thank you,

Roman
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite shell: arrow keys

[Roman Fleysher]

Dear SQLiters,

I am new to SQLite and learning it (and SQL) using shell. It would make life 
easier if arrow keys on keyboard could be used to scroll through command 
history and along command for editing. Is there a way to enable this?

Thank you,

Roman
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite: Failing APTCA Check

[Joe Mistachkin]

DevTeam wrote:
> 
> Next I downloaded and ran the binscope.exe utility against just the 
> System.Data.Sqlite.dll file to isolate the test to just this file and 
> received the same result - Failed checks - the assembly has 
> AllowPartiallyTrustedCallersAttribute (APTCA).
> 

The use of this attribute by System.Data.SQLite appears to date back to
at least version 1.0.32.0, released in 2006.

I'm not aware of the original intent when this attribute was added.

Furthermore, this is the first time I've even heard it mentioned.

> 
> I would like to be able to better understand and eliminate this 
> warning/failure if possible, but not sure how best to proceed.  Any 
> assistance or advice would be greatly appreciated.  Thanks in advance. 
> 

The warning deals with assemblies that are not "fully trusted" being able
to use System.Data.SQLite.

In theory, this could pose a problem:  If you actually intend to use
partially trusted assemblies -OR- if you intend to install the
System.Data.SQLite assemblies into a shared location on the machine,
such as the GAC.

Perhaps the attribute should be removed from System.Data.SQLite?  I'm not
sure.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

[Paul Sanderson]

That worked thanks Igor.


On 16 May 2013 15:33, Paul Sanderson  wrote:

> Rob yes thats correct
>
> Igor - thanks I'll give that a go
>
>
>
> On 16 May 2013 14:51, Rob Richardson  wrote:
>
>> First idea: include a subject line.
>>
>> I'm not 100% clear on your message.  You said:
>> " For those entries in table1 where there is a null in t2..."
>> I'm guessing you wanted to say:
>> " For those entries in table1 where there is a null in t1..."
>>
>> Is that right?
>>
>> RobR
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
>
> --
> Paul
> www.sandersonforensics.com
> skype: r3scue193
> twitter: @sandersonforens
> Tel +44 (0)1326 572786
> http://sandersonforensics.com/forum/content.php?168-Reconnoitre - VSC
> processing made easy
>



-- 
Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?168-Reconnoitre - VSC
processing made easy
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite: Failing APTCA Check

[DevTeam]

Hi all,

Was wondering if anyone can give me some insight or advice on the how to 
proceed with the following situation:


I'm writing a 32 bit Windows 8 desktop application in C#, .net framework 
4.5, using System.Data.Sqlite version 1.0.85.  I'm using the Nuget 
package System.Data.Sqlite.x86 in Visual Studio 2012  The program 
compiles and runs fine.


I ran the Windows App Certification Kit version 2.2 against my 
installation project.  Under the windows security features test portion 
of the results there is the following warning information:


The binary analyzer test detected the following errors: 
System.Data.Sqlite.dll has failed the AptcaCheck check.  The message 
goes on to state that if the app doesn't use the available Windows 
protections, it can increase the customer's computer to malware.


Next I downloaded and ran the binscope.exe utility against just the 
System.Data.Sqlite.dll file to isolate the test to just this file and 
received the same result - Failed checks - the assembly has 
AllowPartiallyTrustedCallersAttribute (APTCA).


I would like to be able to better understand and eliminate this 
warning/failure if possible, but not sure how best to proceed.  Any 
assistance or advice would be greatly appreciated.  Thanks in advance.


Mike
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

[Paul Sanderson]

Rob yes thats correct

Igor - thanks I'll give that a go



On 16 May 2013 14:51, Rob Richardson  wrote:

> First idea: include a subject line.
>
> I'm not 100% clear on your message.  You said:
> " For those entries in table1 where there is a null in t2..."
> I'm guessing you wanted to say:
> " For those entries in table1 where there is a null in t1..."
>
> Is that right?
>
> RobR
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?168-Reconnoitre - VSC
processing made easy
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

[Rob Richardson]

First idea: include a subject line.

I'm not 100% clear on your message.  You said:
" For those entries in table1 where there is a null in t2..."
I'm guessing you wanted to say:
" For those entries in table1 where there is a null in t1..."

Is that right?

RobR
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] (no subject)

[Igor Tandetnik]

On 5/16/2013 9:29 AM, Paul Sanderson wrote:

I have two tables of the form

create table1 (id1 int, t1 text)
create table2 (id2 int unique, t2 text)

For those entries in table1 where there is a null in t2 I want to copy the
corresponding entry from table2


update table1 set t1=(select t2 from table2 where id2=id1)
where t1 is null;

--
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] (no subject)

[Paul Sanderson]

I have two tables of the form

create table1 (id1 int, t1 text)
create table2 (id2 int unique, t2 text)

the data in table 1 is such that some values for t1 are NULL
ID1 can contain duplicates

ID2 is unique and for every instance of ID1 in table1 there will be a
corresponding ID2 entry in table2
t2 in table 2 is always populated with a string

For those entries in table1 where there is a null in t2 I want to copy the
corresponding entry from table2


any ideas?

thx.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Missing optimization with id BETWEEN xxx AND xxx?

[Hick Gunter]

If you replace "between x and x" (which is just a very inefficient method of 
testing for equality) with "= x" the query reverts to the same plan as "IN 
(x,...)" with the small difference that the constant values are assigned to 
registers first.

-Ursprüngliche Nachricht-
Von: Dominique Pellé [mailto:dominique.pe...@gmail.com]
Gesendet: Mittwoch, 15. Mai 2013 22:28
An: General Discussion of SQLite Database
Betreff: [sqlite] Missing optimization with id BETWEEN xxx AND xxx?

Hi

The SQL script at http://dominique.pelle.free.fr/query-between.sql
shows 2 SELECT queries:

* Select query #1 takes 20.2 sec  (slow!)
* Select query #2 takes 0.004 sec  (fast!)

Yet the 2 queries are equivalent.

Here is how to download and run the script:

=
$ wget http://dominique.pelle.free.fr/query-between.sql
$ rm -f foo.sqlite ; sqlite3 foo.sqlite < query-between.sql
--- Populating table...
--- Query #1: measure time to select with 150 BETWEEN clauses with equal 
min/max -> SLOW!
0
CPU Time: user 20.237265 sys 0.036003 <--- SLOW!

--- Query #2: measure time to select using: IN (...150 values...)  --> 
equivalent and FAST!
0
CPU Time: user 0.004001 sys 0.00 <--- FAST!
=


If I add "EXPLAIN QUERY PLAN" in front of each SELECT query, I see:

--- Query #1: measure time to select with 150 BETWEEN clauses with equal 
min/max -> SLOW!
0|0|0|SCAN TABLE t (~50 rows)

--- Query #2: measure time to select using: IN (...150 values...)  --> 
equivalent and FAST!
0|0|0|SEARCH TABLE t USING INTEGER PRIMARY KEY (rowid=?) (~150 rows)
0|0|0|EXECUTE LIST SUBQUERY 1


Shouldn't SQLite be able to use the index (implicit index since 'id' is a 
PRIMARY KEY) when using BETWEEN clauses?

I understand that using...
 "WHERE id BETWEEN xxx AND xxx OR id BETWEEN yyy AND yyy"
... is a bit silly.  It's of course simpler to write the equivalent...
  "WHERE id IN (xxx, yyy)"

However, I found this query which was automatically generated.  Not all ranges 
have equal min/max but often they do.  It was slow.  Replacing all the equal 
ranges using "OR id IN (xxx, yyy...)" resulted in a big speed up.

Can't the SQLite optimizer do such optimization automatically?

I'm using SQLite 3.7.16.2 2013-04-12 11:52:43 on Linux x86_64.

Regards
Dominique
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


--
 Gunter Hick
Software Engineer
Scientific Games International GmbH
Klitschgasse 2 – 4, A - 1130 Vienna, Austria
FN 157284 a, HG Wien
Tel: +43 1 80100 0
E-Mail: h...@scigames.at

This e-mail is confidential and may well also be legally privileged. If you 
have received it in error, you are on notice as to its status and accordingly 
please notify us immediately by reply e-mail and then delete this message from 
your system. Please do not copy it or use it for any purposes, or disclose its 
contents to any person as to do so could be a breach of confidence. Thank you 
for your cooperation.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users