sqlite is not supported out-of-the-box with Vanilla. I did some testing with it a few months back and got it sort-of working, but it doesn't support some of the sql I was using and I ended up stopping the development so I could focus on ironing out more important bugs.
I still have plans to make sqlite and postgresql add-ons for Vanilla ... but that will happen after version 1 is released.
Comments