I'm just working on putting together the table for blog posts on my site.
I know how to use SQL, and I know a bit about the different types and lengths, but I'm at a loss as to the best lengths and types for my table.
The way I currently have it setup is:
- id - BIGINT (20)
- author_id - BIGINT (20)
- title - text
- tags - VARCHAR (50)
- categories - VARCHAR (50)
- projects - VARCHAR (50)
Tags is a string array of tags for the post, the same with categories. Projects will be an array of ints, that are the ids for the "projects" that are associated with the post. (projects each have their own page about them, and when you go to the page you can get a list of all the posts about it).
My question is, what is the most optimized way I can setup this table?
UPDATE:
Currently I'm interesting in the best ways to store this and optimize disk usage. Right now I have a free x10hosting server I'm going to be using, which has a 512mb limit. If necessary I can pay for a larger server later on, but I want to stick with the free one till I max out my limits.