#musicbrainz

no.

but if you're doing it as a free app, then you can freely replicate the DB on your own server.

ok that sounds good

it'll cost me but i'm willing to do that

ask for donations from end users to cover your costs.

sounds like a plan

i think what i'll do is

replicate the DB on our own server

route access through there

ask for dontains to cover the costs

and donate all excess donations to MB

inhouseuk: sadly true. but that was knowsn. digg/slashdotters are known to be CHEAP.

coz i really don't want this to be commercial

milosz: sounds like a great plan! thanks!

now "just" need set up MB server on our server o_O lol

then it'll take me 2 days

or a week

the slowest part is importing the data

inhouseuk: well, you can't expect that on the first day.

milosz: it really isn't hard to just set up the DB.

well it's just a pgsql database i guess so it shouldn't be too hard

inhouseuk: i was using musicbrainz for months before I decided that, "Hey! this is really useful, perhaps I should donate". probably triggered by the nag screen in the tagger at the time.

:)

milosz: the pgsql is fine, the perl.. not so much

warp: I think you have that backwards

warp: I'm constantly annoyed by the opposite, mysql supports fuck all basically

pgsql is also more a true relational database

on delete fuck all cascade

lol

I'm ported my current pet project from mysql to postgres last sunday, because mysql or the python module for it couldn't the encoding of a query right.

LotR, Wizzcat: in my security design, I made use of column level security. mysql supports that, postgresql doesn't. I will have to split up the user table into two seperate tables.

i get to use mysql a lot at work. it's probably good that I get some postgresql experience now.

at my previous workplace i used to write a lot of pgsql stuff

recently i've been doing more with mysql but can't say it's been the primary focus

actually needed show processlist and killing a few slow queries to calm down a thrashing server.

fun :)

I still have nightmares about some of the mysql queries I've done, hand-optimizing for hours because the query engine can't do it's damn job

*its

the pg one isn't always perfect either

:)

milosz: ONLY musicbrainz2.webservice.Query calls are WS queries

milosz: and other method call is just local

milosz: in many cases you can also use Includes to avoid multiple queries

hmmm i thought that getTarget() does a WS call

you can enable standard Python logging for all loggers to see what hits the WS

also there are still some bugs in the pymb2 code

but i shuldn't say that as i promised a patch a while ago

are they reported on bugs.mb.org?

no not yet :(

or i think some are

then they don't exist! :p

:))

ow ok

I have a live album that has "/ Live" suffixing the name - do I add it as that or as "(live)"?

workaphobia: either literally "Lil' Tae Rides Again / Live" or "Lil' Tae Rides Again: Live" if you consider it a subtitle

or just leave it out :)

warp: there's at least two pg projects that do complex column-level/row-level access (i think)

warp: anyway, you could do something simple yourself, some triggers and select rules

warp: you can also use a view

*copies data from discogs again*

warp: if you wanna have fun, http://veil.projects.postgresql.org/curdocs/ and http://code.google.com/p/sepgsql/

Thanks luks, keeping it "/ Live"

xlotlu: oh?

xlotlu: ah, thanks for the link. i'll have a look.

anyone in here use mp3fs?

(I forgot who it was that pointed me to it in the first place)

I used it once

is there an echo in this IRC?

no

liar

14:19 < alastairp> http://mp3fs.sourceforge.net/

says grep mp3fs \#musicbrainz.log :)

but alastairp isn't in here :/

so

still looking for someone using mp3fs :)

emphasis on the /using/

I've heard of it!

I've never heard of it!

Assuming it's fuse.

fuse-based, it is

but... I still need someone who's /using/ it :/

luks:like your discogs import script, any chance of it being added to mbsite, I can't see any limits on the discogs site on use of their webservice data

ruaok: http://lists.musicbrainz.org/pipermail/musicbra...

I have a little script which is querying the xml feed, but I would like to reduce impact on the main server, so I'm wondering if the 2007.04.01 edition of the vmware image is infact the latest

alastair_ is now known as alastairp

Vlet: 2007-04-10 is not the latest.

but you can use that and upgrade to the latest.