Re: [sqlite] Storing/editing hierarchical data sets

2011-07-12 Thread Christopher Melen
com > To: sqlite-users@sqlite.org > Date: Tue, 12 Jul 2011 11:38:13 + > Subject: Re: [sqlite] Storing/editing hierarchical data sets > > I thought of another way to do your copy/cut/paste... > > > > Assuming you keep the original audio around and use the levels I showed >

Re: [sqlite] Storing/editing hierarchical data sets

2011-07-12 Thread Black, Michael (IS)
n Systems Advanced Analytics Directorate From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Christopher Melen [relativef...@hotmail.co.uk] Sent: Sunday, July 10, 2011 12:52 PM To: sqlite-users@sqlite.org Subject: EXT :[sqli

Re: [sqlite] Storing/editing hierarchical data sets

2011-07-12 Thread Alexey Pechnikov
See FTS3 extension where the full-text index is stored in multi btree in regular tables. Note: FTS2 is more simple. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Storing/editing hierarchical data sets

2011-07-11 Thread J Decker
On Sun, Jul 10, 2011 at 10:52 AM, Christopher Melen wrote: > > 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

Re: [sqlite] Storing/editing hierarchical data sets

2011-07-11 Thread Black, Michael (IS)
of Christopher Melen [relativef...@hotmail.co.uk] Sent: Monday, July 11, 2011 3:28 PM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] Storing/editing hierarchical data sets Many thanks for your neat, simple suggestion, Michael. Sometimes you can miss the wood for the btrees... Using tables

Re: [sqlite] Storing/editing hierarchical data sets

2011-07-11 Thread Christopher Melen
rom: michael.bla...@ngc.com > To: sqlite-users@sqlite.org > Date: Sun, 10 Jul 2011 19:41:07 + > Subject: Re: [sqlite] Storing/editing hierarchical data sets > > Somebody smarter than I may be able to figure out how to use views to do the > upper levels. > > But if y

Re: [sqlite] Storing/editing hierarchical data sets

2011-07-10 Thread Petite Abeille
On Jul 10, 2011, at 9:41 PM, Black, Michael (IS) wrote: > Somebody smarter than I may be able to figure out how to use views to do the > upper levels. Was there a question hidden somewhere in your post? :) ___ sqlite-users mailing list

Re: [sqlite] Storing/editing hierarchical data sets

2011-07-10 Thread Black, Michael (IS)
Advanced Analytics Directorate From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Christopher Melen [relativef...@hotmail.co.uk] Sent: Sunday, July 10, 2011 12:52 PM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Storing/editing

[sqlite] Storing/editing hierarchical data sets

2011-07-10 Thread Christopher Melen
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