I'm looking for the best solution for my needs and consider SharePont (SharePoint Foundation 2013 on-premise). Please have a look.
I'm in B2B business and results of my work are files (presentation, pdf, video etc). All files are grouped by "projects". Every project has at least name, number and date. I have not so much customers, let say, 50 and one hundred projects a month total.
What I need is that my customers could log into some web-site with nice interface, find project by name, date or number and download files from the project.
Additionally, we use in-house .Net/SQL developed software for operations. I also need to incorporate some data from SQL (like project progress in %%) to the project page.
Could you point me out if SharePoint is a good idea for this task and how to get started?