SQLite object

    (karrrlo)
    Oct 24 2008 | 11:49 am
    greetings , i am about to start exploring the SQLite object thanks to Andrew's tutorial. i wanted to know if anybody already used it with large databases. what is the efficiency compared to a [pattr] based system or a jit.matrix based one ?
    i am looking or an efficient storage system for an interface wih numerous modules and parameters that need a tight response when recalling.
    • Anthony Palomba
      Oct 24 2008 | 4:43 pm
      I am interested in this as well. Yes, Andrew's tutorial is really useful. It has sparked a lot of ideas...
      I am curious to know what the performance is like as well. I would like to develop a spectral database, similar to the video database in the tutorial. I want to be able to run hundreds of sound files through some process that extracts spectral characteristics and stores them in the DB. I could then resynthesize a composite sound by giving it a meta description.
      Ultimately, I would like to do Spectral Recontextualization... http://www.mat.ucsb.edu/~b.sturm/sand/VLDCMCaR/VLDCMCaR.html To make this work I think you would need some kind of system that stored FFT frames on disk that you could access at will.
      Some very interesting possibilities...