Re: [sqlite] found a Malware , when download sqlite-shell-win32-x86-3071500.zip

Hello, 2012/12/18 Miles Liu : > sqlite-shell-win32-x86-3071500 > when download it , anti-virus said found a Malware. False positive. VirusTotal report here: https://www.virustotal.com/file/85fa29a391d7ab8af4736dfd36222a651a9b3af56c5f81bb58c9b106eaa63533/analysis/1355816443/

[sqlite] found a Malware , when download sqlite-shell-win32-x86-3071500.zip

sqlite-shell-win32-x86-3071500.zip (266.33 KiB) when download it , anti-virus said found a Malware. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Denormalized view, "clumping" into length-limited groups

Tom B. wrote: So, do you mean something like: select group_concat(RefDes) as Clump from MyTable group by cast ((substr(RefDes, 2, 99) - 1) / 50 as integer) Yes, something like that is just what I needed. Thanks! (The designators are not always in such a monotonic sequence, nor is their

Re: [sqlite] Denormalized view, "clumping" into length-limited groups

So, do you mean something like: select group_concat(RefDes) as Clump from MyTable group by cast ((substr(RefDes, 2, 99) - 1) / 50 as integer) which seems to work. Tom Tom Brodhurst-Hill BareFeetWare -- iPhone/iPad/iPod and Mac software development, specialising in databases

Re: [sqlite] PERSIST Journal Mode

On 17 Dec 2012, at 8:35pm, "Marc L. Allen" wrote: > Another item.. when having Journal Mode = PERSIST, DBA (in the example below) > was not being physically updated. DBB was. I can think of a reason you might not be able to see an update until you have executed

[sqlite] Denormalized view, "clumping" into length-limited groups

I've got a table which can be described as holding one "RefDes" per row. (They are reference designators in a electronic PCB schematic or its bill-of-materials.) There are thousands of them, and each one is very short, inducing the convention of clumping them together for display in a

[sqlite] File size limitation of an sqlite file, "thanks"

Thank you Valentin, Alexey and Sandro. FTS3 and FTS4 are very good that i have never heard about them. We all have to read http://www.sqlite.org/fts3.html at least one time. Alexey,Sandro i'm glad to hear you that 100-160GBs are tested. Thank you very much. I will share my experiences while

[sqlite] PERSIST Journal Mode

I'm having some unexpected results using PRAGMA journal_mode = PERSIST; My general flow runs something like: open(DBA) PRAGMA journal_mode = PERSIST; ATTACH DBB SQL ... close() If the DBA.journal file exists, it's deleted before the attach (though I haven't identified exactly where. I can if

Re: [sqlite] ordering result sets

Igor >I'm not sure I completely understand I'm not surprised re-reading my requirement. It isn't clear at all. I'll have a play with what you've given me first. Thank you very much...not only for the solution but also for your explanation which I really appreciate. Dean On 17 December 2012 00:39,

Re: [sqlite] Any limitation of file size on sqlite?

On Sun, Dec 16, 2012 at 10:02:41PM +0200, ?a?lar Orhan wrote: > Hello again, > Thank you Simon. > The page http://www.sqlite.org/limits.html has my answer partly. In MS IIS > what gbytes bigger size of .sqlite file should significant to work on it > properly? > I mean, is there a 10-12 GB sqlite