First time with DB. Making a CMS. How and Where do I start?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Sindarin
Forum Regular
Posts: 521
Joined: Tue Sep 25, 2007 8:36 am
Location: Greece

First time with DB. Making a CMS. How and Where do I start?

Post by Sindarin »

So I finally encountered a client that wants a dynamic news page to update by himself. Problem is that as I have read about databases and understand them, I'm kind of afraid I won't be able to handle such project, I hardly have a month as deadline and all shows up like a mountain to me.

He needs news updating, search and updatable downloads section.

I don't want to mess with cms solutions like Joomla or Drupal, because I don't have experience with them and I'll need to modify them to suit my page's needs. (The client is a bit picky about design). Small scripts are welcome though.

So now, where and how do I start? :?
User avatar
jayshields
DevNet Resident
Posts: 1912
Joined: Mon Aug 22, 2005 12:11 pm
Location: Leeds/Manchester, England

Re: First time with DB. Making a CMS. How and Where do I start?

Post by jayshields »

Get stuck in, do what you can, and post what you've got.

If you don't have any idea where to start, personally, I always start by designing the database and constructing queries for it which I think I will use in the application. I doubt everyone will agree with me that that is the best starting point though.

You are probably right to avoid huge CMS's, because it will take you a month to understand what's going on in their code, without even starting trying to make constructive changes to it. Maybe you could go somewhere like http://www.hotscripts.com and see if you can find some existing scripts for your individual sections to take ideas from.
Post Reply