Starting a database-driven website
Posted: Sun Jun 17, 2012 11:07 pm
Hiya-
I would like to start a website that will be primarily database-driven. I guess that's what it's called, I honestly have no idea where to begin. I do know that I will have a database of information, and I need that information to searchable by the folks accessing my site. Apparently SQL is the way to go. I'm somewhat familiar with consumer databases, going back to the Filemaker days, fiddling with OpenOffice these days, nothing serious.
Eventually, I would like for my website visitors to be able to submit their own data, which will be added to the main database upon review. But for now I'd like to start with a couple hundred entries, which will be constantly added to by myself.
What is the best way to start building the database that I need to be accessible (assuming SQL is the way to go)? I have the information, I just need to know what software to use to actually build the database itself. I apparently need some RDBMS software. MySQL starts at 2 grand per year. Crikey. MS Access is cheaper, but is that the way to go? Any free alternatives, just to get going?
Also, as far as web registrars, a friend recommended http://www.1and1.com. They seem to have a decent deal going right now... I would like to possibly monetize this site in the future; is there any difference between registering a site to host cat pictures and registering a site to host a for-profit business?
I have many more questions, but those are my tops for now. Any and all help is most appreciated.
Thanks,
Drewstre
I would like to start a website that will be primarily database-driven. I guess that's what it's called, I honestly have no idea where to begin. I do know that I will have a database of information, and I need that information to searchable by the folks accessing my site. Apparently SQL is the way to go. I'm somewhat familiar with consumer databases, going back to the Filemaker days, fiddling with OpenOffice these days, nothing serious.
Eventually, I would like for my website visitors to be able to submit their own data, which will be added to the main database upon review. But for now I'd like to start with a couple hundred entries, which will be constantly added to by myself.
What is the best way to start building the database that I need to be accessible (assuming SQL is the way to go)? I have the information, I just need to know what software to use to actually build the database itself. I apparently need some RDBMS software. MySQL starts at 2 grand per year. Crikey. MS Access is cheaper, but is that the way to go? Any free alternatives, just to get going?
Also, as far as web registrars, a friend recommended http://www.1and1.com. They seem to have a decent deal going right now... I would like to possibly monetize this site in the future; is there any difference between registering a site to host cat pictures and registering a site to host a for-profit business?
I have many more questions, but those are my tops for now. Any and all help is most appreciated.
Thanks,
Drewstre