search

marijnkampf / Random-Photo-Screensaver

Source of Random Photo Screensaver
http://www.abscreensavers.com/random-photo-screensaver/open-source
Other
44 stars 14 forks source link

Create secondary indexes for metadata (store metadata as JSON) #73

Open marijnkampf opened 7 years ago

marijnkampf commented 7 years ago

Make metadata searchable/sortable? by storing as JSON and creating secondary index(es) - for selected data members? https://www.sqlite.org/json1.html https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes-virtual-columns.html

Note: data types may need to be normalised for certain metadata (shutter time, exposure times, dates, ...)