Re: [sqlite] sqlite3_analyzer source code

[Kees Nuyt]

On Tue, 15 Apr 2014 22:34:40 +0200, Marco Bambini 
wrote:

> If I remember correctly, sqlite3_analyzer is a python script...
> I am not able to find its source code since in the download
> page there is a binary app only.
>
> Any help?

The sources are available in the online fossil repository, 

http://www.sqlite.org/cgi/src/doc/trunk/README.md

The Makefile will tell you what sqlite3_analyzer is made of.

-- 
Groet, Cordialement, Pozdrawiam, Regards,

Kees Nuyt

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

Re: [sqlite] sqlite3_analyzer source code

[Richard Hipp]

On Tue, Apr 15, 2014 at 4:34 PM, Marco Bambini  wrote:

> If I remember correctly, sqlite3_analyzer is a python script... I am not
> able to find its source code since in the download page there is a binary
> app only.
>

It is a TCL script.  The source code is here:

 http://www.sqlite.org/src/artifact/8e50b217c56a6a08

In order to run, it requires a TCL extension written in C:

http://www.sqlite.org/src/artifact/9898687a6c2beca7

You can type "make sqlite3_analyzer"  or "nmake -f makefile.msc
sqlite3_analyzer.exe" in order to build the program.

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

[sqlite] sqlite3_analyzer source code

[Marco Bambini]

If I remember correctly, sqlite3_analyzer is a python script... I am not able 
to find its source code since in the download page there is a binary app only.

Any help?
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
http://instagram.com/sqlabs



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

Re: [sqlite] Database access slowness on specific WinCE devices

[Mohit Sindhwani]

On 15/4/2014 3:36 PM, Joe Mistachkin wrote:


It might be useful to measure the processor and storage performance of
the device, using some external benchmarking tool, and then compare it
against the other devices you have.


If the disk performance is indeed slower on this particular device, 
maybe, another question to ask is:
Is there a way to make SQLite3 less disk-bound?  What are the sorts of 
things that could help?


1. I guess the obvious one would be to increase the cache size.
2. I think the query pattern would determine if increasing the page size 
is a good idea... a larger page size will certainly hold more records, 
but if your reading pattern jumps all around the database, then reading 
in an 8KB page for every thing instead of a 4KB page would likely slow 
down things as well.


Any other thoughts?

Best Regards,
Mohit.


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

Re: [sqlite] cannot set connection while a datareader is active

[Stefano Ravagni]

Hello Joe, i'm here for try but i cannot find how to test _activeReader
method as you say...could you tell me how to test it?


2014-04-15 10:19 GMT+02:00 rava :

> How could i do this? By debugging and adding a watch to the object?
>
>
>
> Joe Mistachkin  ha scritto:
>
>
>
> Stefano Ravagni wrote:
> >
> > So what have i do? Need to see others setting or state?
> >
>
> It would be useful to try and examine the internal state of the
> SQLiteCommand and see if the _activeReader member is valid.  If
> it is valid, see if it actually refers to the data reader you
> are using.
>
> --
> Joe Mistachkin
>
> ___
> 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] Bug report: .import csv (wiki) documentation error (sqlite 3.7.17)

[Holger Joukl]

Hi,

