Re: [sqlite] sqlite3_analyzer source code
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
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
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
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
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)
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
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
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
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
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
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
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
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