| 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. |
|