Skip to main content
Recent Posts
2
3rd Party Plugins - (fb2k) / Re: foo_sqlite
Last post by fbuser -
Unfortunately the code doesn't suit my purpose.
But it's doing what you actually asked for.  :)
So this gives me a visual list of all albums which exist in Playlist "Test" and the media library.
Which is the opposite from your original question.  :)

Is there any way to have this fed back into a new Playlist "Result"?
No, this is logically not possible, because only tracks can be added to a playlist, not summarized results like in your query. However you could either remove the tracks from the test playlist, which don't exist in the media library or add the matching tracks to another playlist.

To do this you first need to create another virtual table for the playlists, which allows you to manipulate them:
Code: [Select]
DROP TABLE IF EXISTS Playlist_Updatable;
CREATE VIRTUAL TABLE Playlist_Updatable USING MetaDB_Module(no_multivalue_split,playlist);

The deleting of the unmatched tracks could be done with (not possible in this case without NOT EXISTS):
Code: [Select]
DELETE FROM Playlist_Updatable pu
WHERE playlist_name='Test'
    AND NOT EXISTS (SELECT 1
                                FROM ml_tmp
                                WHERE artist=pu.artist
                                     AND album=pu.album)

If you don't want to list the result it's not necessary to add the columns title and codec to the table ml_tmp and also an index to speed up the lookup on this table should be created. It could look like this:
Code: [Select]
DROP TABLE IF EXISTS ml_temp;
CREATE TEMPORARY TABLE ml_temp
AS SELECT DISTINCT artist,album
FROM MediaLibrary;

CREATE UNIQUE INDEX ml_temp_in_unique on ml_tmp(artist,album);

Adding the matching tracks to another playlist could look like this (if the target playlist, doesn't exist, i will be automatically created):
Code: [Select]
INSERT INTO Playlist_Updatable(metadb_handle,playlist_name)
SELECT metadb_handle,'New playlist'
FROM Playlist_Updatable /* or just Playlist, it doesn't matter */ pu JOIN ml_temp ml ON ml.artist=pu.artist AND ml.album=pu.album
WHERE playlist_name='Test'

Note1: I didn't test the SQL statements, so they might be not 100% correct.

Note2: You will run into troubles, if the combination of artist and album is not unique, i.e. you have more than one album with the same combination, but this depends on the content of your media library and your individual tagging guidelines.

3
General Audio / Re: Need Advice To Replace iTunes mp3 with FLAC
Last post by shadowking -
There's nothing that can be done except sourcing the original cd's or buy lossless if available.  I know exactly the feeling -- you want one lossless archive and instead the arrogant google / apple  / amazon  SELL ONLY lossy dissing users who want premium quality ..  How hard is it to provide an additional lossless compressed copy for these idiots in 2018 !? Yes 100%  brainwashing and dumbing down of the population.

There is a bandcamp site that does lossless for some alternative artists.
4
3rd Party Plugins - (fb2k) / Re: foo_sqlite
Last post by Chris Norman -
Thanks for the reply. I played a little bit around with the code.
Unfortunately the code doesn't suit my purpose. Your example compares on path but the path will be different because these are different files.

I had difficulties with the exists syntax and I tried a join instead. For speed reasons I created two temp tables:

Code: [Select]
DROP TABLE IF EXISTS ml_temp;
CREATE TEMPORARY TABLE ml_temp
AS SELECT DISTINCT artist,album,title,codec
FROM MediaLibrary;

DROP TABLE IF EXISTS Test;
CREATE TEMPORARY TABLE Test
AS SELECT DISTINCT artist,album,title,codec
FROM Playlist p
WHERE playlist_name='Test';

SELECT DISTINCT p.artist,p.album,ml.codec AS lib_codec,p.codec AS logs_codec
FROM Test p
JOIN ml_temp ml
ON ml.artist=p.artist
AND
ml.album=p.album

So this gives me a visual list of all albums which exist in Playlist "Test" and the media library.

Is there any way to have this fed back into a new Playlist "Result"?
8
CD Hardware/Software / Re: Why the cd wav ripped by WMP can't match any result?
Last post by korth -
Why just delete a sector?
Probably just a bug.

so the wav ripped by WMP can't be called "lossless"?
I performed the tests some time ago.
I would define the last track as truncated. One sector of silence missing (lost) from the end.
Appending one sector of null samples to the end of the last track (with audacity) was enough for CUETools to correctly identify the CD and verify. Of course any Track#1 pregap or data track info that existed for the original CD had to be manually entered for an AccurateRip match and without read offset correction in WMP, the AccurateRip results were offset but most of the tracks verified as accurate.
9
General Audio / Re: Need Advice To Replace iTunes mp3 with FLAC
Last post by DVDdoug -
Quote
now I'm stuck with all this iTunes mp3 crap to replace.   Full albums, so I paid full price for garbage quality.
If you bought from iTunes you have AACs, not MP3s, and they should be good quality.    MP3s from Amazon or other reputable sites should also be good quality.    If you ripped them yourself, or someone ripped them, they could be lower quality.

Most good-quality AACs & MP3s will sound identical to the uncompressed original (in a proper blind ABX Test).    If can hear a difference, it's usually hard to hear a difference, and even harder if you listen to the MP3 today and the FLAC next week.

You might try buying a few of the most "important" CDs, rip them to FLAC and compare.    If you hear a difference, try the ABX test to make sure you're not fooling yourself.

...I don't do ABX testing but every time I've thought I heard an MP3 compression artifact, it's turned-out that the CD has the same "defect".   

Quote
My question is, where is the best place to pick up used (I did already pay full price, after all) CD's that are consistently in good enough quality to get a good rip?
I think I've only purchased used CDs from Amazon a few times.    The bad thing is, they are sold by 3rd parties so you don't get the free shipping.   After you pay the shipping you're around half the price of a new one.    Maybe you can find someplace that sells used CDs with free shipping (with a minimum order).
10
CD Hardware/Software / Re: Why the cd wav ripped by WMP can't match any result?
Last post by hintlou -
To check what TOC CUETools used for the RIP during verify, set 'Create TOC files' to 'True' on the 'Advanced' tab in settings. 'In source folder' also needs to be checked under 'Verify' on the 'AccurateRip' tab. This will create a filename.toc file in the source folder after you verify a RIP. You can open the file with a text editor such as notepad and compare that TOC to the TOC in the extraction log file from the EAC rip.
From my tests WMP leaves one sector off the end of the last track. This changes the length and CUETools cannot properly identify the CD. Any Track#1 pregap or data track info that existed would also be missing to identify the CD.
thanks for your tests!u unraveling my doubts all along!so the wav ripped by WMP can't be called "lossless"?




edit: removed double quote
SimplePortal 1.0.0 RC1 © 2008-2018