Re: [sqlite] .import FILE TABLE

2010-08-11 Thread Oliver Peters
Larry Siden lsi...@... writes: What is the format of the file? I cannot find it documented anywhere. It is a csv file with the same fields in the same order as your table has. You can set the separator of the csv this way .separator \t (\t == tab, default is |) Oliver

Re: [sqlite] severe slowdown for sub-queries, solved in 3.7?

2010-08-11 Thread Black, Michael (IS)
My patches are awating moderator approval so I figured I'd just send out the info in case they get killed. See below to fix your problem with a minimal patch. Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems

Re: [sqlite] severe slowdown for sub-queries, solved in 3.7?

2010-08-11 Thread Black, Michael (IS)
The patch that fixed your problem was on 2010-04-07 I've attached a patch from 3.6.23 to that version. It's 1849 lines of so that's not too bad for QA. I've also attached a context diff too. A bit easier to read if you need QA to look at it. The sqlite3 source is too big for an

Re: [sqlite] Write-ahead logging and database locking

2010-08-11 Thread Pavel Ivanov
Also, I see in the documentation that when shared-cache mode is enabled, SQLite uses table-level locking (instead of the default file-locking). Taken all together, it suggests that you can get table-level locking *and* write-ahead logging *and* atomic multi-table commits -- all within a

[sqlite] Mozilla History Autodelete

2010-08-11 Thread All Marri
Hi there , I have a problem . My FF history autodelete itself sometime and i do not know why also i would ask to you how to find the deleted history / bookmarks . Tnx for help and patience and sorry for my bad english .

Re: [sqlite] Mozilla History Autodelete

2010-08-11 Thread Artur Reilin
Do you have the option activated, that your history will be cleaned all ## days? Also, do you use something like places cleaner or so? (Btw. I think it's funny to store icons in an sqlite database ...) Artur Hi there , I have a problem . My FF history autodelete itself sometime and i do not