I hope this is the right section to post this question, I couldn't see a better suited one.
I am looking at creating a website that an user can login to, upload pics, do searches etc - something similar to facebook but for golf. I would like you experts to advise me on the best technologies to learn and develop the website with.
So my advice needed/questions answered are:
1) I anticipate using Open Source technologies so I don't need any licenses for producing, or letting the world use, my website, for this reason I'm dismissing .NET or JAVA technologies (plus the hosting charges are cheaper for Open Source) -- would you guys agree this is best?
2) I'm learning towards LAMP - is this still the best approach for developing a website? Would any of you advise going for WAMP (again the Windows hosting costs) as I'm wondering if there are main benefits for wamp?
3) With LAMP what:
a) versions of 'L' Linux should I use?
b) verisions of 'A' Apache should I use?
c) should I use MySQL or PostgreSQL (I'm looking for a robust free to use Database with architecture close to SQL Server)?
d) should I use Perl, Python or PHP - I'm looking to use a language that is the future (i.e. maybe PHP was best five years ago but now, say, Perl has been bought by a big company it is the future - this is just a for instance)?
e) for the 'P' is there a language that is more robust, maybe more OO than others for correctness?
I just need some guidance on whats the best (future proof) technologies to use as if I'm going to learn something then I may as well learn something that is regarded highly and that will be around for years.
Thank you in advance.