Archive for the ‘database’ Category

Improved Upgrade Utility

Monday, March 5th, 2007

The upgrade utility has been improved to provide a database backup and restore functionality. Before attempting any upgrade, it is always best to make a backup. The upgrade utility provides a very easy 'click-through' backup procedure, and the restore process is just as easy.

Bulk importing files and metadata

Thursday, February 22nd, 2007

I've added a script to the KnowledgeTree Forge to assist users in importing files and meta data from other systems. It relies on meta data files based on a .ini configuration file format: [invoice] invoice_date="2006-01-01" invoice_no="001002214" [client] client_name="joe bloggs" invoice and client are the names of field sets, and invoice_date, invoice_no and client_name are fields linked ...

Maintaining Database Referential Integrity

Saturday, February 10th, 2007

Never underestimate the value of time spent on database design. Unfortunately, sometimes people know the concepts as they are mostly logical, however the concepts are not always applied. Relational databases have some wonderful features that are not always utilised to the maximum. What might these be? The fundamental concepts behind ...