How to implement a photo library?

[Brian Lewis]

Sharepoint would be the ultimate solution, but perhaps is a giant hammer to crush a small nut?

Desktop Pineapples worked with a folder structure on the file system and a database file that indexed those items

... need security, and ability to address a file by a url - (an MVC url that takes a file ID, and looks up its path?)

[Brian Lewis]

Sql FILESTREAM seems to offer the best of both worlds.

https://www.simple-talk.com/sql/learn-sql-server/an-introduction-to-sql-server-filestream/

However, because this has to be implemented in the configuration of the SERVER (as well as the database), could be problematic in the Solomons where we don;t control the server.

[Ghislain Hachey]

I think the Document feature does all we need