If you think that is wacky, look at IBM's Unidata. You have four basic datatypes, but you don't specify the length of the datatypes.
We are moving to a new business system that sits on Unidata. Queries are something else. You can't join tables (files). You have to run queries in a certain order to "join" tables. If you mess up, you have to start over. The worst part is you store denormalized data within a record. For example, you can have a multi-valued field that stored delimited data. If you have several multi-valued fields in a single record, you have to create an association between fields to ensure correct data extraction. Sheesh! -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, November 26, 2004 11:17 AM To: CF-Talk Subject: Re: OT - SQL Lite Paul Vernon wrote: > Do you mean SQLite and if so, it isn't an MS product.... Its neat > though, I've pluged it into my CFX_POP3 tag for the DB storage for the > bayesian filters.... > > It is *very* quick and by all accounts SQL 92 compliant for the most part... I wonder how a database that doesn't understand datatypes (no VARCHAR, no CHAR, no BOOLEAN, no BIT, no INTERVAL, no DATE, no TIME, no TIMESTAMP) can be called "compliant for the most part". Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185457 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
