Shotwall is a non-destructive photo viewer for Linux. This is great, because it stops you destroying your photos. However it’s not possible to list the photos which you’ve modified. Very annoying.

To list the photos you’ve modified you have to jump into the SQLite database:

sqlite3 ~/.shotwell/data/photo.db

There is a table within the database which lists the photos in your collection. The “transformations” field within this table contains any modifications which you may have made. So the following SQL query will list the modified photos:

SELECT filename FROM PhotoTable WHERE transformations != ""; filename