Work on the ‘back-end’
Work on the ‘back-end’ is progressing.
The structure of the back-end database for the site has been fixed. There is now the problem of loading in all the data.
A few programs that have so far been used in the creation of the site:
- xcode 2.2 – This is an integrated development environment (IDE) for creating Mac OS X software. This is being used to develop code for parsing and editing data for including in to the database. xcode will also be used to develop update tools for the site and programs for accessing and viewing data. A really useful ‘add on’ is the SMySQL framework which allows direct ‘communication’ between code developed in xcode and MySQL databases (see http://mysql-cocoa.sourceforge.net/).
- BBEdit – This is a fantastic text editor and it is the main program used for editing php and HTML, and also constructing some of the database sql.
- XERD – A really useful program for developing the database structure. However, the program is no longer developed so I guess a replacement will have to be found.
- CocoaMySQL – this program allows the viewing and editing of MySQL databases. This is a remarkably useful program!
- Fetch – A great ftp client for uploading and downloading files from the server.
- Ecto – The software used to write the blog….
- MySQL – The database!
