I'm losing patience with sqlite. I've been working on Spyce examples using postgresql, but now that I'm getting close to releasing Spyce 2.1, I figured I'd better convert the examples to use sqlite since that's such a no-brainer to set up.
It has been a frustrating experience.
Weird-assness I've run into includes
- "int" is not the same as "integer" (always use the latter to avoid unpleasant surprises)
- It's impossible to get useful information about column DEFAULTs programmatically
- There's a bug in the parsing of some three-way joins
And I didn't think I was doing anything very complicated! My examples have three tables at most!
Really my overall impression is one of a "0.9" product at best. I'm amazed that so many people appear to use this festering pile of gotchas in production.