#musicbrainz

what is this mturk? is it 21th century slavery? http://www.mturk.com/mturk/preview?groupId=1V8Z...

What crazily old version of postgres are you running? :/

Cause I was only coding a client side "widget" to submit a rating

$3 for the transcript of a 58-minute lesson

aCiD2: yes, and much more. i particularly like this bit: "Data Verification / Clean-up

• Identification of duplicate products in an online product catalog"

Play it double speed and you might meet half-minimum-wage.

FauxFaux: Ummm, the latest version in Gentoo

Which is pretty new

But maybe I didn't compile with view support?

I'd be shocked if you could do that. /me checks something.

yllona: sounds neat :)

aCiD2: is that even possible?

Idk!

lol

let me ssh in again and run faux's script

(if he'd give me link :P)

FauxFaux: the mturk transcription service was generating ~50K/mo revenue last time i checked.

http://faux.no-ip.biz/svn/mbreports/cueread2.php <-- and yes, the create view temporary is valid.

Thanks

Create aggregate works

yllona: 50k per person?

aCiD2: I'm running 8.1, 8.2 is out, but thye own't have removed view support. :p

LINE 1: create temporary view album_tracklen as select albumjoin.alb..."

aCiD2: here's another tidbit that makes me tingle: "Quality Management Tools

Amazon Mechanical Turk provides several mechanisms to help you ensure the quality of the work you receive. In addition to worker qualifications, plurality is another mechanism to help developers maintain high quality levels. This functionality enables multiple workers to submit answers to the same HIT. When a specific number of workers reply back with the same answer, the HIT is automatically approved. Additionally, you only

Remove the temporary and try it?

ok

that works faux

Great!

Sharon: mail sent.

create table db killing time!

yllona: so what does that last bit actually mean?

FauxFaux: the transcription service as a whole was generating 50K/mo, lat time i checked and that would be last summer.

I'd hope it'd be a lot faster on your machine than my poor 512mb unassisted vm. :)

yllona: Masochists.

ruaok: thanks.. reading it.

aCiD2: there's your ranking/rating system API, already designed. you don't need to use mturk, it's just a well-established model to work from

Sharon: the wiki page will be: http://wiki.musicbrainz.org/RatingSystem

ruaok: okay.

FauxFaux: i worked on an online transcription system for first responders during hurricane katrina. professional transcribers are so fast it's amazing. so yes, as a worker bee (transcriber), you could earn some very easy money

ruaok: where exactly do i put this link?

on the rating page where a user rates an entity.

that page needs lots more text, for sure. :)

yeah okay :)

FauxFaux: wow, that query finished already.. seems a bit quick

Anyway, script seems to execute now, I'll just finish hacking it :)

aCiD2: Mm, ~twice as fast, not bad.

Urk, it returns 0 rows for your numbers faux :(

You should have at least as many rows in the new table as in the album table.

(brb 3 minutes)

FauxFaux: http://dpaste.com/14153/ is my SQL

bye ppl, good night. Please be careful with the accents in the Italian titles on Morricone's tracks ;)

how can I count rows in a table in PG?

<-- sql noob

select count(*) from assgasket;

ruaok I want to edit on music I like and similar music. ruaok don't make me peer review the crap I don't know/like. <-- that makes sense :D

yay! someone gets it!

thanks rob :)

sorry, inside joke. :)

should I call you ruaok then? :P

I always type rauok, darn dvorak keybord

I'm kidding.

:)

the only thing that is out is bob.

lol

and my friends from germany get to call me something else that I won't share.

:-)

could call you dobbie... that's the only other nickname for another rob I know lol

anyway

faux, select count(*) from album_tracklist, 492947

select count(*) from album 492950

so that doesn't look right

syntax error

:-0

I liekstars

and you click anditstaysand no reloadign pages

like uhh.. youtube?

I don't rate that trash, mo :

aCiD2: Isn't the album table many times bigger than that..?

:P*

FauxFaux: dunno, that's what count is giving me

that sounds right for releases.

hehe

If you'd add me to your damn pg_hba I'd have finished this script! *waves fist*

495512

mines not synced

from the 7-7 dataset,

I was thinking of track; :)

nearly half a mil.

nice. :)

still waiting on my pg to return :P

yea, 0.58 mil here

umm, 5.8million, even

Yeah.

(Aagh, it's paging, aagh!)

I wonder what went wrong with album_track thingy :(

Look at the first 5 rows or so (select * from album_tracklist limit 5; if you refuse to use a graphical client), should be something like 4, {44444,4234234,24134566,23,4123,4123,1234123,412,341,2341234},9

I just dropped it :P

gonna try again, heh

Oh, that sample doesn't have adding the indexes, might want to add that for speed, won't affect the results, though. :)

I keep reading " select count(*) from foo bar" as "select cunt(*).."

LOL

(Also a) dvorak sucks and b) how the hell is asf harder than afs? :P)

dvorak does not suck, it's waaay comfier

for me anyway

sooo. about those trakc annotations

also a year ago tagger icon

It's like they've intentionally designed it to be harder to use. Swapping keys that are right next to each other can't make /that/ much different. (ty for instance). And changing the symbol keys that aren't near the home row anyway.

good lord, select * from album_tracklen limit 10 takes a bit of time :P

Yeah, views don't pre-calculate any data, that has to scan and filter the entirety of the track table. :p

ah... well it's gotta do select queries for the script anyway

so it might as well do it now!

ruaok: do you remember how you asked me for a redesign of the tagger image?

and faux, just open your db up! I wanna test my script :(

aCiD2: Um.. views don't cache..

the download image?

that to

aCiD2: do you need access to a DB?

but the 'tagger' icon for picard

ok...

now that the tagger belongs more to luks than me, I'm not sure if I am in the position to ask for that anymore.

shit, picardqt doesn't belong to me at all.

that is very true

I did like your note graphics, though.

.)

i'd like somesort of enhancement on the bugtracker where eI could uploadthem

ruaok: yes, but with faux's custom table added

so that if eventually they get used, the peron codignthem would kbow where to go

I have my own db, but I can' get his table to work

*get them from

yes

Ping me, I'm going to go be all immature and shoot things.

but I need a bugreport first!

:)

catgroove: then create one!

or enhance,ment report

ehh

aCiD2: ping me if you need some access. I've got DBs coming out my arse

haha

pm then?

is that a yes?