CodeIgniter 2.1 and SQLite, how is it doing ?

[eluser]Unknown[/eluser]
Hello !

I've done quite a lot of research and tests about SQLite3 support in CI 2.1... There are a few posts and wiki entries about it, but now I'm totally confused...

Q1. Is SQLite3 supposed to be supported by CI or not ?

Q2. It seems that the PDO driver doesn't work properly with SQLite databases (this thread reports the problem : http://ellislab.com/forums/viewthread/206124/ ).
Are there really only these two workarounds ? (using simple_query or setting the num_rows method to return -1)
Isn't there something that would allow to use SQLite databases without loosing some functionality ?

Q3. How is this going to evolve in future versions of CI ?


CodeIgniter is a great very light framework, and SQLite is a great very light database system, it would be awesome if they worked together out of the box !

Best regards,

Olivier