software to create a database?

where to start creating a database?

[sebauvergne]

Hi,

I want to create a database but i have no idea which software i should use to do that. I'm quite new to development. I've worked on access before but am now working on Macintosh.
Any suggestion are welcome.
thanks

Seb

[mhhfive]

well, what do you want to do with it ultimately.. that'll probably help in picking which db to use, etc, etc.

[sebauvergne]

Well, the database will be about music resources like labels, guitar shops and other stuff like that with music style, contact name, address, phone, town, county, etc... Quite basic actually!
It will allow people to search for specific shops in their town or a jazz label...
And that's all i need to do with it!

Thanks for your help

S

[mack]

Do you intentd to use your database to be used internaly, or as part of a web based application such as a site.

If youre thinking about taking your data to the web then mysql may be the database server of choice. You can use a scripting language of your choice to insert, edit, deleta or search within records.

On your own system you may want to go with msql server from Microsoft.

If you can give us a little bit more info about what you are trying to set up we shoudl be able to help you more.

Mack.

[sebauvergne]

The database will be part of a website for unsigned and independant bands. As i said, it will list all the labels, shops, promoters, etc... in France (with phone number, contact, address, ...). Once it will be built, i want to create a search tool with 4 boxes, each one including a list of criterias. For example the first box will be "category" and it will be include labels, promoters, music shops..., the second one "style" with rock, pop, jazz... and so on!
I've done some works on databases with access a few years ago but i'm now on mac so i wanted to know what to use to do this one.
Thanks for your help
S

[mack]

Hi again sebauvergne,

In your case I would be tempted to use the php scripting language and mysql database for storing your data. The different data sections could be stored in mysql tables within your main database. You would end up with tables for category, artist label etc.

You can then use an html form to allow your users to query the database. The great thing about setting up a browsable mysql database its you can allow your users to view by different criteria.. for example order by artist or label.. or only show this artist on this label etc... or show all by an artist.

It all comes down to using "mysql select" within your php code.

Mack.

[sebauvergne]

Ok, i'm going to try it that way!
Thanks