while sqlite documentation on .import is generally a bit sparse (or I
haven't found it),
searching for it prominently yields this wiki page:

http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles

The information given there seems out of date and partly incorrect.
Contrary to

"[...]
Unfortunately, not all CSV files are simple. For instance, the CSV line
  "Last, First", 1234

means two columns in Excel (a name and an integer), but three columns with
embedded quote marks in SQLite.
Be wary when trying to import CSV files.
Some problems you would encounter importing CSV files using the SQLite
shell:
 - Fields with commas in them. The SQLite shell will always split fields on
the separator character,
no matter what comes before or after it. Quotes or backslashes won't escape
them.
 - Quoted fields. The SQLite shell will interpret quotes literally, so the
imported database will
have embedded quote marks in them.

[...]"

.import nowadays *does* interpret double quotes:

$ cat data.csv
field1  field2  field3
text1   text"2  text3
1   2   3
0 $ sqlite3
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table data (col1, col2, col3);
sqlite> .separator "\t"
sqlite> .import data.csv data
Error: data.csv line 4: expected 3 columns of data but found 2
sqlite> select * from data;

Looks like the new behaviour has been introduced here:

http://www.sqlite.org/src/info/93aa17d866

Note that I don't know how "official" the wiki documentation is nor how to
fix
it myself (?), so this is a try to enhance documentation on csv import a
bit wrt
something I've run into (and wondered).

Best regards,
Holger

Landesbank Baden-Wuerttemberg
Anstalt des oeffentlichen Rechts
Hauptsitze: Stuttgart, Karlsruhe, Mannheim, Mainz
HRA 12704
Amtsgericht Stuttgart

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

Re: [sqlite] Problems with executereader in System.Data.SQLite

[Simon Slavin]

On 15 Apr 2014, at 10:14am, Ralf  wrote:

> Yes. Everything is Working as expected when i access the DB with any Browser. 
> It is just the powershell environment

Then the chances are that the problem is with PowerShell, not SQLite.

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

Re: [sqlite] Problems with executereader in System.Data.SQLite

[Ralf]

On 15. April 2014 09:46:43 MESZ, Joe Mistachkin  wrote:
>
>Ralf wrote:
>>
>> I just tried... No change :-(
>>
>
>Have you looked at the contents of the database using the SQLite
>command
>line tool for Windows?
>
>   https://www.sqlite.org/2014/sqlite-shell-win32-x86-3080403.zip
>
>--
>Joe Mistachkin
>
>___
>sqlite-users mailing list
>sqlite-users@sqlite.org
>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Yes. Everything is Working as expected when i access the DB with any Browser. 
It is just the powershell environment
-- 
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] cannot set connection while a datareader is active

[rava]

How could i do this? By debugging and adding a watch to the object?

Joe Mistachkin  ha scritto:

>
>Stefano Ravagni wrote:
>>
>> So what have i do? Need to see others setting or state?
>> 
>
>It would be useful to try and examine the internal state of the
>SQLiteCommand and see if the _activeReader member is valid.  If
>it is valid, see if it actually refers to the data reader you
>are using.
>
>--
>Joe Mistachkin
>
>___
>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

Re: [sqlite] Problems with executereader in System.Data.SQLite

[Joe Mistachkin]

Ralf wrote:
>
> I just tried... No change :-(
>

Have you looked at the contents of the database using the SQLite command
line tool for Windows?

https://www.sqlite.org/2014/sqlite-shell-win32-x86-3080403.zip

--
Joe Mistachkin

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

Re: [sqlite] cannot set connection while a datareader is active

[Joe Mistachkin]

Stefano Ravagni wrote:
>
> So what have i do? Need to see others setting or state?
> 

It would be useful to try and examine the internal state of the
SQLiteCommand and see if the _activeReader member is valid.  If
it is valid, see if it actually refers to the data reader you
are using.

--
Joe Mistachkin

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

Re: [sqlite] Database access slowness on specific WinCE devices

[Joe Mistachkin]

Phua Si Jie wrote:
>
> The performance degrades only happen on that kind of WinCE devices.
>
> Any clue for further investigation?
>
 
It might be useful to measure the processor and storage performance of
the device, using some external benchmarking tool, and then compare it
against the other devices you have.

--
Joe Mistachkin

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

Re: [sqlite] Problems with executereader in System.Data.SQLite

[Ralf]

On 15. April 2014 01:55:40 MESZ, Joe Mistachkin  wrote:
>
>Ralf Jantschek wrote:
>>
>> The connection as such is ok. Updates are working. It is only the
>> executereader that is troubling me
>>
> 
>For database files that need a UNC path, four leading backslashes are
>required.
>
>Without them, some things may appear to work correctly; however, it
>might
>also
>exhibit the type of behavior you are seeing.
>
>Please try using the four leading backslashes and let us know the
>outcome.
>
>--
>Joe Mistachkin
>
>___
>sqlite-users mailing list
>sqlite-users@sqlite.org
>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

I just tried... No change :-(
-- 
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users