Re: [sqlite] Unexplained table bloat

Hi, I checked the download mentioned in the original email. Not sure if the table changed since the previous posts. It seems LUTFullString has 3 BLOB rows, but LENGTH treats them as strings. I'm in Melbourne, Oz, so I added the UTC datetime. regs, Kev kevin@KCYDell:~$ cd /mnt/KCY/KCYDocs/

Re: [sqlite] Regarding CoC

Richard, thank you for your further explanation of your team's Code of Conduct. After a bit of research on the Internet, everything makes sense. Well done. regs, Kev ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Weird chars inserted

Ariel, Keith, Rowan,  apologies, I re-ran the queries a few times, and I decided to include "rowid" to keep track of the changes. The experiments were conducted by cut-and-paste of the í character from the email, hence UTF8, and using x'...' for inserts and concats. Note, I use sqlite3 shell

Re: [sqlite] Import 5000 xml files in a sqlite database file

Bob, my name is Kevin Youren, and I did this task about 4 years ago in Python 3, by parsing XML files and creating CSV files. The CSV files were used to load Sqlite tables, MS Xcel spreadsheets and IBM mainframe DB2 tables. The XML data was mildly complex, large, and error prone. If you have

[sqlite] Mozilla wiki 'avoid SQLite'

In my tool box, I have a tack hammer, a claw hammer and a nail gun. I broke my fingernail with the tack hammer. I still have the bandaid on my thumb from the claw hammer. Now I just have to read the instruction manual for the nail gun

[sqlite] Request: Metadata about C API constants and functions

Thanks, Richard I found (https://www.sqlite.org/docsrc/timeline) & https://www.sqlite.org/docsrc/artifact/5c48dd261dbe5804 very useful. Last year I was parsing 100M of XML stuff and loading it into an Sqlite database. A bit of hammering required as the XML had minor errors like missing end

Re: [sqlite] 3.7.10 problem : SQLite header and source version mismatch

Thank you, Kevin Benson, for your hint about ldconfig Using ldconfig -p , I found their is an older version of libsqlite3 in /usr/lib/i386-linux-gnu So I replaced it with my compiled 3.7.10 version , and now sqlite3 works from the command line. regs, Kevin Youren

[sqlite] 3.7.10 problem : SQLite header and source version mismatch

G'day, thanks for such a great program. Slight problem with sqlite-autoconf-3071000 When I issue from the command line: sqlite3 I get SQLite header and source version mismatch 2011-06-23 19:49:22 4374b7e83ea0a3fbc3691f9c0c936272862f32f2 2012-01-16 13:28:40

[sqlite] Select via Wi-fi very slow

Emany, this has possibly already been done, but have you got an index on the table for the column called "description"? I would suggest a timed test on both the Symbol device and the computer before and after the index is added. Also, the Symbol may only have 64Mb of RAM, which probably would