Re: [sqlite] Accumulation of windows temp files

Nathan, try googling "etilqs" - some interesting (and hopefully helpful) results. As others (including Richard, Sqlite's creator) have said it's absolutely not Sqlite's fault that you are having this problem. Nothing inside Sqlite is causing it, but rather something on your machine that is

Re: [sqlite] SQLite Wiki doesn't work

Not an ideal solution, certainly, but if you know the name of the page you want, or maybe the subject, you should be able to use the Google cache to retrieve an older version of it. I had one of the wiki pages open in my browser which I hadn't looked at in a while, and just noticed it's

Re: [sqlite] Storing/editing hierarchical data sets

g > records in between. > > I'll leave that as an exercise for you. > > > > This would > > > > Michael D. Black > > Senior Scientist > > NG Information Systems > > Advanced Analytics Directorate > > > > _

Re: [sqlite] Storing/editing hierarchical data sets

vel4 set l=(select max(level3.l,level3.r) from level3 where > level4.rowid=level3.rowid/2); > > update level4 set l= (select max(l,r) from level3 where > level4.rowid=(level3.rowid+1)/2); > > select * from level4; > id|l|r > |91|214 > > > > Michael D. Black &g

[sqlite] Storing/editing hierarchical data sets

Hi, I am developing an application which analyses audio data, and I have recently been looking into Sqlite as a possible file format. The result of an analysis in my application is a hierarchical data set, where each level in the hierarchy represents a summary of the level below, taking the