hello, i have a DB question, downloaded and setup a offline postgres db, everything seems to be fine but the views are empty, i followed the instructions but what could i have done wrong
2009-03-13 07233, 2009
Maty
i can query and get data from the tables individually or combining them but just the views are empty
2009-03-13 07223, 2009
Maty
im somewhat new to postgre though
2009-03-13 07240, 2009
Maty
hello
2009-03-13 07259, 2009
joko has quit
2009-03-13 07230, 2009
liDEL has quit
2009-03-13 07254, 2009
liDEL joined the channel
2009-03-13 07202, 2009
drsaunde has quit
2009-03-13 07220, 2009
MightyJay has quit
2009-03-13 07204, 2009
voiceinsideyou joined the channel
2009-03-13 07245, 2009
Kerensky97 joined the channel
2009-03-13 07222, 2009
warp has quit
2009-03-13 07206, 2009
warp joined the channel
2009-03-13 07223, 2009
futilius has quit
2009-03-13 07226, 2009
futilius joined the channel
2009-03-13 07232, 2009
Sargun joined the channel
2009-03-13 07221, 2009
xlotlu has quit
2009-03-13 07210, 2009
voiceinsideyou has quit
2009-03-13 07251, 2009
Maty
anybody home ?
2009-03-13 07222, 2009
nikki
me
2009-03-13 07243, 2009
Maty
can you answer my question
2009-03-13 07250, 2009
nikki
I don't know the answer, so no
2009-03-13 07224, 2009
Maty
ok thanks
2009-03-13 07206, 2009
Maty
oh by the way do you know to get just the english artist names by doing a query ?
2009-03-13 07248, 2009
nikki
how exactly do you mean?
2009-03-13 07225, 2009
Maty
you know like there are japanese artists etc, so i want names that are only in english
2009-03-13 07225, 2009
nikki
hm... not very easily I guess, we don't store enough information about artist names really :/
2009-03-13 07230, 2009
nikki
what do you need them for?
2009-03-13 07224, 2009
Maty
so that people can search for names in a text box and get artist details but not for like japanese names etc even though there is a enlish sort order
2009-03-13 07257, 2009
nikki
ah, there's no way I know of to do that :/
2009-03-13 07222, 2009
Clint
are the "english" names listed as aliases?
2009-03-13 07256, 2009
Maty
well its however its in the MB db, i am just trying to get the artist names
2009-03-13 07237, 2009
Maty
got freedb too but that would take like a million years to process
2009-03-13 07256, 2009
Maty
plus the same problem of the jap/chi names
2009-03-13 07200, 2009
nikki
well I can make a list of only latin script names if that's what you want
2009-03-13 07253, 2009
Maty
does that mean enlish letters ? if so yeah that would do it
2009-03-13 07242, 2009
Kerensky97 has quit
2009-03-13 07200, 2009
nikki
do you need anything other than the names? like the artist id or anything?
2009-03-13 07231, 2009
Maty
yeah the artist id, coz ill be making some other tables and attaching stuff to them
also is there a script i can use ? if i need modify stuff
2009-03-13 07257, 2009
Maty
hmm wiered, downloading a 1.30gb file using download accelarator, its at 0 seconds left and downloaded 1.31 and still going
2009-03-13 07219, 2009
Jormangeud^ joined the channel
2009-03-13 07221, 2009
brianfreud
hmm, nikki, 2.19 M/s down from you
2009-03-13 07244, 2009
Jormangeud has quit
2009-03-13 07244, 2009
Jormangeud^
Jormangeud^ is now known as Jormangeud
2009-03-13 07251, 2009
brianfreud
ok, I just am realizing that BMPx is a dead project, and its replacement also seems a dead project.
2009-03-13 07227, 2009
brianfreud
So, not to start a religeous argument, but I'm looking for a new tagger, pref with podcast, PUID, and decent ID3/vorbis tags support
2009-03-13 07250, 2009
brianfreud
Looks like it's down to foobar2000 or Amarok? (never really used either before) Anyone have any suggestions?
2009-03-13 07257, 2009
nikki
tagger?
2009-03-13 07200, 2009
alastair1
*cough*xmms*cough*
2009-03-13 07206, 2009
nikki likes quod libet
2009-03-13 07219, 2009
nikki
and I should hope you get fast speeds from that server :P
2009-03-13 07225, 2009
brianfreud
I thought xmms was dead too?
2009-03-13 07238, 2009
nikki
xmms2 isn't afaik
2009-03-13 07233, 2009
brianfreud looks at both
2009-03-13 07234, 2009
alastair1
but that's going in the wrong direction as well, imo
2009-03-13 07248, 2009
brianfreud
either quod libet or xmms natively support mbids and/or puids?
2009-03-13 07224, 2009
alastair1
in what way?
2009-03-13 07234, 2009
brianfreud
O_o regexp-based music finding??? <3
2009-03-13 07221, 2009
brianfreud
tbh, I'd be happy to stay with bmpx, except I'm just really annoyed that it can't enque a directory and actually play it in anything like correct order
2009-03-13 07220, 2009
Maty
nikki thanks for the file again
2009-03-13 07237, 2009
nikki
no problem :)
2009-03-13 07255, 2009
Maty
later
2009-03-13 07211, 2009
Maty
have a good day evening guys :)
2009-03-13 07215, 2009
Maty has quit
2009-03-13 07258, 2009
alastair1
brianfreud: heh, yeah
2009-03-13 07208, 2009
alastair1
uses disk order rather than file order :)
2009-03-13 07221, 2009
alastair1
that goes all the way back to xmms
2009-03-13 07222, 2009
brianfreud
well, it's the one "must have" feature I want
2009-03-13 07245, 2009
brianfreud
and you cannot even sort, to fix it after queuing... makes me nuts when listening to bootlegs to hear the shows out of concert order
2009-03-13 07204, 2009
srotta
So are you looking for a player or a tagger?
2009-03-13 07256, 2009
czaanja joined the channel
2009-03-13 07235, 2009
brianfreud
a player
2009-03-13 07243, 2009
brianfreud
Trying quod libit, and liking it, a lot
2009-03-13 07213, 2009
czaanja has quit
2009-03-13 07206, 2009
futilius has quit
2009-03-13 07228, 2009
Tykling joined the channel
2009-03-13 07232, 2009
outsidecontext joined the channel
2009-03-13 07234, 2009
Munger
I wish Artist lookups used soundex matching. Easy to accidentally ad duplicate artists if the name is not a precise match
2009-03-13 07223, 2009
luks
there are much better ways to do fuzzy search
2009-03-13 07226, 2009
Munger
Apparently none good enough to have been implemented though
2009-03-13 07209, 2009
Muz
Eh?
2009-03-13 07222, 2009
Muz
Perhaps it's the usual case of "bigger fish to fry, and not enough developers"?
2009-03-13 07233, 2009
Muz
Not a case of the technologies not being good enough.
2009-03-13 07238, 2009
Muz shrugs and goes to work.
2009-03-13 07208, 2009
warp
luks: hmm, a summer of code idea? :)
2009-03-13 07202, 2009
luks
to write a search engine or a custom postgresql index type? I don't think so :)
