Home of the Squeezebox™ & Transporter® network music players.
Page 3 of 25 FirstFirst 1234513 ... LastLast
Results 21 to 30 of 241
  1. #21
    Senior Member lrossouw's Avatar
    Join Date
    Jan 2006
    Location
    Cape Town, South Africa
    Posts
    1,034
    Quote Originally Posted by mherger View Post

    > I don't quite see the purpose of the library view. Explain how this
    > setting might be used.


    I don't want kids music in my office. Therefore I'll use the "no kids
    music" view as the default.
    I guess part of it is the browsing (you won't see kids music when browsing), though to me this is not as interesting as filtering out kid's music, books, talks etc. when playing from shuffle, random play, smartmix or similar.

    Can the views be defined on volatile items such as play count or rating from trackstat. These may change between scans? You mentioned that the views are applied at scan time?

    I might have an unlistened to music view. Or a >3 star rating view. Or a not recently played view?

    This should provide for an improvement on erland's custom skip plugin also?
    Louis
    Last.fm

  2. #22
    Senior Member bonze's Avatar
    Join Date
    Jun 2006
    Location
    Bucks. UK
    Posts
    1,499
    OK - running on WHS 2011, v7.9.0, 1402499458
    It just stops with nothing in the server.log

    I tried running in "Safe Mode", but not sure what to make of the info in the log file.

    There are two oddities though:

    Slim::Utils::PluginManager::_parseInstallManifest (744) plugin ACLFiletest incompatible with system - disabling
    Slim::Utils::PluginManager::_parseInstallManifest (752) ACLFiletest [Slim::Plugin::ACLFiletest::Plugin] INSTALLERROR_INCOMPATIBLE_PLATFORM

    and

    Warning: [09:40:15.2524] DBIx::Class::Row::throw_exception(): Can't locate Slim/Schema/LibraryTrack.pm in @INC (@INC contains: C:\ProgramData\Squeezebox\Cache\InstalledPlugins C:\PROGRA~2\SQUEEZ~1\server\CPAN\arch\5.14\MSWin32-x86-multi-thread C:\PROGRA~2\SQUEEZ~1\server\CPAN\arch\5.14\MSWin32-x86-multi-thread\auto C:\PROGRA~2\SQUEEZ~1\server\CPAN\arch\5.14.1\MSWin 32-x86-multi-thread C:\PROGRA~2\SQUEEZ~1\server\CPAN\arch\5.14.1\MSWin 32-x86-multi-thread\auto C:\PROGRA~2\SQUEEZ~1\server\CPAN\arch\5.14\MSWin32-x86-multi-thread C:\PROGRA~2\SQUEEZ~1\server\CPAN\arch\5.14\MSWin32-x86-multi-thread\auto C:\PROGRA~2\SQUEEZ~1\server\CPAN\arch\MSWin32-x86-multi-thread C:\PROGRA~2\SQUEEZ~1\server\CPAN\arch\5.14 C:\PROGRA~2\SQUEEZ~1\server\lib C:\PROGRA~2\SQUEEZ~1\server\CPAN C:/PROGRA~2/SQUEEZ~1/server C:/PROGRA~2/SQUEEZ~1/server C:\Users\ADMINI~1\AppData\Local\Temp\2\pdk-Administrator-2872\ C:\PROGRA~2\SQUEEZ~1\server) at /<C:\PROGRA~2\SQUEEZ~1\server\SQUEEZ~3.EXE>Class/C3/Componentised.pm line 128.

    Gone back to 7.9.0-1402412502.exe
    LMS Version: 7.9
    TranquilPC T2-WHS-A3 - WHS 2011
    2x Touch, 3x SB3

  3. #23
    Senior Member
    Join Date
    Dec 2008
    Posts
    276
    Quote Originally Posted by mherger View Post
    > Will this conflict with Erlands multi library plugin if we already have
    > that installed with 7.9?


    I don't think so. Unless you install a plugin making use of those new
    features there should be no change in behaviour at all. It's totally
    optional. Most of what I implemented was suggested by Erland (thanks!).
    I'm pretty sure he'd let me know quickly if I messed up his plugins.

    I'd rather expect him to take advantage of these changes. He's asked me
    to do them for good reason I must assume ;-).

    > Is it meant to be a replacement, or work with it.


    The changes I committed really are mostly "infrastructure": they allow a
    plugin to define custom views. They allow LMS users having such a plugin
    to get a filtered view on their music library. But (besides the demo
    plugin implementation) they don't implement any virtual library view.
    It'll be up to a plugin developer to make best use of this feature. Thus
    it's not a replacement, but it'll allow to better (and simpler)
    integrate such a plugin with LMS.

    --

    Michael
    Ok great, thanks for the detailed response; understood, regards

  4. #24
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,300

    Multi Library support in LMS 7.9

    > I guess part of it is the browsing (you won't see kids music when
    > browsing), though to me this is not as interesting as filtering out
    > kid's music, books, talks etc. when playing from shuffle, random play,


    Shuffle/random play should already respect the library setting.

    > smartmix or similar.


    There's work left to do :-).

    > Can the views be defined on volatile items such as play count or rating
    > from trackstat. These may change between scans? You mentioned that the
    > views are applied at scan time?


    By default yes, they're part of the scan. But nothing prevents a plugin
    developer from triggering it on other occasions, schedule updates etc.
    The three demo configurations take a fraction of a second to complete on
    a library with a few thousand tracks. Depending on the complexity of
    what you'd like to do a regular update might be absolutely feasible.

    --

    Michael

  5. #25
    Senior Member get.amped's Avatar
    Join Date
    Feb 2007
    Location
    Upstate NY
    Posts
    788
    Quote Originally Posted by mherger View Post
    > Agreed. I have no issues writing SQL (assuming I understand the schema),
    > but that will definitely not be the case for most users.


    Get some sqlite client and start playing around with library.db: the
    library filtering is based on the tracks table. Genres will be tricky,
    as the IDs can change during scans. But its feasible with an additional
    relation to the genres table. Once you've got a good query, please feel
    free to send it to me and I'll be playing with it.

    Please note that the query is run at scan time. Thus even if the query
    does take a few seconds to complete that shouldn't hurt usability in
    daily use.

    --

    Michael
    I've been using SQLite Expert to chase down some tagging consistency issues. OCD enabler?

    I'll put together some queries that would result in only FLAC, non-Classical, non-Pop + whatever else it takes to pare things down to less than 100K tracks. Even though the filtering is based on tracks, joining with the genres table should not be an issue?
    Home: Win7Pro(x64)[3.3Ghz i5, 8GB RAM, 120GB SSD system, 15TB storage], LMS 7.9.0 -> Logitech Squeezebox Classic V.3 -> Cambridge Audio DacMagic -> NAD C160 -> 2 x NAD C272 -> Quad 22L2
    Portable: FreeNAS 9.3 [HP Microserver Gen8, 10GB RAM, 16GB flash boot, 120GB SSD for LMS 7.9.0 in FreeBSD jail, 5 x 4TB WD Red HD ZFS RAIDZ1] -> Logitech Squeezebox Classic V.3 -> Cambridge Audio DacMagic: XLR out -> Soundmaster Diamond 12-2 mixing board -> P.A.

  6. #26
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,300

    Multi Library support in LMS 7.9

    > I've been using SQLite Expert to chase down some tagging consistency
    > issues. OCD enabler?


    OCD enabler? http://de.pinterest.com/dkniep/ocd-enabler/ ?

    > I'll put together some queries that would result in only FLAC,
    > non-Classical, non-Pop + whatever else it takes to pare things down to
    > less than 100K tracks. Even though the filtering is based on tracks,
    > joining with the genres table should not be an issue?


    The problem is that the track -> genre mapping is based on a genre_id
    which changes during scan. You'll therefore have to have some sub-select
    to get the ids based on the genre names you provide. It's probably not
    an issue if you speak SQL fluently :-).

    --

    Michael

  7. #27
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,300

    Multi Library support in LMS 7.9

    > OK - running on WHS 2011, v7.9.0, 1402499458
    > It just stops with nothing in the server.log


    Could you please give the latest build another try? Should be fixed now.
    Thanks!

    --

    Michael

  8. #28
    Senior Member get.amped's Avatar
    Join Date
    Feb 2007
    Location
    Upstate NY
    Posts
    788
    Quote Originally Posted by mherger View Post
    > I've been using SQLite Expert to chase down some tagging consistency
    > issues. OCD enabler?


    OCD enabler? http://de.pinterest.com/dkniep/ocd-enabler/ ?

    > I'll put together some queries that would result in only FLAC,
    > non-Classical, non-Pop + whatever else it takes to pare things down to
    > less than 100K tracks. Even though the filtering is based on tracks,
    > joining with the genres table should not be an issue?


    The problem is that the track -> genre mapping is based on a genre_id
    which changes during scan. You'll therefore have to have some sub-select
    to get the ids based on the genre names you provide. It's probably not
    an issue if you speak SQL fluently :-).

    --

    Michael
    Well I did a couple of queries to get some idea just what would fit in 100K tracks. This one just gives me a count of tracks by genre for lossless (FLAC) only:

    SELECT
    ge.namesearch, count (tr.id)
    FROM
    tracks tr,
    genre_track gt,
    genres ge
    WHERE tr.content_type = 'flc'
    AND tr.id = gt.track
    AND gt.genre = ge.id
    GROUP BY ge.namesearch
    ORDER BY ge.namesearch

    Unfortunately, ROLLUP is not supported by SQLite, so I can't get a grand total in the same query.

    But I put the results (134 rows) into Excel and played with different combinations of genres until I got one that pares the 233,143 tracks down to less than 100,000.

    This query returns those rows:

    SELECT
    tr.*
    FROM
    tracks tr,
    genre_track gt,
    genres ge
    WHERE tr.content_type = 'flc'
    AND tr.id = gt.track
    AND gt.genre = ge.id
    AND ge.namesearch IN ('ALTERNATIVE ROCK','ART ROCK','BLUES ROCK','DEAD','ELECTRONICA','FOLK JAZZ','FUNK','FUNK R B','FUNK SOUL','FUSION','GRUNGE','HENDRIX','INDIE','JAZZ FOLK','JAZZ FUNK','JAZZ FUSION','JAZZ ROCK','LATIN ROCK','NEW WAVE','PROGRESSIVE METAL','PROGRESSIVE ROCK','PUNK ROCK','R B','R B FUNK','R B SOUL','ROCK','SOUL','SOUL FUNK','SOUL R B','TRIP HOP')

    It's not clear to me whether the query would have to be structured like this to deal with the changing genre ids:

    SELECT
    tr.*
    FROM
    tracks tr,
    genre_track gt,
    genres ge
    WHERE tr.content_type = 'flc'
    AND tr.id = gt.track
    AND gt.genre = ge.id
    AND ge.id IN (SELECT x.id from genres x where x.namesearch IN ('ALTERNATIVE ROCK','ART ROCK','BLUES ROCK','DEAD','ELECTRONICA','FOLK JAZZ','FUNK','FUNK R B','FUNK SOUL','FUSION','GRUNGE','HENDRIX','INDIE','JAZZ FOLK','JAZZ FUNK','JAZZ FUSION','JAZZ ROCK','LATIN ROCK','NEW WAVE','PROGRESSIVE METAL','PROGRESSIVE ROCK','PUNK ROCK','R B','R B FUNK','R B SOUL','ROCK','SOUL','SOUL FUNK','SOUL R B','TRIP HOP'))

    Or if there is any substantive difference between the two.
    Home: Win7Pro(x64)[3.3Ghz i5, 8GB RAM, 120GB SSD system, 15TB storage], LMS 7.9.0 -> Logitech Squeezebox Classic V.3 -> Cambridge Audio DacMagic -> NAD C160 -> 2 x NAD C272 -> Quad 22L2
    Portable: FreeNAS 9.3 [HP Microserver Gen8, 10GB RAM, 16GB flash boot, 120GB SSD for LMS 7.9.0 in FreeBSD jail, 5 x 4TB WD Red HD ZFS RAIDZ1] -> Logitech Squeezebox Classic V.3 -> Cambridge Audio DacMagic: XLR out -> Soundmaster Diamond 12-2 mixing board -> P.A.

  9. #29
    Senior Member bonze's Avatar
    Join Date
    Jun 2006
    Location
    Bucks. UK
    Posts
    1,499
    Quote Originally Posted by mherger View Post
    > OK - running on WHS 2011, v7.9.0, 1402499458
    > It just stops with nothing in the server.log


    Could you please give the latest build another try? Should be fixed now.
    Thanks!

    --

    Michael
    Runs OK now - thankyou.
    LMS Version: 7.9
    TranquilPC T2-WHS-A3 - WHS 2011
    2x Touch, 3x SB3

  10. #30
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,300

    Multi Library support in LMS 7.9

    > AND ge.namesearch IN ('ALTERNATIVE ROCK','ART ROCK','BLUES
    > ROCK','DEAD','ELECTRONICA','FOLK JAZZ','FUNK','FUNK R B','FUNK
    > SOUL','FUSION','GRUNGE','HENDRIX','INDIE','JAZZ FOLK','JAZZ FUNK','JAZZ
    > FUSION','JAZZ ROCK','LATIN ROCK','NEW WAVE','PROGRESSIVE
    > METAL','PROGRESSIVE ROCK','PUNK ROCK','R B','R B FUNK','R B
    > SOUL','ROCK','SOUL','SOUL FUNK','SOUL R B','TRIP HOP')


    > AND ge.id IN (SELECT x.id from genres x where x.namesearch IN
    > ('ALTERNATIVE ROCK','ART ROCK','BLUES ROCK','DEAD','ELECTRONICA','FOLK
    > JAZZ','FUNK','FUNK R B','FUNK
    > SOUL','FUSION','GRUNGE','HENDRIX','INDIE','JAZZ FOLK','JAZZ FUNK','JAZZ
    > FUSION','JAZZ ROCK','LATIN ROCK','NEW WAVE','PROGRESSIVE
    > METAL','PROGRESSIVE ROCK','PUNK ROCK','R B','R B FUNK','R B
    > SOUL','ROCK','SOUL','SOUL FUNK','SOUL R B','TRIP HOP'))


    Did you time the duration these two need? In my limited testing with a
    much smaller collection the second version seemed to be a tiny little
    bit faster.

    --

    Michael

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •