English Amiga Board Amiga Lore


Go Back   English Amiga Board > abime.net - Hall Of Light > HOL suggestions and feedback

 
 
Thread Tools
Old 28 June 2004, 12:25   #1
terryhan
Registered User
terryhan's Avatar
 
Join Date: Jan 2003
Location: a zombi filled shopping mall
Posts: 103
Making a database driven site - any tips?

I'm thinking about making an online database covering the many (and I mean many) hacks of console games - Afro Mario, Blind Fu, etc...
I've done some work with PHP and MySQL; but I was wondering if there are any 'tips' or lessons that the HOL team have learnt from their experience.

Most importantly, I suppose - where do I start?

Last edited by terryhan; 28 June 2004 at 12:38.
terryhan is offline  
AdSense AdSense  
Old 28 June 2004, 12:54   #2
CodyJarrett
Global Moderator

CodyJarrett's Avatar
 
Join Date: Mar 2001
Location: UK
Age: 37
Posts: 5,508
My general (techy and non-techy) tips would be:

- The job is always underestimated - think about the work that needs to be done, multiply it by ten and then double it.

- Help from others can be great, but be aware that initial excitement and offers of help can often turn into disinterest quickly and be disrupted by real life.

- Good database design at the start is obviously a good idea, but you'll be better prepared to design a database at the end of it all; once you've encountered unforseen situations and understand it better. It's a bit of a paradox, but prototyping might help.

- Try not to model the target domain to an insane degree. Modelling a domain more generically is usually better. If one case in a thousand differs from the rest, it would make more sense to mention this in a notes field rather than alter a database table to accommodate it.

- Use PNGs for screenshots, rather than gifs. Gifs have a political history and can cause some image problems (e.g. dots appearing).

- Try to make data accuracy a priority; too many websites present badly researched 'facts'. The challenge is to reduce these as much as possible. This is a large subject in itself...

- Be prepared for your work to be taken without permission and used elsewhere.

That's it for now, I'll add more if I think of them...
CodyJarrett is offline  
Old 28 June 2004, 13:08   #3
woody57
Registered User
woody57's Avatar
 
Join Date: Dec 2002
Location: Manchester
Age: 92
Posts: 801
Thumbs up I can't take credit for this

Paul AGA sent me the link to this site Html source { follow bottom links }

It not only contains an excellant tutorial section of " how too" it s explains in detail why some things work and some don't

Cody is quite right it took me nearly TWO Months to sort a working site with conected parts [ and I,m still tweaking ]


Jim however put forward a very important website point


Its more important that your site is usefull for the user's it's intended for, than " How pretty it looks "


Functionality from your index page first , cool graphics in small doses later

After who wants too wait even sixty seconds for all the little Gif & flash icon's to load onto a site before you can even browse it


Good luck , plan well and most importantly have fun html source Html source


Take note I still end up having to edit two or three times on posts , so if I can integrate a site you should sail through

Last edited by woody57; 28 June 2004 at 13:23.
woody57 is offline  
Old 28 June 2004, 17:14   #4
pcGTW_Webmaster
Senior Member
 
Join Date: Jun 2001
Location: Germany
Posts: 913
Quote:
Originally Posted by CodyJarrett
- Use PNGs for screenshots, rather than gifs. Gifs have a political history and can cause some image problems (e.g. dots appearing).
Make sure that the image has 256 colours or less before saving as GIF. No dots will appear then... However, PNG is the better choice of course.
pcGTW_Webmaster is offline  
Old 28 June 2004, 17:22   #5
CodyJarrett
Global Moderator

CodyJarrett's Avatar
 
Join Date: Mar 2001
Location: UK
Age: 37
Posts: 5,508
There are lots of HOL screens with this problem, as we used to use gifs and I didn't know that back then...
CodyJarrett is offline  
Old 28 June 2004, 22:18   #6
terryhan
Registered User
terryhan's Avatar
 
Join Date: Jan 2003
Location: a zombi filled shopping mall
Posts: 103
Right, thanks for the tips guys. I've started work on it, but I'm sure it'll take a while.

Out of interest, do you know of anywhere that might be willing to host such a site? The free server I'm using at the moment can be pretty slow, and bandwith is... non existant.
Fine for testing, of course.
terryhan is offline  
Old 29 June 2004, 10:07   #7
RCK
Administrator

RCK's Avatar
 
Join Date: Feb 2001
Location: Paris / France
Age: 36
Posts: 2,772
test is on your local hardware:
http://www.easyphp.org/
RCK is offline  
Old 29 June 2004, 10:24   #8
Galaxy
Registered User
Galaxy's Avatar
 
Join Date: May 2004
Location: Canberra, Australia
Age: 36
Posts: 1,418
Quote:
Originally Posted by WindowsKiller
Make sure that the image has 256 colours or less before saving as GIF. No dots will appear then... However, PNG is the better choice of course.
... except browser support is still not 100%, so you might lock some of your users out.
Galaxy is offline  
Old 29 June 2004, 12:42   #9
Duke
HOL-Team
Duke's Avatar
 
Join Date: Apr 2002
Location: Germany
Age: 34
Posts: 519
Send a message via ICQ to Duke Send a message via Skype™ to Duke
Even all Amiga browsers support PNG, and on all others Platforms there are uptodate Browsers available.
Duke is offline  
Old 01 July 2004, 00:08   #10
terryhan
Registered User
terryhan's Avatar
 
Join Date: Jan 2003
Location: a zombi filled shopping mall
Posts: 103
Anyone know of a place I can ask for someone to look at some of my PHP?

I'm having trouble adding data to the database - namely, it's adding each record twice.
terryhan is offline  
AdSense AdSense  
 


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
PSPUAE site download database rebuild FOL request.Other 6 07 December 2010 13:28
Nice french site with some hardware tips Yoto support.Hardware 9 02 August 2008 06:14
Fright Night (mouse driven adventure) fc.studio request.Old Rare Games 0 15 April 2007 08:53
Making bootmenu driven ADF's Phiber New to Emulation or Amiga scene 5 01 July 2002 04:52
Favourite Amiga web site. Past or present. No site bashing please. Ian Nostalgia & memories 18 30 September 2001 06:43

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 06:46.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
Page generated in 0.14913 seconds with 11 queries