A fancier alternative to Coll?
I’d love to find something that lets me sort lists and lists of lists and do searching, sorting, retrieval like coll, but not limited to the first thing in the list. Something that could potentially work like finder or explorer or the loop menu in garage band. Any ideas?
your best bet is probably using java – or the mysql object.
but oyu can do most of that ussing coll, too. (say like receiving more than one ID by calling more than one ID, sequentially)
Then there is the dict family as well, but having established a relationship with sqlite and not really getting ‘comfortable’ with dict I haven’t used it in a practical situation…
Thanks a lot for your advice so far guys!! I’m looking into what you’ve mentioned…
SQL looks awesome. Do you know anything about FTM and whether it too would appropriate for this, and if so how it compares to SQL(lite)?
Easily associate tags (like hashtags on twitter or tags on soundcloud)
in various categories (like tempo, mood, style, loop length)
with a song/loop name or number.
1b- Maybe add (a) value(s) to each tag denoting its significance/priority or room for error
Sort the songs/loops/numbers based on a tag category,
numerically or alphabetically or a custom order
(like sorting by name, date modified, comment, etc in Finder on Mac or Explorer on Win)
3- Sort/Compare them based on
their likeness to a song/loop/number
and/or its associated tags.
4- Output the most appropriate song/loop/number as a message or int when requested.
5- Count the number of times a song/loop/number has been outputted/played
and use that as a tag.
Also for those interested here are some SQL things i found,
if you see the implementation of dicts in the bach library helpfiles it will probably give you agoo dexample of what can be done with dict : http://www.bachproject.net/
but, idk a hting about sql ; few about ftm. If you need sound analysis ftm might have supplementary things for you though.
I don’t know about the bach version of dict (though that library is generally awesome) but the standard max version of dict will do most if not all of what you mentioned.. and it readily handles json format which is great for meta data.
Also consider the odot library (CNMAT). That entire library (specifically, the bundle data type) is incredibly powerful and flexible… so forgive the rant.. It’s obvious that most people are unaware of the unique power of that library. It’s not just useful for data flow programming in Max, it transcends many of the limitations of data flow programming itself (ex. you can name values, refer to values and/or execute expressions using those names on the fly at any point in the patch regardless of the data that is currently being received by the object. Think about that for a moment.) o.expr is like a library within a library with a huge list of functions (and a help file that is actually useful). o.explode and o.flatten handle nesting of arrays. The delimiter ‘/’ that is used to address values has meta functionality useful for organizing hierarchies, specifying paths, osc formatting, etc. And o.dict converts bundles to dictionaries so you’re not stuck in bundle land.
Ok, I’ll stop now. :)
I finally got around to using SQL database.
I attached a UI I made so you can easily create and manipulate databases.
I have one question I can’t seem to find an answer to though: How do I get SQL to work on windows? http://cycling74.com/2008/09/05/data-collection-building-databases-using-sqlite/ works on mac but not on windows in my experience…
- This reply was modified 10 months by maat.
can you repost your tagger2 patch– it doesn’t want to download. Thanks!
Thanks! looks impressive