can CI support sqlite?

[eluser]Unknown[/eluser]
hi all, can CI support sqlite?

[eluser]Phil Sturgeon[/eluser]
Yes indeed it can, along with MSSQL, MySQL, oci8, ODBC and Postgre.

[eluser]Derek Allard[/eluser]
Welcome to CI euclid! I know you've already got your answer, but I just wanted to add that sqlite is one of those databases that doesn't see too much use around here, and therefore hasn't gotten as "battle tested" as some of the other database libraries. Please report anything you find in there of note!

[eluser]Kenzie[/eluser]
Just to clarify, CI supports sqlite v2 out of the box, but needs the PDO drivers to work with v3.
See: http://codeigniter.com/wiki/PDO_SQLite3/

[eluser]Beano[/eluser]
You can integrate Doctrine with CI as well which also supports SQLite - you can download an integrated dev starter at http://thecodeabode.blogspot.com/2010/06...extjs.html.

If using sqlite in memory dbs (for unit testing etc) - a small mod is needed to support the dropping of sqlite in memory dbs. Get the code at http://thecodeabode.blogspot.com/2010/12...es-in.html