dbaseSQL/SQLTXT Driver for TWIG ------------------------------- The dbaseSQL/SQLTXT driver for TWIG allows TWIG to use standard DBF files to store it's feature information in instead of a SQL server. dbaseSQL/SQLTXT does this by creating a SQL parser and associated database related functions to support them. The codebase is reasonable large and as such adds overhead to the execution of TWIG. Additionally DBF files are not optimized for the kind data access twig does in some of it's features (like news and schedule) and as such will increase the load on the server. INSTALLATION ------------ To install SQLTXT do the following: 1) Ensure You have PHP Version 3.0.11 or above. 2) edit twig's config/dbconfig.inc file as follows: $dbconfig["sqlserver"] = ""; $dbconfig["sqlport"] = ""; $dbconfig["sqlusername"] = ""; $dbconfig["sqlpassword"] = ""; $dbconfig["defaultdb"] = "/home/share/htdocs/twig/lib/db/sqltxt/dbf/"; $dbconfig["sqltype"] = "dbasesql"; defaultdb should be the complete path to your TWIG installation, including a trailing slash. Also make sure the table names are the default set to the defaults as shipped with twig, otherwise TWIG will fail to find the databases correctly. 3) Make sure that the db user has read write address to the databases, otherwise TWIG will fail when adding entries. 4) done. Administration -------------- dbaseSQL/SQLTXT has an administration page in the standard TWIG administration module. On the admin page are two options: 1 - Create db's, this will allow you to recreate blank databases. 2 - Pack db's, this will remove deleted items from the dbf files. When you delete entries in dbf files they are only flagged as deleted, only when an administrator pack's the db does the entry actually get deleted. Packing db's requires exclusive access, so make sure no one is access the dbf files from TWIG (easiest way is to stop the web server).