Tuesday, June 22, 2010

Introduction to Databases

Add on the Firefox Database Manager: SQLight Manager.

Start by creating a schema for your data.
Every table within your database will have an ID as the first column of your table. This should be the primary key for that table.
You should think about how different tables map to each other and if each column of your table should have unique values or not.

Some documentation is here: http://www.postgresql.org/docs/8.4/interactive/datatype-numeric.html

No comments:

Post a Comment