SQL Database - Javascript - not showing WAV files, only video and image files

Julian Brown's icon

Hi there,

I’d like to use the SQLite Database functionality within Max to build a patch that lets me assign metadata and create customised players for audio files to use in installations and interactive projects.

I’ve been going through https://cycling74.com/tutorials/data-collection-building-databases-using-sqlite as a starting point and it mostly makes sense to me. However I can’t figure out why I can’t load WAV or audio files, even if I change the movieBase.js file (see attached).

Similarly I’m not entirely sure how I would go about creating a new database, as I’m not sure if it either keeps loading “dumpster” as specified in the javascript file or ./testDB1 as per the message calling the function.

I would like to ideally start from scratch, make a new database and load audio files in where I can then create an interface to start assigning metadata.

I’d be grateful if anyone could shed any light or have any insight that could help

Cheers! :)