Question for website owners

[6a6ar09a]

I am going to build simple db driven website and I am wondering did I forgot something?
I would like to get tips from those who already have similar website but others are welcome too.

Here are the tables;

[Chiefish]

PFFFF if its not drag and drop I cant help ya
But I am sure some of these guys know all about this stuff from my viewing of thier sites.

[6a6ar09a]

I don't need technical help (it's easy). Just some tip (if any) from user point of view or more precise, from experienced "collector" point of view. (that is why I ask website owners, not website designers)

For example; Is there any other detail, or chip/board characteristic, that should be considered as important and that should have separate field in database?
(separate field gives you possibility to query your db using that field as query criteria)

All suggestions are welcomed.

[debs3759]

I would also add a field to indicate what family a chip is from (eg x86, 68K, etc)

[6a6ar09a]

Thank you debs. Yes, I saw that many of collectors classify their chips by chip family. It won't hurt if I can do that too .

In the mean time, a few more fields added (date_code and time_date_entered) so table look like this right now;

[Chiefish]

Please excuse my ignorance, but what are those fields for, a search criteria or somthing?

[6a6ar09a]

Well, there are basically two ways to build website (there is much more but for your better understanding let say just two).

The first one is to go page by page, creating html pages for every single item... for other content too, and linking them, you can form some kind of organized website.

The second one is to anticipate what would be static and what would be dynamic content of the website... Than to make database for dynamic content and integrate all together.

The second way is more complex at the beginning but when you make decision about what you want and how you want to organize your website all other is easy.

When you have database driven website you will be able to enter, edit, delete content much faster and you (your website visitors) can query your content in many different ways.

This is fast explanation... could talk about that three days but... hope this was helpful enough.

[kosmokrator]

u prepare website for chips ect????
nice to see it...

[6a6ar09a]

Yes, my chips, boards, wind generators... all my hobbies finally deserve to be published. I never have time for them... (I have made hundreds of applications, websites for others...) but now I decided to do it for me and to do it right. Do you have any tip, suggestion?

[kosmokrator]

when i see some pre-release of site i m able to tell u tips and ideas...
keep it up...

[CPUShack]

this is the set up of my new site

http://screencast.com/t/JARVLZoDlrd

[JAC]

Wordpress

[6a6ar09a]

@CPUShack

Great! Very useful. You have intention to go really deep.

But now I am thinking out loud (maybe you can help);

1. is it better to go like this, with all separated fields or
2. to go using (full_spec and additional_info) for all of this

Why I ask myself (you) about this?

In many cases you will not have data for some fields and this is not problem regarding database but this can be problem when you present them. I don't like to see empty fields...

- Running the website like you have plan to do could cause that empty fields... but you will be able to make very complex (multi-criteria) query

- Going the other way, like I start empty fields will be minimized and still it will be possible to make multi-criteria query (but less criteria)

This is trade now

[CPUShack]

Having extra fields, blank or not, is wonderful when you add different sorts, searches, etc to your site.

Really better to have too much then too little

[6a6ar09a]

Well, I can have as much as I want... but this does not mean that it should be used if they are not necessary...

Agree with you but... Let say like this it could be better if;

not little at all but not too much too

P.S. I am afraid that I will latter spend to much time taking care and entering all this details