Which software ?
Author
Discussion

cuneus

Original Poster:

5,963 posts

273 months

Friday 3rd August 2007
quotequote all
I have been tracing all the TVR SEAC's and am now at a stage where I want to create a website

The (tiny) database is in MS Access and has tables for cars with a one to many relationship with owners and publications and hyperlinks to picture and articles

I want to create a website where I can:

Publish thousands of pictures
Show links to scanned magazine articles in PDF and jpeg
When I add a picture I don't want to have recode/update
Allow people to search the database and submit updates to an admin
Use as little coding (none!) as possible
Publish normal pages with text and pics

Software should be low cost/free

am on XP. My ISP is Pipex but I don't mind paying for a hosting package if required

any suggestions ?

TIA

cyberface

12,214 posts

288 months

Friday 3rd August 2007
quotequote all
If you want to keep Access (I'm a database snob so take what I say with a pinch of salt...) then you'll obviously need to run the webcode that runs database queries on a Windows box. This limits you to either co-location (plenty of places will rent you a Windows virtual machine on the net) or host it yourself on your own equipment at the end of your broadband line.

Option B is possible but you'll be running Microsoft webserver, ASP (most probably) and Access on a machine at home with static IP... personally I'd say this is a recipe for a lot of wasted time, security patching and potential exploits.

Getting someone else to look after a Windows box on their network for you may make more sense, but will cost money. If it's 'out there' on the internet then I'm not sure whether you can get away with Microsoft's free dev licenses for the development tools and database. If not, it's going to cost.

Alternatively you could port the data onto a proper database (any of the free ones would do like MySQL or PostgreSQL) and pop it on Linux, no licensing costs. You've then got a bunch of other data-driven web development language options (PHP, for example). These are all very common and supported by co-location providers.

I personally think Ruby rocks and Ruby on Rails is an easy framework for data-driven web applications, so if I was doing this I'd probably do it with RoR, MySQL and Linux.

This would be free software, with the virtual machine hosting being the sole on-going cost.

However ALL of the above options require development, and I have no idea what programming knowledge you have.

If coding is a no-go then you'll have to look into content management systems and which ones have the necessary capabilities. To be honest, there's not a lot of difference in configuring a proper CMS and coding simple RoR apps, neither are drag-n-drop. You then have to ensure a hosting company will host the site (badly written code can be exploited...)

Super-simple all-in-one solutions like Apple's iWeb and .mac subscription are neat if you've got a Mac... but I'm not sure if iWeb can be database driven. You'd obviously have to port the database off Access for this to work.

I'm not a web developer so just throwing some ideas into the air here, there may be some obvious easy CMS that's deployable with no coding required that I haven't heard of. However unless I'm overlooking something obvious, using Access will basically lock you down to needing to host a Windows box on the net and you'll probably end up using ASP.net or something that can query the Access DB file, so I'd recommend porting that first so you have more options.

Plenty of contacts here on PH who run businesses in said areas. JamieBeeston seems the man for hosting, UKBob sells websites (and may have a content management system ideal for the job). These are the first two that spring to mind.