English Amiga Board - View Single Post - Extract game image filenames + path from FS-UAE Database?

FrodeSolheim · 25 October 2017, 22:37

Files.sqlite is the wrong database. This simply contains an index of files scanned by FS-UAE Launcher on your system.

Instead, you need to parse compressed JSON-blobs from platform-specific game databases (Amiga.sqlite, etc) and look at the "file_list" field in the JSON document (and do this for every game).

Btw: you'll end up with a list of file checksums (SHA-1) that FS-UAE Launcher is interested in, not a list of file names. FS-UAE Launcher could not care less about file names...

25 October 2017, 22:37	#2
FrodeSolheim FS-UAE Developer Join Date: Dec 2011 Location: Førde, Norway Age: 43 Posts: 4,043	Files.sqlite is the wrong database. This simply contains an index of files scanned by FS-UAE Launcher on your system. Instead, you need to parse compressed JSON-blobs from platform-specific game databases (Amiga.sqlite, etc) and look at the "file_list" field in the JSON document (and do this for every game). Btw: you'll end up with a list of file checksums (SHA-1) that FS-UAE Launcher is interested in, not a list of file names. FS-UAE Launcher could not care less about file names...