Skip to content

Instantly share code, notes, and snippets.

@thadk

thadk/soma-fm-app-favorites-extract.md

Last active October 30, 2016 21:07
Show Gist options
  • Save thadk/f02b5ab3afbaf30b64461cb2b6c3c51f to your computer and use it in GitHub Desktop.
Save thadk/f02b5ab3afbaf30b64461cb2b6c3c51f to your computer and use it in GitHub Desktop.
Download ZIP
Extract your favorited songs from the SomaFM Mac App (may work on iOS db as well)
Raw
soma-fm-app-favorites-extract.md

Quit SomaFM app.

brew install sqlite3

Replace your username in the paths below:

Get all your favorite/bookmarked songs on Mac SomaFM app that have no parenthesis in the title: sqlite3 /Users/thadk/Library/Containers/com.somafm.somafmmac/Data/Library/Application\ Support/SomaFM/SomaFM.sqlite3.db "SELECT printf('%s - %s', replace(title,'-',' '), replace(artist,'-',' ')) FROM bookmarks WHERE title NOT LIKE '%(%'"

Then use this website to convert to Spotify or YouTube: http://playlist-converter.net/#/

You may need to manually strip out (Remix) details from the rest: sqlite3 /Users/thadk/Library/Containers/com.somafm.somafmmac/Data/Library/Application\ Support/SomaFM/SomaFM.sqlite3.db "SELECT printf('%s - %s', replace(title,'-',' '), replace(artist,'-',' ')) FROM bookmarks WHERE title LIKE '%(%'"

@thadk
Copy link
Author

thadk commented Oct 30, 2016 •
edited
Loading

Also browsable In the Firefox excellent: https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/
image
image

@thadk
Copy link
Author

thadk commented Oct 30, 2016

You can also use this SQL technique to merge several computer's SomaFM databases.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment