how is 'adding a tag' not a change to the data, thus an edit?
2008-06-26 17849, 2008
drsaunde
ijabz: I'm just speculating here, but server time is prioritized to members vs browsers and some data (beyond just editing) that may require more server time requires being logged in
2008-06-26 17839, 2008
Muz
Moose.
2008-06-26 17848, 2008
ijabz
lotr:i think youre right, its proabably a side effect of view edit information
2008-06-26 17848, 2008
ijabz
if thats the case it doesnt matter
2008-06-26 17828, 2008
warp
sounds plausible, yeah :)
2008-06-26 17805, 2008
ijabz
There no way (either ui or websrrvice) for me to get ALL my tags is there ?
2008-06-26 17823, 2008
nikki
no
2008-06-26 17849, 2008
ijabz
I couldnt find a ticket for this either so i'll raise one
nikkii:thx just found same one, but need seperate one for webservice
2008-06-26 17847, 2008
nikki
could just add a comment to that one
2008-06-26 17808, 2008
nikki
it's not like the exact implementation of that one has been decided ;)
2008-06-26 17839, 2008
niklas_ joined the channel
2008-06-26 17812, 2008
stochasticism joined the channel
2008-06-26 17825, 2008
xlotlu
unfortunately the puid removal page needs both the track row id, and the join id..
2008-06-26 17801, 2008
xlotlu
which means i couldn't use the webservice in my crap puid removal userscript
2008-06-26 17808, 2008
Wizzcat
I wasn't actually intending to include removal, otherwise people might go nuts and remove puids they shouldn't be removing
2008-06-26 17849, 2008
Wizzcat
just want an easy way to check a release whether there are any suspicious puids without having to open 50 tabs and checking everything manually
2008-06-26 17832, 2008
xlotlu
how can you tell a puid is "suspicious"? :)
2008-06-26 17824, 2008
stochasticism has quit
2008-06-26 17825, 2008
Wizzcat
comparing length and titles of tracks it's attached to
2008-06-26 17814, 2008
duckman has quit
2008-06-26 17824, 2008
Muz
Wizzcat, there's a track ticket to build a report on that heh
2008-06-26 17845, 2008
xlotlu
umm, i fail to see how the webservice is helping you
2008-06-26 17810, 2008
Wizzcat
I pull the info on every track of a release, then pull every puid attached to those tracks, work some magic, spit out information whether a puid should be looked at or not
2008-06-26 17816, 2008
xlotlu
you're fetching all the tracks fromt the release, then all puids for these tracks, and
2008-06-26 17822, 2008
xlotlu
[...} yeah
2008-06-26 17844, 2008
Wizzcat
I was worried I couldn't do it with the webservice, which would mean an awful lot of scraping (which I hate)
2008-06-26 17847, 2008
xlotlu
that's a lot of hitting the WS
2008-06-26 17806, 2008
Wizzcat
you'd rather people manually opened fifty seperate puid pages per release?
2008-06-26 17809, 2008
xlotlu
better get the db and run a query against it :)
2008-06-26 17845, 2008
xlotlu
Wizzcat: but that *is* what you are doing
2008-06-26 17802, 2008
xlotlu
granted you have it automated, and use a low-bandwith version of it...
2008-06-26 17822, 2008
Wizzcat
if an xml query takes as much resources as a full html query then something is wrong
2008-06-26 17842, 2008
Wizzcat
it's beside the point anyway, I want a way to do this relatively automatically
2008-06-26 17853, 2008
Wizzcat
human resources are more valuable than computer resources
2008-06-26 17841, 2008
xlotlu
fastes, cheapest, most automated way would be querying the db directly
2008-06-26 17844, 2008
nikki
the webservices are there to be used...
2008-06-26 17836, 2008
Wizzcat
sure xlotlu, but I'm not a perl dev
2008-06-26 17841, 2008
Wizzcat
I work with what I have
2008-06-26 17813, 2008
Wizzcat
now if someone were to implement bulk xml requests...
2008-06-26 17813, 2008
xlotlu
Wizzcat: as in, sql in your language of choice
2008-06-26 17810, 2008
xlotlu
something like a "multi-part xml" wouldn't matter much, just less http requests
2008-06-26 17830, 2008
Wizzcat
true
2008-06-26 17833, 2008
xlotlu
something like a generic way to specify your query though...
2008-06-26 17814, 2008
Wizzcat
how would I go about making direct queries without jumping through a ton of hoops though?
2008-06-26 17832, 2008
Muz
Running a local replicated copy of the DB
2008-06-26 17834, 2008
xlotlu
select puids that are attached to tracks that are attached to this release is 1 query instead of 50...
2008-06-26 17802, 2008
xlotlu
or having Muz set up a pg-admin using a pg account that only has read rights :)
2008-06-26 17813, 2008
Muz
Errrm, why me?
2008-06-26 17816, 2008
Muz cries
2008-06-26 17845, 2008
Muz
Also, I fucking abhor pg_admin. Use the damn terminal
2008-06-26 17810, 2008
Muz
*phpPgAdmin
2008-06-26 17815, 2008
Wizzcat
sure xlotlu, I'm more than proficient in sql, I'm just saying there's no public interface for db access so how exactly would I do it without writing a perl interface of my own and commiting it?
2008-06-26 17824, 2008
nikki
haha, I actually had to think about what you meant by pg-admin there, been so long since I last used it
2008-06-26 17835, 2008
Wizzcat hates pg-admin with a vengeance
2008-06-26 17808, 2008
Muz hates perl too
2008-06-26 17808, 2008
xlotlu
yeah, i meant phppgadmin
2008-06-26 17814, 2008
Muz
PHP is love though
2008-06-26 17820, 2008
nikki
php is shit
2008-06-26 17822, 2008
Muz
LIES!
2008-06-26 17826, 2008
Muz
Blasphemer!
2008-06-26 17829, 2008
xlotlu
pgadmin is pretty handy though (sometimes)
2008-06-26 17836, 2008
Muz whispers "pony power" three times in front of a mirror to summon FauxFaux
2008-06-26 17855, 2008
Wizzcat
phppgadmin, pg-admin, is tehre a difference?
2008-06-26 17823, 2008
luks
pgAdmin is a local application
2008-06-26 17835, 2008
xlotlu
Wizzcat: importing the db is just a one-time thing.. and then you just run some perl scripts that you don't care about for replication
2008-06-26 17835, 2008
Wizzcat
ah right, it's usually phppgadmin I'm using
2008-06-26 17849, 2008
Muz
Or set them to cron
2008-06-26 17856, 2008
Muz
and it's a bash script, a single one at that
2008-06-26 17836, 2008
Wizzcat
local db copy? bah, too much work
2008-06-26 17838, 2008
xlotlu
ok, rephrase that: a bash script that runs some perl you don't care about :P
2008-06-26 17852, 2008
Muz
:P
2008-06-26 17830, 2008
Muz
The day I can get more hdd space on my server, I may open up a read only phpPgAdmin instance on the musicbrainz DB
2008-06-26 17837, 2008
Muz
That also relies on me having time
2008-06-26 17822, 2008
xlotlu
Muz: just open up the postgresql port and make a public read-only user :)
2008-06-26 17850, 2008
Muz
Hmmm, or that
2008-06-26 17852, 2008
xlotlu
bash scripting + psql ftw
2008-06-26 17836, 2008
Muz
Anyhow, that'd need me to pester the guy who has physical access to the server and he's at Glastonbury so it won't happen any time soon
2008-06-26 17811, 2008
xlotlu
physical access? o.O
2008-06-26 17831, 2008
Wizzcat
how big is the mbz database anyway?
2008-06-26 17840, 2008
luks
xlotlu: how else do you want to open a closed port?
2008-06-26 17801, 2008
Muz
xlotlu, as opposed to me who only has ssh access
2008-06-26 17813, 2008
xlotlu
:))) yeah, tell him to get the port opening wrench
2008-06-26 17807, 2008
xlotlu
Wizzcat: 15GB if you get the useless moderation
2008-06-26 17817, 2008
Wizzcat
yikes
2008-06-26 17826, 2008
Muz
About 9/10GB without heh
2008-06-26 17832, 2008
Wizzcat
how are you supposed to keep it up to date?
2008-06-26 17840, 2008
xlotlu
i want replicated moderation :\
2008-06-26 17813, 2008
xlotlu
Wizzcat: a cron job with an already-provided script
2008-06-26 17856, 2008
Wizzcat
I meant more along the lines of pulling 10gigs of data every update?
2008-06-26 17807, 2008
xlotlu
errm no
2008-06-26 17825, 2008
xlotlu
it pulls several KBs of data every hour
2008-06-26 17837, 2008
Muz
You get sent replication packets which are only a few Kb an hour and it updates/inserts the rows needed
2008-06-26 17847, 2008
Wizzcat
ah ok, it has proper synchronization
2008-06-26 17851, 2008
Muz
Yes
2008-06-26 17847, 2008
xlotlu
<nikki> the webservices are there to be used... <-- now.. this roughly translates into "the dabase is there to be used"
2008-06-26 17818, 2008
xlotlu
why wouldn't MB provide access to the db directly?
2008-06-26 17838, 2008
Muz
I assume that there's a level of caching with the webservice via memcache and item objects
2008-06-26 17842, 2008
nikki
because then you have to make sure nobody goes drop table blah... :P
2008-06-26 17845, 2008
Muz
Unless of course it just directly queries the database
2008-06-26 17859, 2008
xlotlu
nikki: postgresql has ACLs :P
2008-06-26 17800, 2008
Muz
WS also provide a security layer and control over what info can and can't be accessed
2008-06-26 17804, 2008
LotR
nikki: uh, most databases do have access control :)
2008-06-26 17814, 2008
xlotlu
Muz: postgresql has ACLs :P
2008-06-26 17816, 2008
Muz
Also, easier integration with other web apps and services
2008-06-26 17816, 2008
nikki
sooo?
2008-06-26 17842, 2008
LotR
nikki: so, you wouldn't give out drop table permissions.
2008-06-26 17846, 2008
xlotlu
so, public user has read access to most tables, nothing more. no access to user tables. etc...
2008-06-26 17804, 2008
luks
like passwords, etc.?
2008-06-26 17813, 2008
luks
er, misread the last line
2008-06-26 17813, 2008
Muz
You also don't get people trying to authenticate as other users via ws
2008-06-26 17822, 2008
Wizzcat
you'd still need a way of preventing users from making evil 2h queries
2008-06-26 17842, 2008
Muz
WS just provide an extra level of security and control, whilst maintaining full accessibility to the data you want to be made accessible
2008-06-26 17844, 2008
Wizzcat
or I guess maybe you could just limit query runtime to 0.2s or something, nm
2008-06-26 17846, 2008
xlotlu
i certainly wouldn't want anybody reading the hash of my overly convoluted password..
2008-06-26 17813, 2008
luks
xlotlu: worse, it's plaintext :)
2008-06-26 17838, 2008
xlotlu
luks: then look up my password and have fun :)
2008-06-26 17802, 2008
xlotlu
luks: does the WS do any kind of caching, or simply hits the db?
2008-06-26 17815, 2008
luks
everything except tracks are cached
2008-06-26 17828, 2008
luks
and for search queries it hits lucene, not the DB
2008-06-26 17829, 2008
xlotlu
umm, then it's not an option
2008-06-26 17828, 2008
xlotlu
we'll have to wait for Muz to let us kill his server :)
2008-06-26 17810, 2008
Muz
That was a "may"
2008-06-26 17836, 2008
LotR
the waiting could be indefinite :)
2008-06-26 17849, 2008
LotR
you'd be the new godot!
2008-06-26 17813, 2008
Muz
Heh
2008-06-26 17844, 2008
stochasticism joined the channel
2008-06-26 17839, 2008
duckman joined the channel
2008-06-26 17819, 2008
stochasticism has quit
2008-06-26 17813, 2008
duckman has quit
2008-06-26 17839, 2008
nxmehta joined the channel
2008-06-26 17818, 2008
Muz
How is it the majority of mailing lists I participate in and then the thread I post on descend into silliness
2008-06-26 17827, 2008
Tykling joined the channel
2008-06-26 17839, 2008
LotR
Muz: too many moose mentions?
2008-06-26 17848, 2008
Muz
Needs more moose.
2008-06-26 17835, 2008
pbryan has quit
2008-06-26 17837, 2008
Knio1 joined the channel
2008-06-26 17817, 2008
pbryan joined the channel
2008-06-26 17839, 2008
Sargun joined the channel
2008-06-26 17810, 2008
Knio has quit
2008-06-26 17810, 2008
Knio1
Knio1 is now known as Knio
2008-06-26 17843, 2008
Kerensky97 joined the channel
2008-06-26 17822, 2008
Freso has quit
2008-06-26 17849, 2008
stochasticism joined the channel
2008-06-26 17835, 2008
niklas_ has gotten stuck on a join query
2008-06-26 17805, 2008
niklas_
Im trying to select the releases(from the album table) there are in a collection(collection_info)
