FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › Add-on Software › FirePlay Flash client for FireFly
- This topic has 873 replies, 99 voices, and was last updated 13 years, 11 months ago by beaon.
-
AuthorPosts
-
15/11/2007 at 12:23 AM #13371sonichouseParticipant
@Bo Mellberg wrote:
OK. Here we go again:
http://www.mellberg.org/FlashDAAP.swf
Right-click etc…
Good night! (1.14 am)
/Bo
Still kills 1696 here ๐
Have a good night/Steve
15/11/2007 at 7:46 AM #13372Bo MellbergParticipantI got some answers from Ron which has led me to rewrite once again, this time for rsp protocol. It turns out that the daap protocol does not support querys on playlist level, so it really is a must to move to rsp.
I’m still waiting for the document on rsp, which I accidently deleted from my inbox, so I’ll have a new version soon.
According to Ron it would be 2-3 times faster as well ๐
/Bo
15/11/2007 at 8:13 AM #13373fizzeParticipant@sonichouse wrote:
@Bo Mellberg wrote:
But it works in “playlist.html” so let’s look in the source for that?
o umlaut is hex C3B6 in the database so the query is ‘daap.songartist:Bj%C3%B6rk’
the SQL used was
bash-3.2# sqlite3 /opt/var/mt-daapd/songs3.db
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> select distinct(hex(distinct(artist))) from songs where artist like 'Bj%';
426AC3B6726B
sqlite> .quit
Just on a sidenote, the SQL query isnt the same as the playlist.html query.
...where artist like 'Bj%';
really shows all songs by all artists that start with “Bj”. Results may not matter much, but a “like” certainly is less performant than an exact match.
15/11/2007 at 8:25 AM #13374Bo MellbergParticipantYou don’t happen to have the document on rsp queries?
15/11/2007 at 8:26 AM #13375sonichouseParticipantHi Fizze,
thanks for that. I wrote the sql using the like predicate because I couldn’t get the รยถ to work in the query for some reason, and I knew that she was the only artist in my collection starting with ‘Bj’.
But yes, I accept the like clause will create more work for the database.
/Steve
15/11/2007 at 9:53 AM #13376Bo MellbergParticipantI got the queries working. This new (0.4) version uses rsp and is still crippled compared to the 0.2 version. Basic functionality though.
http://www.mellberg.org/FlashDAAP.swf <- right-click yada yada…
15/11/2007 at 10:01 AM #13377sonichouseParticipant๐ yes, it works – great stuff 8)
15/11/2007 at 10:09 AM #13378sonichouseParticipantHi Bo,
might be asking too much here, my PSP connects, but never retrieves the library listing.
I think the PSP is limited to Flash Player 6.
Is this a no go ?
15/11/2007 at 10:28 AM #13379Bo MellbergParticipantPlease download it again and try. I published it using Flash 6 and it didn’t complain so perhaps it works. It still works for me, so I can live with Flash 6…
15/11/2007 at 12:10 PM #13380AnonymousInactiveSince my last post I wiped SUSE off my server, installed Ubuntu Server and all the software I use plus Firefly and this thing worked right away ๐
SUSE will never darken my door again!
Plus, the library loaded in no time at all – I guess compression wasn’t working on the version I was using before.
Great work Bo!
Any chance of a search and custom playlist?
-
AuthorPosts
- The forum ‘Add-on Software’ is closed to new topics and replies.