PHP Classes
Icontem

Class: SQLite DB Handler


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend!
      Classes of José Augusto Ferreira Franco  >  SQLite DB Handler  >  Download  >  Support forum Support forum  >  RSS 1.0 feed RSS 2.0 feed Latest changes  >  Stumble It! Stumble It!  >  Bookmark in del.icio.us Bookmark in del.icio.us  
  Supplied by   Group folder image Groups   Detailed description  
  Rate classes User ratings   Applications   Files Files  

  • Supplied by:

    Picture of José Augusto Ferreira Franco
    Name: José Augusto Ferreira Franco <e-mail contact>
    Published packages: 15
    Country: Portugal Portugal - PHP jobs in Portugal
    Home page: http://www.revista-php.net/
    Age: 31
    All time rank: 144
    Week rank: 79

    Browse this author's classes

  • Innovation Award:

    PHP Programming Innovation award nominee
    December 2005
    Number 4
    		 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

  • Groups:

    Group folder image Databases Database management, accessing and searching View top rated classes

  • Detailed description:

    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.

  • User ratings:

    There are not enough user ratings to display for this class.

  • Applications that use this class:

    No application links were specified for this class.
    Add link image If you know an application of this package, send a message to the author to add a link here.

  • Files:

    File Role Description
    Plain text file sqlite_class.php Class The main class
    Plain text file changes_example.php Example This file generalizes class last changes, with some short pratical examples
    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
    Image file example1.jpg Screen Sreenshot from result to example1.php
    Download all files: sqlite_db.tar.gz sqlite_db.zip
    NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  
For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2008 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products