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 file that working properly and with any problem? There is only limitation on the total number of pages in the file. So, the file size is limited by SQLITE_MAX_PAGE_COUNT times PAGE_SIZE. Thus, given enough page size, say, 8 to 64 kilobytes, sqlite successfully handles files of many terabytes in size, provided underlying filesystem supports them, of course. Be prepared to wait quite a long for non-sqlite operations (copy, delete etc.) to complete on such a big files. Valentin Davydov. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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, Igor Tandetnik i...@tandetnik.org wrote: e-mail mgbg25171 mgbg25...@blueyonder.co.uk wrote: I have modified my program to have next time (not shown) as well as next date What I'd to know is... How do I order results firstly by earlest non-null/empty string next time (ALL DAYS HERE WILL BE TODAY) order and then BY earliest non-null/empty string nextdate order so... I end up with a list of records in call time order followed by a list of records beginning with the one called longest ago. I'm not sure I completely understand the requirement, but play with something like this: order by (f.nexttime is null or f.nexttime=''), coalesce(f.nexttime, ''), f.lastdate The first expression is boolean, its result is 0 or 1, so what it does is separate all records into two groups, and sort the first one (the one for which the expression is false) ahead of the second one (where the expression is true). The other two expressions are each designed to sort one of these groups without affecting the other. -- Igor Tandetnik ___ 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] 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 important.) During the close, the DBA.mjx is deleted as is the DBB.journal file. The DBA.journal file is not deleted until the next time I open it. Am I misunderstanding something? Thanks, Marc -- ** * * * * Marc L. Allen * ... so many things are * * * possible just as long as you* * Outsite Networks, Inc. * don't know they're impossible. * * (757) 853-3000 #215 * * * * * * mlal...@outsitenetworks.commailto:mlal...@outsitenetworks.com * -- The Phantom Tollbooth * * * * ** ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 gbytes are increasing. Best regards, Caglar ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 bill-of-materials so that line counts are held down and horizontal space is well used. So, starting with a column which might be: RefDes -- R1 R2 ... R190 I want to convert it to something like: R1,R2,...,R50, R51,R52,...,R100, R101,R102,...,R150, R151,...,R190 where the clump length, setting the number of designators per line, is a parameter. (Ideally, the string length of the clump would be the criterion, but this is dispensible.) The converted result is destined for a spreadsheet, and I would really like the pseudo-table created therein to be a simple projection or view of the real data. I realize this is not hard to do programmatically, (having done it a few times), but it would be nice for process/work-flow reasons to be able to use a query to get the data in presentation form. If there is no way to get a view that does this, I can create a derivative database table with the clumping already done programmatically. But that presents its own issues, such as when to run the code that creates it. I'm stumped as to how to do this. I've done the reverse transformation in SQL, so it seems like this should not be as hard as I have found it to be. Thanks for any tips, (even Give up.) -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] PERSIST Journal Mode
On 17 Dec 2012, at 8:35pm, Marc L. Allen mlal...@outsitenetworks.com 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 _close(). So are you looking to see an update before or after your code has executed _close() ? How are you looking for an update ? The file's modification timestamp ? Also, are you sure you are executing _close() with the right parameter, and can you check the result returned from _close() to make sure it returns SQLITE_OK ? Simply taking out the PRAGMA fixed things. Any ideas where I should look? Clip from your earlier post: 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 important.) During the close, the DBA.mjx is deleted as is the DBB.journal file. The DBA.journal file is not deleted until the next time I open it. One situation I think might cause this is if the database isn't closed properly. When SQLite reopens the database it realises it is corrupt. It restores the database to a usable condition, then (this is just a guess) it deletes the old journal so it can make a new uncorrupted one. However, I can't answer your basic problem. I see no reason why these things should change just because you're using PERSIST mode. But there are people who understand SQLite internals better than I do. Simon. ___ 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
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 develo...@barefeetware.com -- Follow us on Twitter: http://twitter.com/barefeetware/ Like us on Facebook: http://www.facebook.com/BareFeetWare ___ 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 numerical part so predictable, but those issues can be met in the source table design.) Thanks, too, for helping me see that I should look at 'group by' clauses more fundamentally. Best regards, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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] found a Malware , when download sqlite-shell-win32-x86-3071500.zip
Hello, 2012/12/18 Miles Liu liu.mi...@gmail.com: 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/ HTH, Roy ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users