I have been planning to add tested support for some DBDs to one of my pet projects. Sybase was my first choice, SQLite my second. I remember hearing Matt talk about SQLite in Belfast and decided to give it a quick test run. It seems to work just fine and I only had to change my SQL structure slightly to get the tables created. The actual data was left unchanged (which is a plus ofcourse). The only downside to SQLite at the moment is the locking problem. Whenever an active conenction is in place, you cannot connect to it again. The error is something like
Could not connect to Database: at Yada Yada.
Oh well.. I'll document it and will try to have a fix ready. More testing tomorrow. I plan to get a taste of Sybase during the weekend...