Title Gallery 2 SQLite backend
Student Brian Kirchoff
Mentor Tim Almdal
Abstract
Gallery 2 currently supports a number of databases for storage backend including MySQL, PostgreSQL and Oracle. SQLite is a new flatfile database system that is fast, simple and easy to use and is now included by default in new PHP installations. By adding support for SQLite to Gallery 2 as a storage backend it increases the number of people who will be able to easily install and use Gallery.

Deliverables for this project:
  SqLiteStorage class that extends GalleryStorage

  Implements SQLite Version 2 using ADODB and SQLite Version 3 with PDO driver added to ADODB

  SqLiteStorage will have to handle ALTER TABLE which is missing from SQLite by making a new version of the table and copying all the data.

  Add SQLite to DatabaseSetupStep class in Installer

  Test and Pass all 2200+ Unit Tests

Visit http://codex.gallery2.org/Gallery2:SoC-SQLite_Gallery_2_SQLite_Backend for more information about the project.