PHP Classes

SQLite DB Handler: Create and manage SQLite database files

Recommend this page to a friend!
     
  Info   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 1,304 All time: 2,963 This week: 455Up
Version License Categories
sqlite_db 1.0Artistic LicenseDatabases
Description 

Author

José Augusto Ferreira Franco

This class can be used to create and manage SQLite database files.

It can create databases tables from a list of field declarations passed as an array.

SQLite does not implement many types table alterations. This class can emulate table alterations by recreating a table with the altered fields and inserting the old table field values.

The class also supports a turbo mode by executing special pragma statements that can enhance the database access performance.

The class error messages can be generated in Portuguese (of Portugal) or English.

Innovation Award
PHP Programming Innovation award nominee
December 2005
Number 4

Prize: One book of choice by SAMS		 SQLite is an interesting flat file database management system. It does not require a database backend server, but it provides an SQL interface to access the database table data.

SQLite SQL dialect provides means to execute the most common SQL operations. However, the support for database schema management in the current SQLite versions is still deficient.

This class provides an alternative solution to perform many types of table schema alterations, equivalent to the use of the SQL ALTER TABLE statement.

Manuel Lemos
Picture of José Augusto Ferreira Franco
  Performance   Level  
Name: José Augusto Ferreira ... <contact>
Classes: 15 packages by
Country: Portugal Portugal
Age: 47
All time rank: 963 in Portugal Portugal
Week rank: 22 Up3 in Portugal Portugal Equal

Level 1 Star

 Innovation award
Innovation award
Nominee: 1x

Screenshots (1)  
  • example1.jpg
  Files folder image Files (4)  
File Role Description
Plain text file sqlite_class.php Class The main class
Accessible without login Plain text file changes_example.php Example This file generalizes class last changes, with some short pratical examples
Accessible without login Plain text file example1.php Example This short example shows the process required to build a table with class db from package SQLITE DB HANDLER

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadsqlite_db-2005-12-27.zip 53KB
Downloadsqlite_db-2005-12-27.tar.gz 53KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,304
This week:0
All time:2,963
This week:455Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.