That being said, VistaDB is WAAAAAYYYYY better than SQLite... There's no comparison. Broken skateboard and space shuttle.
At $1295 for a license, I should hope so...?
Well, I didn't pay that. I've had a license for a long time, so I only had to maintain it with 'upgrade protection', which expired last week. For the next year => $300.00 -- Which is fine. I like to support good software that I like. It's a fantastic product, and for mISVs (that would be many of the people here), you can get it for much less than $1295. They have a mISV program. Face it, $1,295 is jack all for a company for a product of that caliber, but for a 1-man-band, it's a big chunk of change. Again, their licensing policy is fair and helpful, which only makes me more prone to keep with the upgrades.
But yeah... you definitely get what you pay for.
Integer, None, Text, Real, and Numeric just make me cringe. I like my DateTime and Bit types (amongst others).
It basically makes me feel dirty to store a datetime in a text field. Ick... So I'm not too broken up about abandoning SQLite. I've used it in a mobile SDK for testing, but the SDK was very kind and hid all that nasty dirtiness.