VLC for Android: Where does it stores playlist files?

The playlists and other media informations are stored in this database file:

/data/data/org.videolan.vlc/app_db/vlc_media.db 

The easiest method so far is to modify the playlists from inside the app by adding/removing media files from/to them.

However, if you have root access to your phone/tablet, an sqlite editor/reader (you can get one here), basic knowledge of SQL and a bit of patience you can modify the playlists by doing the following:

Navigate to /data/data/org.videolan.vlc/app_db and copy vlc_media.db to a folder you have full permission.

Open the copied file mentioned above with the SQL editor app. In the 'Tables' tab, you will see all the tables among them Playlist, Media, PlaylistMediaRelation, AudioTrack and VideoTrack.

In the 'Sql Editor' tab, insert the code below to get a list of all playlists and their files, then click on 'Run':

SELECT id_playlist, name, filename 

FROM Playlist

Inner Join playlistmediarelation ON playlist_id=id_playlist

Inner Join Media ON id_media=media_id

WHERE name = 'your_playlist_name'

ORDER BY id_playlist

To check your media files with their ids:

SELECT id_media, filename

FROM Media

From these information, you can modify your playlist(s):

• To insert/append media to playlist:

  
  
  

  INSERT INTO PlaylistMediaRelation(media_id,playlist_id)
VALUES(520,1)




• To delete multiples media files:

  
  
  

  DELETE FROM PlaylistMediaRelation
WHERE media_id IN (456, 520) AND playlist_id=2




• To update a media:

  
  
  

  UPDATE PlaylistMediaRelation
SET media_id=321
WHERE media_id=476 AND playlist_id=7

Don't forget to copy the file back to the original folder.

Note: The numbers for id in the code are just examples.