Skip to main content
Recent Posts
1
Support - (fb2k) / Filters don't work
Last post by Halwa -
Hi Im new to foobar, I installed the 1.4 version and columns ui, when i add a filter(genre,artist or album) it shows me nothing, although I added some music. Can anybody help me ?
2
Support - (fb2k) / Re: Foobar2000 1.4 broke keyboard media controls
Last post by Alexxander -
Hi,

I have an up-to-date Windows 10 and a multimedia cabled Logitech keyboard and have same issue with foobar2000 v1.4. I use the standard Win10 keyboard driver, not the Logitech driver.

Once I upgraded to v1.4, the play/pause/next/previous buttons worked initially. I also got display notification with song artist and title when I pressed next track button on keyboard. Never had that seen before.

But, next day, supposedly after PC reboot, the mentioned keyboard keys stopped working unless foobar2000 window was active. Also, the notification on display when changing track didn't show up anymore.

Now I downgraded to v1.3.20 and Logitech play/pause/next/previous buttons work again.

Logitech volume button did keep working on v1.4.

Thanks
Alexxander

3
General Audio / Re: Need Advice To Replace iTunes mp3 with FLAC
Last post by blurry_light -
100mb avg for lossy. 300mb lossless.  Dual encoding  = 400mb without compatibility issues.  What is 400mb download  today - a 10 min clip from YT ?  They can give a 'premium ' option .  If they wont touch flac, create a zip archive of the wavs.

If you mean 300mb total size of an album in a compressed lossless format like FLAC or ALAC, that's highly optimistic.

You may have accepted lossy as long as no re-encode, But that is getting short changed.

Given that most of the time a full album in lossy format costs less than the CD or the (verified and genuinely) lossless download, I don't know about "short changed".

Bandcamp - The allegations are unproven except *maybe* in an isolated cases.

Actually, someone from these very forums did some sleuthing and Bandcamp told them that while they require artists to supply lossless files, they don't dissuade them from using a lossy original to generate said lossless files. That's from Bandcamp's own mouth, so...
4
3rd Party Plugins - (fb2k) / Re: Facets (foo_facets)
Last post by TheEmpathicEar -
[I am not sure if this is specific to Facets] Example: I have two albums titled, "Greatest Hits", one by Neil Young and one by Guns N Roses, both released in 2004. In album view, instead of having two separate entries for each album, I have one entry with all tracks for both albums listed together. i.e. Track 1, Track 1, Track 2, Track 2, etc. What to do? Is this a matter of settings?
EDIT: 1. I am using v1.4 Final
2. If I browse by each artist, each album is displayed separately.
5
General Audio / Re: Need Advice To Replace iTunes mp3 with FLAC
Last post by shadowking -
100mb avg for lossy. 300mb lossless.  Dual encoding  = 400mb without compatibility issues.  What is 400mb download  today - a 10 min clip from YT ?  They can give a 'premium ' option .  If they wont touch flac, create a zip archive of the wavs.

You may have accepted lossy as long as no re-encode, But that is getting short changed.

Bandcamp - The allegations are unproven except *maybe* in an isolated cases.
6
General Audio / Re: Need Advice To Replace iTunes mp3 with FLAC
Last post by blurry_light -
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.

To be fair, the codecs and settings/bitrates used by Google, Apple and Amazon's online music stores are high enough quality that they should sound just like the original lossless source.

Think about it from the perspective of these companies; they have to store God knows how many albums on their servers to have available for people to purchase and download or stream on demand. What do you think they'll opt for? A lossy format with a more or less predictable file size? Or a lossless format which can be anywhere from pretty much zero (excluding container overhead, metadata, etc.) for digital silence, all the way up to the same size as the uncompressed original (for uniform white noise)?

Me personally, since these companies tend to sell music in high-quality lossy formats, I'm fine with them as long as I make sure not to encode them lossily again.

There is a bandcamp site that does lossless for some alternative artists.

It's funny you mention that; it isn't unusual for bandcamp to sell "lossless" music which almost certainly comes from a lossy source, though this usually isn't due to sheer malice, but simple ignorance; quite often, artists aren't aware that if an MP3 is converted to WAV or FLAC, the lossily discarded information won't come back.
8
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.

9
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.
10
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"?
SimplePortal 1.0.0 RC1 © 2008-2018