Should i store web information on a database?

bigbri · 01-06-2006, 12:49 PM

Hi,
I am putting together a family tree with a view to publishing it on the internet.

I have the basics layed out, but the information is now becoming a bit too big to handle in its current form.

I was wondering if it would be better to store my information on a database so that it could be organised better and I could then retreive and amend the information in one central place.

Does anyone have any advice on how (if at all) I should proceed with this idea. i.e what should i be using to write it e.g. "ASP" and are there any companies offering cheap database handling services.

I hope this make sense.
Thanks,
Bigbri

Matt555 · 01-06-2006, 01:58 PM

You could use a database, it would make accessing, editing and adding information a lot easier.

You could use PHP and MYSQL to do it.

Sniper · 01-06-2006, 02:25 PM

ASP not sure about the hosting costs but php/mysql hosting is very cheap. If you plan to update the information often enough then yes it would be better but if once you have the full tree and you only need to make a few changes now and then, then a simple HTML should be ok.

You will have to learn php/mysql e.g. how to add to database etc but its not as hard as you might think. If you have done programming before it should not be difficult.

Addis · 01-06-2006, 02:41 PM

Most hosts offer database services with their web packages. As Sniper said, it would probably be cheaper to use one offering PHP/MySQL as they are free and open source. ASP and windows server are proprietary software that will cost much more for the host, and therefore more for you.

bigbri · 01-06-2006, 04:35 PM

Just wanted to say a big thank you to "Matt555", "Sniper" and "Addis" for your very quick reply's.

It looks like PHP/MySQL is the winning choice.

Thanks for your advice.

Matt555 · 01-06-2006, 05:26 PM

No problem, it's what we're here for, if you need any help with the PHP/MYSQL just shout, we'll be able to help I'm sure

JohnLynn · 12-06-2006, 11:58 PM

Quote:

Originally Posted by Matt555

You could use a database, it would make accessing, editing and adding information a lot easier.

You could use PHP and MYSQL to do it.

Hi Matt.
I am using ASP with Access on Win host. It is too slow compared to MySQL & Apache Servers. I know it depends on ISP as well in terms of response time. But my ISP is rather reliable.

What's your view on this? Is it the Acess/ASP or the ISP letting me down.

Thanks in advance.

Matt555 · 13-06-2006, 08:03 AM

Having never used ASP / Access based system for storing web information I wouldn't know.

It may be down to your provider though - what's the upspeed of your connection? That could be slowing things down I guess.

Addis · 13-06-2006, 04:11 PM

You don't have to use your ISP as your web host, and there are plenty of good hosts which offer dedicated servers with PHP/MySQL.

Matt uses http://www.ashosted.co.uk/ and recommends it.

command tab · 22-06-2006, 04:21 AM

Quote:

Originally Posted by bigbri

...
Does anyone have any advice on how (if at all) I should proceed with this idea. i.e what should i be using to write it e.g. "ASP" and are there any companies offering cheap database handling services.
...i

Are you familiar with any programming languages? PHP is fast and very C-like in its syntax, but is much much more forgiving. It's my server-side language of choice.

Overall, I'd recommend PHP+MySQL for your situation, but you'll want to spend some time layout at the database beforehand. Here's some info straight from the MySQL folks on storing and traversing a tree in a database:
http://dev.mysql.com/tech-resources/...ical-data.html

01-06-2006, 12:49 PM	#1 (permalink) Top
bigbri Geek Trainee Join Date: Oct 2004 Posts: 8 Status: Offline	Should i store web information on a database? Hi, I am putting together a family tree with a view to publishing it on the internet. I have the basics layed out, but the information is now becoming a bit too big to handle in its current form. I was wondering if it would be better to store my information on a database so that it could be organised better and I could then retreive and amend the information in one central place. Does anyone have any advice on how (if at all) I should proceed with this idea. i.e what should i be using to write it e.g. "ASP" and are there any companies offering cheap database handling services. I hope this make sense. Thanks, Bigbri

01-06-2006, 01:58 PM	#2 (permalink) Top
Matt555 iMod Join Date: May 2005 Age: 21 Male Posts: 3,844 Times Helpful: 238 My Mood: Happy Status: Offline My Computer	You could use a database, it would make accessing, editing and adding information a lot easier. You could use PHP and MYSQL to do it. __________________

01-06-2006, 02:25 PM	#3 (permalink) Top
Sniper Administrator Join Date: Oct 2001 Age: 24 Male Posts: 4,432 Times Helpful: 116 My Mood: Bored Status: Offline My Computer	ASP not sure about the hosting costs but php/mysql hosting is very cheap. If you plan to update the information often enough then yes it would be better but if once you have the full tree and you only need to make a few changes now and then, then a simple HTML should be ok. You will have to learn php/mysql e.g. how to add to database etc but its not as hard as you might think. If you have done programming before it should not be difficult. __________________ Zone 365 \| F@H Team \| Team Stats \| Use The Thank You System \| My Groups: Manchester United \| Apple

01-06-2006, 02:41 PM	#4 (permalink) Top
Addis The King Join Date: Jan 2004 Age: 18 Male Posts: 5,255 Times Helpful: 403 My Mood: Drunk Status: Offline My Computer	Most hosts offer database services with their web packages. As Sniper said, it would probably be cheaper to use one offering PHP/MySQL as they are free and open source. ASP and windows server are proprietary software that will cost much more for the host, and therefore more for you. __________________ Never trust a program you don't have the source code for. My website \| Powerful Desktop Linux \| Linux for human beings \| Linux for power users \| Linux for ricers

01-06-2006, 05:26 PM	#6 (permalink) Top
Matt555 iMod Join Date: May 2005 Age: 21 Male Posts: 3,844 Times Helpful: 238 My Mood: Happy Status: Offline My Computer	No problem, it's what we're here for, if you need any help with the PHP/MYSQL just shout, we'll be able to help I'm sure __________________

01-06-2006, 04:35 PM	#5 (permalink) Top
bigbri Geek Trainee Join Date: Oct 2004 Posts: 8 Status: Offline	Just wanted to say a big thank you to "Matt555", "Sniper" and "Addis" for your very quick reply's. It looks like PHP/MySQL is the winning choice. Thanks for your advice.

13-06-2006, 08:03 AM	#8 (permalink) Top
Matt555 iMod Join Date: May 2005 Age: 21 Male Posts: 3,844 Times Helpful: 238 My Mood: Happy Status: Offline My Computer	Having never used ASP / Access based system for storing web information I wouldn't know. It may be down to your provider though - what's the upspeed of your connection? That could be slowing things down I guess. __________________

13-06-2006, 04:11 PM	#9 (permalink) Top
Addis The King Join Date: Jan 2004 Age: 18 Male Posts: 5,255 Times Helpful: 403 My Mood: Drunk Status: Offline My Computer	You don't have to use your ISP as your web host, and there are plenty of good hosts which offer dedicated servers with PHP/MySQL. Matt uses http://www.ashosted.co.uk/ and recommends it. __________________ Never trust a program you don't have the source code for. My website \| Powerful Desktop Linux \| Linux for human beings \| Linux for power users \| Linux for ricers

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Forum 'store'?	Exfoliate	Suggestions and Feedback	24	27-04-2006 05:32 PM
urpmi database locked	sabashuali	Linux and Other OSes	8	23-11-2005 07:24 PM
Oracle database import in 10g?	djjedi	General Software	0	29-10-2005 03:10 AM
Part buying-online or store	Girtho961	New Build / Upgrade Advice	14	03-08-2005 01:29 AM
Need a help with e-store script	Sara Black	General Software	3	12-12-2003 10:36 PM