Archive for the ‘database’ Category
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.
Posted in database, knowledge tree | No Comments »
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 ...
Posted in database, knowledge tree | No Comments »
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 ...
Posted in database | No Comments »