warp wonders if he just entered the first label with a name written in hangul
2007-07-11 19233, 2007
aCiD2
Create aggregate works
2007-07-11 19240, 2007
gioele
yllona: 50k per person?
2007-07-11 19253, 2007
FauxFaux
aCiD2: I'm running 8.1, 8.2 is out, but thye own't have removed view support. :p
2007-07-11 19256, 2007
aCiD2
LINE 1: create temporary view album_tracklen as select albumjoin.alb..."
2007-07-11 19211, 2007
yllona
aCiD2: here's another tidbit that makes me tingle: "Quality Management Tools
2007-07-11 19212, 2007
yllona
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
2007-07-11 19213, 2007
FauxFaux
Remove the temporary and try it?
2007-07-11 19219, 2007
aCiD2
ok
2007-07-11 19236, 2007
aCiD2
that works faux
2007-07-11 19203, 2007
FauxFaux
Great!
2007-07-11 19204, 2007
ruaok
Sharon: mail sent.
2007-07-11 19208, 2007
aCiD2
create table db killing time!
2007-07-11 19230, 2007
aCiD2
yllona: so what does that last bit actually mean?
2007-07-11 19235, 2007
yllona
FauxFaux: the transcription service as a whole was generating 50K/mo, lat time i checked and that would be last summer.
2007-07-11 19200, 2007
FauxFaux
I'd hope it'd be a lot faster on your machine than my poor 512mb unassisted vm. :)
2007-07-11 19208, 2007
FauxFaux
yllona: Masochists.
2007-07-11 19233, 2007
Sharon
ruaok: thanks.. reading it.
2007-07-11 19253, 2007
yllona
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
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
2007-07-11 19206, 2007
BrianG has quit
2007-07-11 19209, 2007
Sharon
ruaok: where exactly do i put this link?
2007-07-11 19227, 2007
ruaok
on the rating page where a user rates an entity.
2007-07-11 19239, 2007
ruaok
that page needs lots more text, for sure. :)
2007-07-11 19207, 2007
Sharon
yeah okay :)
2007-07-11 19222, 2007
aCiD2
FauxFaux: wow, that query finished already.. seems a bit quick
2007-07-11 19209, 2007
aCiD2
Anyway, script seems to execute now, I'll just finish hacking it :)
2007-07-11 19233, 2007
FauxFaux
aCiD2: Mm, ~twice as fast, not bad.
2007-07-11 19238, 2007
aCiD2
Urk, it returns 0 rows for your numbers faux :(
2007-07-11 19254, 2007
FauxFaux
You should have at least as many rows in the new table as in the album table.
bye ppl, good night. Please be careful with the accents in the Italian titles on Morricone's tracks ;)
2007-07-11 19203, 2007
gioele has quit
2007-07-11 19227, 2007
aCiD2
how can I count rows in a table in PG?
2007-07-11 19231, 2007
aCiD2
<-- sql noob
2007-07-11 19246, 2007
ruaok
select count(*) from assgasket;
2007-07-11 19249, 2007
catgroove
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
2007-07-11 19204, 2007
ruaok
yay! someone gets it!
2007-07-11 19205, 2007
aCiD2
thanks rob :)
2007-07-11 19231, 2007
ruaok wonders who this fucking rob guy is.
2007-07-11 19240, 2007
ruaok
sorry, inside joke. :)
2007-07-11 19253, 2007
Apollozeus joined the channel
2007-07-11 19205, 2007
aCiD2
should I call you ruaok then? :P
2007-07-11 19214, 2007
aCiD2
I always type rauok, darn dvorak keybord
2007-07-11 19216, 2007
ruaok
I'm kidding.
2007-07-11 19236, 2007
aCiD2
:)
2007-07-11 19236, 2007
ruaok
the only thing that is out is bob.
2007-07-11 19239, 2007
aCiD2
lol
2007-07-11 19251, 2007
ruaok
and my friends from germany get to call me something else that I won't share.
2007-07-11 19253, 2007
ruaok
:-)
2007-07-11 19256, 2007
aCiD2
could call you dobbie... that's the only other nickname for another rob I know lol
2007-07-11 19259, 2007
aCiD2
anyway
2007-07-11 19214, 2007
aCiD2
faux, select count(*) from album_tracklist, 492947
2007-07-11 19225, 2007
aCiD2
select count(*) from album 492950
2007-07-11 19229, 2007
aCiD2
so that doesn't look right
2007-07-11 19230, 2007
ruaok
syntax error
2007-07-11 19233, 2007
ruaok
:-0
2007-07-11 19236, 2007
catgroove
I liekstars
2007-07-11 19244, 2007
catgroove
and you click anditstaysand no reloadign pages
2007-07-11 19249, 2007
catgroove
like uhh.. youtube?
2007-07-11 19257, 2007
aCiD2
I don't rate that trash, mo :
2007-07-11 19257, 2007
FauxFaux
aCiD2: Isn't the album table many times bigger than that..?
2007-07-11 19259, 2007
aCiD2
:P*
2007-07-11 19209, 2007
aCiD2
FauxFaux: dunno, that's what count is giving me
2007-07-11 19215, 2007
ruaok
that sounds right for releases.
2007-07-11 19217, 2007
FauxFaux waits for my db server to boot again.
2007-07-11 19220, 2007
aCiD2
hehe
2007-07-11 19235, 2007
aCiD2
If you'd add me to your damn pg_hba I'd have finished this script! *waves fist*
2007-07-11 19240, 2007
ruaok
495512
2007-07-11 19246, 2007
aCiD2
mines not synced
2007-07-11 19247, 2007
ruaok
from the 7-7 dataset,
2007-07-11 19258, 2007
FauxFaux
I was thinking of track; :)
2007-07-11 19207, 2007
ruaok
nearly half a mil.
2007-07-11 19212, 2007
ruaok
nice. :)
2007-07-11 19220, 2007
aCiD2
still waiting on my pg to return :P
2007-07-11 19234, 2007
aCiD2
yea, 0.58 mil here
2007-07-11 19245, 2007
aCiD2
umm, 5.8million, even
2007-07-11 19202, 2007
FauxFaux
Yeah.
2007-07-11 19213, 2007
FauxFaux
(Aagh, it's paging, aagh!)
2007-07-11 19218, 2007
aCiD2
I wonder what went wrong with album_track thingy :(
2007-07-11 19215, 2007
FauxFaux
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
2007-07-11 19227, 2007
aCiD2
I just dropped it :P
2007-07-11 19231, 2007
aCiD2
gonna try again, heh
2007-07-11 19228, 2007
FauxFaux
Oh, that sample doesn't have adding the indexes, might want to add that for speed, won't affect the results, though. :)
2007-07-11 19242, 2007
catgroove
I keep reading " select count(*) from foo bar" as "select cunt(*).."
2007-07-11 19249, 2007
ruaok
LOL
2007-07-11 19249, 2007
FauxFaux
(Also a) dvorak sucks and b) how the hell is asf harder than afs? :P)
2007-07-11 19222, 2007
aCiD2
dvorak does not suck, it's waaay comfier
2007-07-11 19225, 2007
aCiD2
for me anyway
2007-07-11 19204, 2007
catgroove
sooo. about those trakc annotations
2007-07-11 19211, 2007
catgroove
also a year ago tagger icon
2007-07-11 19218, 2007
FauxFaux
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.
2007-07-11 19228, 2007
aCiD2
good lord, select * from album_tracklen limit 10 takes a bit of time :P
2007-07-11 19257, 2007
FauxFaux
Yeah, views don't pre-calculate any data, that has to scan and filter the entirety of the track table. :p
2007-07-11 19217, 2007
aCiD2
ah... well it's gotta do select queries for the script anyway
2007-07-11 19220, 2007
aCiD2
so it might as well do it now!
2007-07-11 19225, 2007
aCiD2 goes to get some wheetabix
2007-07-11 19232, 2007
catgroove
ruaok: do you remember how you asked me for a redesign of the tagger image?
2007-07-11 19235, 2007
aCiD2
and faux, just open your db up! I wanna test my script :(
2007-07-11 19239, 2007
FauxFaux
aCiD2: Um.. views don't cache..
2007-07-11 19244, 2007
ruaok
the download image?
2007-07-11 19257, 2007
catgroove
that to
2007-07-11 19203, 2007
ruaok
aCiD2: do you need access to a DB?
2007-07-11 19206, 2007
catgroove
but the 'tagger' icon for picard
2007-07-11 19221, 2007
ruaok
ok...
2007-07-11 19238, 2007
ruaok
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.
2007-07-11 19251, 2007
ruaok
shit, picardqt doesn't belong to me at all.
2007-07-11 19257, 2007
catgroove
that is very true
2007-07-11 19210, 2007
ruaok
I did like your note graphics, though.
2007-07-11 19216, 2007
catgroove
.)
2007-07-11 19233, 2007
catgroove
i'd like somesort of enhancement on the bugtracker where eI could uploadthem
2007-07-11 19244, 2007
aCiD2
ruaok: yes, but with faux's custom table added
2007-07-11 19251, 2007
catgroove
so that if eventually they get used, the peron codignthem would kbow where to go
2007-07-11 19256, 2007
aCiD2
I have my own db, but I can' get his table to work
2007-07-11 19256, 2007
catgroove
*get them from
2007-07-11 19211, 2007
ruaok
catgroove: why not make them attachements to bug reports?
2007-07-11 19216, 2007
catgroove
yes
2007-07-11 19216, 2007
FauxFaux
Ping me, I'm going to go be all immature and shoot things.
2007-07-11 19221, 2007
catgroove
but I need a bugreport first!
2007-07-11 19222, 2007
catgroove
:)
2007-07-11 19231, 2007
ruaok
catgroove: then create one!
2007-07-11 19236, 2007
catgroove
or enhance,ment report
2007-07-11 19238, 2007
catgroove
ehh
2007-07-11 19250, 2007
ruaok
aCiD2: ping me if you need some access. I've got DBs coming out my arse
