#musicbrainz-devel

/

      • lozless
        yes

        • 2012-09-01 24519, 2012

      • alastairp
        OK, it's likely that it's a client thing then

        • 2012-09-01 24521, 2012

      • alastairp
        try

        • 2012-09-01 24529, 2012

      • alastairp
        SET CLIENT_ENCODING TO 'UTF8';

        • 2012-09-01 24532, 2012

      • alastairp
        then \copy again

        • 2012-09-01 24540, 2012

      • lozless
        ok that might have worked

        • 2012-09-01 24540, 2012

      • lozless
        the data is the table but i cant remeber if i already run the command in pgAdmin

        • 2012-09-01 24548, 2012

      • lozless
        you guys are really helpful

        • 2012-09-01 24503, 2012

      • lozless
        i will recreate the database and tell you how it goes

        • 2012-09-01 24504, 2012

      • lozless
        brb

        • 2012-09-01 24511, 2012

      • alastairp
        thanks

        • 2012-09-01 24512, 2012

      • alastairp
        good luck

        • 2012-09-01 24550, 2012

      • nikki_ joined the channel

        • 2012-09-01 24536, 2012

      • lozless
        yeah that set client_encoding worked thanks alastairp

        • 2012-09-01 24507, 2012

      • nikkimini joined the channel

        • 2012-09-01 24502, 2012

      • lozless
        i have a really stupid question

        • 2012-09-01 24518, 2012

      • lozless
        is the main schema called musicbrainz

        • 2012-09-01 24503, 2012

      • lozless
        CreateFunctions.sql asks for musicbrainz schema instead of public

        • 2012-09-01 24546, 2012

      • lozless
        is the cover art archive dump available?

        • 2012-09-01 24558, 2012

      • nikki
        yes (finally)

        • 2012-09-01 24523, 2012

      • nikki
        http://ftp.musicbrainz.org/pub/musicbrainz/data/f… there

        • 2012-09-01 24525, 2012

      • lozless
        mbdump-cover-art-archive.tar.bz2 is only 1.6mb

        • 2012-09-01 24541, 2012

      • nikki
        oh, if you want the images you'd need to download them using the data in that file

        • 2012-09-01 24519, 2012

      • lozless
        ok that is interesting

        • 2012-09-01 24502, 2012

      • lozless
        will the binary images be available as a dump?

        • 2012-09-01 24510, 2012

      • nikki
        I doubt it

        • 2012-09-01 24523, 2012

      • lozless
        that could take ages to download all the images

        • 2012-09-01 24535, 2012

      • nikki
        there's already around 34 gigs of images after just a few months, it wouldn't make much sense to try and make a single file containing them all because it'd end up being too big for anyone to realistically do anything with

        • 2012-09-01 24544, 2012

      • lozless
        yeah i understand

        • 2012-09-01 24503, 2012

      • lozless
        thats seems a rather large amount of images

        • 2012-09-01 24539, 2012

      • lozless
        im working for a company that uses music brainz data and i dont think their database is even that large

        • 2012-09-01 24506, 2012

      • ocharles
        oh good, the caa dump went out ok

        • 2012-09-01 24555, 2012

      • lozless
        yeah i noticed this new mbdump-cover-art-archive.tar.bz2 file

        • 2012-09-01 24507, 2012

      • nikki
        according to our stats, it's about 77k images across 41k releases

        • 2012-09-01 24509, 2012

      • nikki
        and we have 1,065,726 releases, so only another million releases to add covers for :P

        • 2012-09-01 24546, 2012

      • ocharles
        nikki, have you had a chance to play with that dump?

        • 2012-09-01 24555, 2012

      • lozless
        where do i find the url for the images?

        • 2012-09-01 24558, 2012

      • nikki
        yes. I had it downloaded within 5 minutes of it appearing :P

        • 2012-09-01 24506, 2012

      • ocharles
        :D

        • 2012-09-01 24507, 2012

      • nikki
        and I had the data imported shortly after that

        • 2012-09-01 24527, 2012

      • ocharles
        lozless: you query http://coverartarchive.org/release/{somereleasemb…

        • 2012-09-01 24530, 2012

      • nikki
        and now my database is up to date again... and immediately out of date again >_<

        • 2012-09-01 24544, 2012

      • lozless
        ok

        • 2012-09-01 24553, 2012

      • ocharles
        lozless: if you have the database, you can derive urls from that

        • 2012-09-01 24503, 2012

      • lozless
        which table?

        • 2012-09-01 24504, 2012

      • ocharles
        by joining cover_art_archive.cover_art with musicbrainz.release

        • 2012-09-01 24515, 2012

      • nikki
        if you have the image id (which you can get from that dump), http://coverartarchive.org/release/MBIDHERE/IDHER…

        • 2012-09-01 24531, 2012

      • ocharles
        the url is then 'http://coverartarchive.org/release/' || release.gid || '/' || cover_art.id || '.jpg'

        • 2012-09-01 24533, 2012

      • lozless
        im still importing the database

        • 2012-09-01 24526, 2012

      • lozless
        alastairp gave me some good advice on how to do it from psql command line

        • 2012-09-01 24537, 2012

      • lozless
        SET CLIENT_ENCODING TO 'UTF8'; is really important or \copy will fail

        • 2012-09-01 24508, 2012

      • lozless
        thanks for all your help... bye for now

        • 2012-09-01 24516, 2012

      • alastairp
        wow. android's voice recognition is pretty amazing

        • 2012-09-01 24529, 2012

      • alastairp
        http://support.google.com/android/bin/answer.py?h…

        • 2012-09-01 24554, 2012

      • nikki
        I hope it got better since the version I tried

        • 2012-09-01 24506, 2012

      • alastairp
        I changed it to NZ english and it's amazing

        • 2012-09-01 24536, 2012

      • warp
        ocharles: ack

        • 2012-09-01 24540, 2012

      • alastairp
        don't need to articluate very much

        • 2012-09-01 24546, 2012

      • alastairp
        just talk normally

        • 2012-09-01 24523, 2012

      • nikki
        heh, which is completely not the experience I had. it couldn't understand a thing I said

        • 2012-09-01 24503, 2012

      • ocharles
        warp: faaar too late, even if the servers were on fire still they'd be a smouldering heap now :P

        • 2012-09-01 24533, 2012

      • kepstin-laptop joined the channel

        • 2012-09-01 24544, 2012

      • nikki
        alastairp: I just said apple to the voice search on mine and it suggested father, set up, centre, set or saga. pineapple got me whenever, I never, I love them, phone ever or hello. raspberry got me formspring, first, fasting, fast or facebook

        • 2012-09-01 24554, 2012

      • nikki
        maybe it's biased against fruit...

        • 2012-09-01 24503, 2012

      • nikki
        apparently not. biased -> phone, burton, vans, I am, mail... vans -> download, down, download, brown, bone

        • 2012-09-01 24532, 2012

      • alastairp
        apple pineapple raspberry

        • 2012-09-01 24535, 2012

      • alastairp
        :)

        • 2012-09-01 24551, 2012

      • alastairp
        do you have a non-main demographic english accent?

        • 2012-09-01 24504, 2012

      • reosarevok
        alastairp: everyone in the UK has that :p

        • 2012-09-01 24511, 2012

      • reosarevok
        I mean, they have an accent per village

        • 2012-09-01 24515, 2012

      • alastairp
        yeah, true

        • 2012-09-01 24524, 2012

      • nikki
        I don't have an accent anyone can really place

        • 2012-09-01 24503, 2012

      • nikki
        I certainly don't pronounce "apple" like "father" :P

        • 2012-09-01 24523, 2012

      • nikki
        I have a bit more luck when I change it from uk english to german

        • 2012-09-01 24528, 2012

      • nikki
        apfel -> o2, hopferau, pizza, hofer, apfel... ananas -> engel, angel, angeln, chemnitz, angels... himbeere -> himbeeren, himbeere, himberg, finde, hilden... beeinflusst -> open source, rhodos, open source code, rovers, windows... wagen -> fragen, wacken, baden, wagen, magen... herunterladen -> herunterladen, runterladen, runter laden, herrunterladen, unterlagen

        • 2012-09-01 24513, 2012

      • lozless joined the channel

        • 2012-09-01 24528, 2012

      • bitmap
        heh, mine works really well too, even if I fake a bunch of weird accents it gets it right

        • 2012-09-01 24558, 2012

      • alastairp
        I suspect you fake your accents less well than you think you do :)

        • 2012-09-01 24510, 2012

      • nikki 's phone is kinda old now

        • 2012-09-01 24525, 2012

      • alastairp
        nikki: what version of android?

        • 2012-09-01 24553, 2012

      • alastairp
        I wonder how much of it is the software, and how much they send back to the server

        • 2012-09-01 24559, 2012

      • nikki
        2.3.4 apparently

        • 2012-09-01 24512, 2012

      • bitmap
        I do have to pronounce things a bit slower than I normally would :)

        • 2012-09-01 24521, 2012

      • alastairp
        nikki: right. I'm using 4

        • 2012-09-01 24535, 2012

      • nikki has fun getting it to recognise words in french

        • 2012-09-01 24555, 2012

      • nikki
        apparently my atrocious french pronunciation is better than my british english pronunciation, if you believe my phone :P

        • 2012-09-01 24501, 2012

      • alastairp
        yeah, I'd like to tell it "I speak english but sometimes need to speak french"

        • 2012-09-01 24516, 2012

      • alastairp
        I wonder how much work they need to do to make it differentiate language as well

        • 2012-09-01 24539, 2012

      • nikki
        normally I won't even attempt to pronounce french words, but hey, I'm alone right now :P

        • 2012-09-01 24555, 2012

      • alastairp
        :-P

        • 2012-09-01 24504, 2012

      • alastairp
        yeah, I would have, but somneone else has just come into the office

        • 2012-09-01 24525, 2012

      • alastairp
        cool, I just got one of http://www.daskeyboard.com/

        • 2012-09-01 24533, 2012

      • alastairp
        well, it's a workmates, but he's not here, so I stole it

        • 2012-09-01 24553, 2012

      • lozless
        does the musicbrainz database support different languages?

        • 2012-09-01 24504, 2012

      • alastairp
        lozless: well, it's all unicode

        • 2012-09-01 24516, 2012

      • alastairp
        so you can put any characters that are unicode into it

        • 2012-09-01 24528, 2012

      • reosarevok
        If you mean the site, then we're working on it

        • 2012-09-01 24532, 2012

      • lozless
        but what if i wanted track titles in another language?

        • 2012-09-01 24544, 2012

      • reosarevok
        Oh

        • 2012-09-01 24548, 2012

      • reosarevok
        In some cases, yes

        • 2012-09-01 24548, 2012

      • lozless
        should that be stored in the database?

        • 2012-09-01 24555, 2012

      • reosarevok
        But that's done manually

        • 2012-09-01 24558, 2012

      • lozless
        or converted on the request?

        • 2012-09-01 24530, 2012

      • lozless
        i guess there are some libraries which do language translation

        • 2012-09-01 24544, 2012

      • reosarevok
        Well, if you want kind of decent titles, then they should be done by people and stored - if anything goes you could use some machine translation and hope it makes sense

        • 2012-09-01 24559, 2012

      • lozless
        thats what people say

        • 2012-09-01 24503, 2012

      • alastairp
        lozless: for example, http://musicbrainz.org/release/2592c7ed-1412-4895…

        • 2012-09-01 24512, 2012

      • alastairp
        is a release in japanese

        • 2012-09-01 24513, 2012

      • lozless
        but noone has the time to translate every title

        • 2012-09-01 24547, 2012

      • reosarevok
        Certainly. Nor the interest, usually - I doubt most people actually want to have every title translated

        • 2012-09-01 24500, 2012

      • lozless
        some people might!

        • 2012-09-01 24515, 2012

      • lozless
        with the lyrics and such

        • 2012-09-01 24522, 2012

      • reosarevok
        Well, yeah

        • 2012-09-01 24539, 2012

      • reosarevok
        But for lyrics, machine translation will definitely be a mess :)

        • 2012-09-01 24546, 2012

      • lozless
        is anyone here a windows programmer??

        • 2012-09-01 24513, 2012

      • reosarevok
        (I use it once in a while for languages I half-speak, and even though it helps I often find mistakes...)

        • 2012-09-01 24519, 2012

      • lozless
        i trying to import the music brainz dump in windows

        • 2012-09-01 24536, 2012

      • lozless
        once in a while, i use it all the time

        • 2012-09-01 24550, 2012

      • lozless
        although i used linux to develop some uni projects

        • 2012-09-01 24518, 2012

      • lozless
        why is it all in linux??

        • 2012-09-01 24536, 2012

      • lozless
        .net is cool

        • 2012-09-01 24547, 2012

      • lozless
        i made some good programs with it

        • 2012-09-01 24553, 2012

      • alastairp
        .net didn't exist when musicbrainz was started

        • 2012-09-01 24503, 2012

      • lozless
        i guess when was that?

        • 2012-09-01 24526, 2012

      • alastairp
        late 90s?

        • 2012-09-01 24528, 2012

      • lozless
        i started programming in 1998

        • 2012-09-01 24544, 2012

      • lozless
        but noone told me about linux

        • 2012-09-01 24511, 2012

      • lozless
        with vb

        • 2012-09-01 24541, 2012

      • nikki (as always) did things in a weird way

        • 2012-09-01 24549, 2012

      • lozless
        so everyone here uses linux?

        • 2012-09-01 24502, 2012

      • lozless
        what type of linux are you all using?

        • 2012-09-01 24514, 2012

      • nikki
        I'm on a mac, but I spend so much time at a command line that I wouldn't know the difference

        • 2012-09-01 24531, 2012

      • lozless
        i like the command line

        • 2012-09-01 24500, 2012

      • lozless
        but sometimes with no help it gets so difficult

        • 2012-09-01 24503, 2012

      • warp
        ocharles: ok :)

        • 2012-09-01 24513, 2012

      • warp was out on a bicycle

        • 2012-09-01 24537, 2012

      • lozless
        ocharles: what language do you use?

        • 2012-09-01 24516, 2012

      • nikki
        oh, and 2000 - http://musicbrainz.org/doc/About

        • 2012-09-01 24546, 2012

      • lozless
        your such a nice community

        • 2012-09-01 24557, 2012

      • lozless
        but i feel left out being a windows user!

        • 2012-09-01 24544, 2012

      • warp
        ocharles: http://www.geocaching.com/seek/log.aspx?LUID=0d89…

        • 2012-09-01 24558, 2012

      • lozless
        what r geocoordinates?

        • 2012-09-01 24546, 2012

      • nikki
        warp: tftc?

        • 2012-09-01 24547, 2012

      • warp
        lozless: completely unrelated to musicbrainz :)

        • 2012-09-01 24554, 2012

      • warp
        nikki: "thanks for the cache"

        • 2012-09-01 24557, 2012

      • nikki
        ah

        • 2012-09-01 24512, 2012

      • lozless
        i know my employment asks about geo coordinates for music venues

        • 2012-09-01 24526, 2012

      • lozless
        i guess the lat/lon for google maps

        • 2012-09-01 24543, 2012

      • ijabz joined the channel

        • 2012-09-01 24548, 2012

      • warp
        lozless: yes, the location of something. not just for google maps.