#metabrainz

/

      • ruaok
        how do I go about selecting the artist_credit.name for ac1 ?
      • 2019-05-31 15121, 2019

      • pristine__
      • 2019-05-31 15129, 2019

      • pristine__
        ruaok: ^^
      • 2019-05-31 15101, 2019

      • pristine__
        these are suggested artists for you. Can you relate?
      • 2019-05-31 15155, 2019

      • pristine__
        If you feel this is going in right dir, I will continue and write a detailed HTML .
      • 2019-05-31 15111, 2019

      • rdswift
        <ruaok> how do I go about selecting the artist_credit.name for ac1 ? I think you need to select the ac1 from a different instance of the artist_credit table, linked on the arr.artist_credit_1 value.
      • 2019-05-31 15157, 2019

      • ruaok
        yea, I agree.
      • 2019-05-31 15101, 2019

      • ruaok
      • 2019-05-31 15107, 2019

      • ruaok
        pristine__: hi. let me look.
      • 2019-05-31 15136, 2019

      • pristine__
        okay
      • 2019-05-31 15116, 2019

      • ruaok
        looking at a few pages worth, I recognize no names at all.
      • 2019-05-31 15140, 2019

      • pristine__
        Maybe I will try on a small set
      • 2019-05-31 15148, 2019

      • pristine__
        a min
      • 2019-05-31 15156, 2019

      • rdswift
        Yup, that's pretty much exactly what I was going to suggest.
      • 2019-05-31 15113, 2019

      • reosarevok
        why a left join? Don't both always have ACs?
      • 2019-05-31 15137, 2019

      • reosarevok
        Not that it matters, I guess, but :)
      • 2019-05-31 15111, 2019

      • reosarevok
        "Pierre Boulez, BBC Singers, Ensemble InterContemporain, Pierre Boulez" lol, I don't quite see ruaok listening to Boulez for some reason
      • 2019-05-31 15145, 2019

      • ruaok
        reosarevok: not sure.
      • 2019-05-31 15149, 2019

      • ruaok
        let me try without.
      • 2019-05-31 15149, 2019

      • reosarevok
        And something that recommends both that and "Sonic The Hedgehog's Lost Skateboarding Game" probably needs some finetuning, yes
      • 2019-05-31 15135, 2019

      • rdswift
        It might work without it. I'm old school and specify the joins for pretty much everything. Maybe not the best for scaling...
      • 2019-05-31 15150, 2019

      • ruaok
        I think left join = default join no?
      • 2019-05-31 15102, 2019

      • ruaok
        the explain suggests that there is no difference.
      • 2019-05-31 15129, 2019

      • ruaok
        now I need to disambiguate artists and I can put up a sample page for people to play for them selves.
      • 2019-05-31 15117, 2019

      • ruaok
      • 2019-05-31 15147, 2019

      • KassOtsimine
        that's interesting, i mean, several of these hits are hinge I like, even if I wouldn't say they similar to UH
      • 2019-05-31 15112, 2019

      • KassOtsimine
        I was expecting "Spice" n°1
      • 2019-05-31 15116, 2019

      • ruaok
      • 2019-05-31 15143, 2019

      • KassOtsimine
        since that's the pre UH band with many of the same members
      • 2019-05-31 15105, 2019

      • KassOtsimine
        hah, Motörhead is related to both :D
      • 2019-05-31 15145, 2019

      • KassOtsimine
        hmm there are a lot less thrash metal bands for nr2 than I'd expect
      • 2019-05-31 15145, 2019

      • ruaok
        I'm going to go as far as being to run this script on the main DB in a separate schema, so that we can start using this data on the MB.org
      • 2019-05-31 15154, 2019

      • ruaok
        might be useful to limit viewing edits.
      • 2019-05-31 15103, 2019

      • ruaok
        "show my edits related to my subscribed artists"
      • 2019-05-31 15120, 2019

      • KassOtsimine
        hmmm
      • 2019-05-31 15158, 2019

      • KassOtsimine
        would.. would it be interesting to have a feedback mechanism so people could
      • 2019-05-31 15159, 2019

      • ruaok
        redone with order by count:
      • 2019-05-31 15100, 2019

      • ruaok
      • 2019-05-31 15103, 2019

      • ruaok
        does that look better?
      • 2019-05-31 15111, 2019

      • KassOtsimine
        say "not interested/not related"
      • 2019-05-31 15132, 2019

      • ruaok
        it would be hard to incorporate the data. :(
      • 2019-05-31 15148, 2019

      • ruaok
        this algorithm is super stupid.
      • 2019-05-31 15151, 2019

      • KassOtsimine
        and feed that BACK into the script/machine learning?
      • 2019-05-31 15159, 2019

      • ruaok
        possible.
      • 2019-05-31 15102, 2019

      • ruaok
        not yet.
      • 2019-05-31 15122, 2019

      • KassOtsimine
        yea, that was better :)
      • 2019-05-31 15132, 2019

      • ruaok
        we're still in the early steps, just trying to enable aidanlw17 and pristine__ 's work to be meaningful over the summer.
      • 2019-05-31 15113, 2019

      • aidanlw17
        😁
      • 2019-05-31 15117, 2019

      • KassOtsimine
        yea sure. I mean these and everybody's suggestions are just replies where we see what could be amazingly possible down the road
      • 2019-05-31 15136, 2019

      • KassOtsimine
        atleast mine are :D
      • 2019-05-31 15144, 2019

      • pristine__
      • 2019-05-31 15146, 2019

      • pristine__
        ruaok: ^
      • 2019-05-31 15152, 2019

      • ruaok
        yeah, that still doesn't look good to me.
      • 2019-05-31 15105, 2019

      • ruaok
        I'd say, let's go with the data I am generating.
      • 2019-05-31 15143, 2019

      • aidanlw17
        alastairp: remember how we were talking about adding vectors of form [0, 0, ..., 0] to the index for empty rows?
      • 2019-05-31 15128, 2019

      • pristine__
        ruaok: okay
      • 2019-05-31 15145, 2019

      • ruaok
        here is the schema of the data I am generating:
      • 2019-05-31 15146, 2019

      • ruaok
      • 2019-05-31 15157, 2019

      • pristine__
        I am just concern about the artists we will be missing out
      • 2019-05-31 15118, 2019

      • ruaok
        I hear you. but that is all an bit of an improvement for later.
      • 2019-05-31 15128, 2019

      • ruaok
        for now, lets use this data to build candidate data sets.
      • 2019-05-31 15143, 2019

      • ruaok
        remember our goal: something that works. not something that is perfect.
      • 2019-05-31 15152, 2019

      • pristine__
        Yeah :)
      • 2019-05-31 15146, 2019

      • pristine__
        Artist_credit_0 and artist_credit_1 ?
      • 2019-05-31 15155, 2019

      • pristine__
        Pair of similar artists?
      • 2019-05-31 15122, 2019

      • ruaok
        similar artist_credits.
      • 2019-05-31 15152, 2019

      • ruaok
        and count is the number of times the this artist_credit pair appears on a various artist album together.
      • 2019-05-31 15117, 2019

      • pristine__
        Have you pushed the code?
      • 2019-05-31 15128, 2019

      • pristine__
        I mean, can I have a look?
      • 2019-05-31 15145, 2019

      • ruaok
      • 2019-05-31 15143, 2019

      • pristine__
        Yeah. Thanks.
      • 2019-05-31 15110, 2019

      • akhilesh
        Mr_Monkey: Around?
      • 2019-05-31 15154, 2019

      • Mr_Monkey
        Yo akhilesh !
      • 2019-05-31 15132, 2019

      • akhilesh
        As you commented on api PR `You'll want to copy src/server/app.js and see what you need to keep in that file to have an express server running. You will also want to copy /routes.js and keep only your new endpoints.` Then how will we run the project, are you sure with this structure? LB has only one app file file and running at different server.
      • 2019-05-31 15138, 2019

      • akhilesh
        Mr_Monkey: ^
      • 2019-05-31 15122, 2019

      • akhilesh
        It may also requires changes in package.json
      • 2019-05-31 15116, 2019

      • akhilesh
        like introducing commands `start api-server`.
      • 2019-05-31 15147, 2019

      • Mr_Monkey
        We'll run adifferent command to run the API (something like `node lib/api/app.js` instead of `/server/app.js`) .
      • 2019-05-31 15147, 2019

      • Mr_Monkey
        You could try to create two different use cases in server/app.js, but I think it will me more complicated and less legible that way
      • 2019-05-31 15125, 2019

      • Mr_Monkey
        I think a simple change in package.json scripts to add something like `"start-api": "node ./lib/api/app.js"` would be sufficient
      • 2019-05-31 15159, 2019

      • akhilesh
        and `debug-api`
      • 2019-05-31 15130, 2019

      • Mr_Monkey
        In production, we're likely to run a similar command directly like we do now: https://github.com/bookbrainz/bookbrainz-site/blo…
      • 2019-05-31 15122, 2019

      • akhilesh
        Then, I am going to create the structure as you mentioned in PR. Mr_Monkey
      • 2019-05-31 15139, 2019

      • Mr_Monkey
        Does it make sense to you?
      • 2019-05-31 15120, 2019

      • akhilesh
        Yep, I think, It is easy one Mr_Monkey
      • 2019-05-31 15153, 2019

      • Mr_Monkey
        If while doing it you see a clear reason why it shouldn't be a separate server, let me know.
      • 2019-05-31 15120, 2019

      • akhilesh
        I am not much aware with these kind of things Mr_Monkey
      • 2019-05-31 15101, 2019

      • Lotheric has quit
      • 2019-05-31 15115, 2019

      • akhilesh
        Is it require more research Mr_Monkey ?
      • 2019-05-31 15151, 2019

      • Lotheric joined the channel
      • 2019-05-31 15154, 2019

      • Mr_Monkey
        I don't think so akhilesh, you can go ahead and make the API a separate Express server
      • 2019-05-31 15101, 2019

      • travis-ci joined the channel
      • 2019-05-31 15101, 2019

      • travis-ci
        Project bookbrainz-data-js build #1101: passed in 3 min 35 sec: https://travis-ci.org/bookbrainz/bookbrainz-data-…
      • 2019-05-31 15101, 2019

      • travis-ci has left the channel
      • 2019-05-31 15153, 2019

      • akhilesh
        Ok, Mr_Monkey , If any one will give good reason to make only server for both then we will make it one.
      • 2019-05-31 15106, 2019

      • akhilesh
        in future
      • 2019-05-31 15127, 2019

      • akhilesh
        Mr_Monkey: how to build api now `npm run build` works for website ?
      • 2019-05-31 15105, 2019

      • akhilesh
      • 2019-05-31 15113, 2019

      • Mr_Monkey
        akhilesh: Are you sure `npm run build` doesn't still build the api files? `"build-server-js": "babel src --out-dir lib"` is one of the subtasks that are called, and should convert anything in src, including src/api
      • 2019-05-31 15102, 2019

      • Mr_Monkey
        And should export lib/src/api out the other end
      • 2019-05-31 15119, 2019

      • akhilesh
        ohh no, not tried until.
      • 2019-05-31 15104, 2019

      • Mr_Monkey
        Making the api a separate express server only changes how we run it (ie calling `node lib/src/api/app.js`, but does not change the rest of the workflow, build, configuration files, etc.
      • 2019-05-31 15151, 2019

      • akhilesh
        ok, I is working.
      • 2019-05-31 15135, 2019

      • akhilesh
        Mr_Monkey: Now if we run `npm run start-api` it works fine but changes are not reflecting in `lib` folder, is it require any more changes to build the project automatically ?
      • 2019-05-31 15159, 2019

      • Mr_Monkey
        akhilesh: the NPM docs say "Additionally, arbitrary scripts can be executed by running npm run-script <stage>. Pre and post commands with matching names will be run for those as well (e.g. premyscript, myscript, postmyscript)"
      • 2019-05-31 15145, 2019

      • Mr_Monkey
        So you should be able to create a `"prestart-api": "npm run build"` script
      • 2019-05-31 15158, 2019

      • Mr_Monkey
        akhilesh: Try that and see if it works
      • 2019-05-31 15109, 2019

      • akhilesh
        ok
      • 2019-05-31 15117, 2019

      • Mr_Monkey
        akhilesh: Actually, make it call "npm run prestart" instead.
      • 2019-05-31 15149, 2019

      • akhilesh
        Mr_Monkey: I made ` "start-api": "npm run build && cross-env SSR=true node ./lib/api/app.js",` it work, but it builds whole project.
      • 2019-05-31 15129, 2019

      • akhilesh
        in pack.json
      • 2019-05-31 15142, 2019

      • akhilesh
        and run `npm run start-api`
      • 2019-05-31 15149, 2019

      • rdswift
        ruaok, here is what I was thinking about to go along with your artist affinity by genre that you did with the common artists on VA albums. This is based on common artists played by users. https://gist.github.com/rdswift/6124f1db7c0633968…
      • 2019-05-31 15105, 2019

      • Mr_Monkey
        akhilesh: Yes, that's true. Well, you could make a ` "build-api-js": "babel src/api --out-dir lib"` script and make "prestart-api" run that
      • 2019-05-31 15154, 2019

      • rdswift
        It is pretty rough, but hopefully conveys the concept.
      • 2019-05-31 15101, 2019

      • akhilesh
        Mr_Monkey: thanks, It is working well.
      • 2019-05-31 15130, 2019

      • Mr_Monkey
        Great :)
      • 2019-05-31 15139, 2019

      • Mr_Monkey
        I think you'll also want to modify the build-server-js npm script to ignore src/api. Something like `"babel src --ignore src/api --out-dir lib"`
      • 2019-05-31 15102, 2019

      • Mr_Monkey
        (Basing myself on bable cli documentation: https://babeljs.io/docs/en/6.26.3/babel-cli#ignor…)
      • 2019-05-31 15123, 2019

      • akhilesh
        ok
      • 2019-05-31 15112, 2019

      • Cyna has quit
      • 2019-05-31 15112, 2019

      • Cyna joined the channel
      • 2019-05-31 15144, 2019

      • akhilesh
        Mr_Monkey: How to control tests for api and website from launch.js, Please modify it. >
      • 2019-05-31 15102, 2019

      • akhilesh
      • 2019-05-31 15134, 2019

      • Cyna
        bitmap: how do I access c.req.uri in my React file ?
      • 2019-05-31 15159, 2019

      • reosarevok
        Cyna $c.req.uri
      • 2019-05-31 15110, 2019

      • reosarevok
        You'll need withCatalystContext if you're not using it
      • 2019-05-31 15112, 2019

      • reosarevok
        (yet)
      • 2019-05-31 15133, 2019

      • ruaok
        rdswift: what you are describing is what we are trying to do with collaborative filtering the LB data.
      • 2019-05-31 15154, 2019

      • Cyna
        ohh
      • 2019-05-31 15106, 2019

      • rdswift
        Okay. Now I understand. Sorry for being so dense.
      • 2019-05-31 15108, 2019

      • Cyna
        I'm currently converting... Problems may arise while I test it
      • 2019-05-31 15112, 2019

      • ruaok
        That is showing some positive results, but we have the problem that we need a candidate data set to recommend into.
      • 2019-05-31 15139, 2019

      • ruaok
        Recommending into all music takes too long.
      • 2019-05-31 15117, 2019

      • ruaok
        This we're hoping to use atist affinity to make smaller candidate sets on a per user basis.
      • 2019-05-31 15149, 2019

      • rdswift
        So user -> artists for that user -> other users with that artist -> other artists for those users (with some sort of weighting)?
      • 2019-05-31 15140, 2019

      • Cyna
        reosarevok: what is form_row_name_with_guesscase(...)
      • 2019-05-31 15159, 2019

      • Cyna
        Its must be converted and given a different name in /root/components
      • 2019-05-31 15121, 2019

      • reosarevok
        It's a macro in forms.tt, and yes, probably should be converted like that :)
      • 2019-05-31 15146, 2019

      • Mr_Monkey
        akhilesh: Open tasks.json and paste this new task in:
      • 2019-05-31 15150, 2019

      • Mr_Monkey
      • 2019-05-31 15152, 2019

      • Cyna
        I cant find it there
      • 2019-05-31 15129, 2019

      • Mr_Monkey
        Then modify your Mocha Tests API launch option to call preLaunchTask "build-api-with-sourcemaps"
      • 2019-05-31 15115, 2019

      • Mr_Monkey
        akhilesh: Also you won't need the `"SSR":true` environment variable in Mocha Tests API, you can remove it
      • 2019-05-31 15138, 2019

      • akhilesh
        ok
      • 2019-05-31 15133, 2019

      • reosarevok
        Cyna: just searching for form_row_name_with_guesscase found it for me?
      • 2019-05-31 15150, 2019

      • ZaphodBeeblebrox is now known as CatQuest
      • 2019-05-31 15104, 2019

      • akhilesh
        Mr_Monkey: when I run test on empty test_db first time, it works fine. Just after, on run the test again it is giving some insert related error, please see the logs, >
      • 2019-05-31 15108, 2019

      • akhilesh
      • 2019-05-31 15126, 2019

      • akhilesh
        Mr_Monkey: Ignore ^, It fixed.