View Code? Open in Web Editor
NEW
Windows 10/11 Photos app SQLite explorer
JavaScript 27.87%
HTML 8.94%
TypeScript 63.19%
windows-photos-tanstack-solid's Introduction
๐ Hi, Iโm @aikmandean
๐ Iโm interested in multiple dispatch and functional programming.
๐ฑ Iโm currently examining how React Context might slow enterprise software.
windows-photos-tanstack-solid's People
Contributors
Stargazers
Watchers
windows-photos-tanstack-solid's Issues
Do you think sending the full image makes the right tradeoffs?
Alternatives:
Producing a thumbnail on demand
Make then save thumbnails at startup on disk
Make then store thumbnails in SQLite
All the images need to be directly stored in /data/all
so any images in subdirectories will fail to display.
Optimal steps
Write a SQL query to recover the folder-filename pairs stored in MediaDb.v1.sqlite
.
Replace fileName: <file name . ext>
by joining its path filePath: <file path . ext>
Tags are a filter category but only one tag can be filtered for at any time. It's not possible to filter for photos having two tags, "photos of food that is outside."
Poor steps
Send the multi-filters server-side
Use the filter as part of the where clause
Return results so that grouping works after the server filter is applied
File type .heic
is blocked by the app because it's not supported in any browser. It could be converted .jpg
to be seen in all browsers.
Optimal steps
Allow handlers to register for file extensions
Permit all middleware connectors to convert...
a. on-the-fly
b. on-startup