Database Articles

  Home arrow Database Articles arrow Page 2 - PEAR::SQLite: The Lightweight Alternat...
DATABASE ARTICLES

PEAR::SQLite: The Lightweight Alternative
By: bluephoenix
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 1
    2004-02-22

    Table of Contents:
  • PEAR::SQLite: The Lightweight Alternative
  • Installing PEAR::SQLite
  • Connecting to a Database
  • Queries
  • Composite Code
  • Unsupported SQL Commands

  •  
     

    SEARCH CODEWALKERS

    TOOLS YOU CAN USE

    advertisement

    PEAR::SQLite: The Lightweight Alternative - Installing PEAR::SQLite


    (Page 2 of 6 )

    The SQLite wrapper is not part of a default PEAR installation but can easily be installed. Pear can download the SQLite package, compile the library files and install them with a few simple console commands.

    [root@example www]# pear download SQLite
    File SQLite-1.0.3.tgz downloaded (371189 bytes)
    [root@example www]# pear install SQLite-1.0.3.tgz

    SQLite is now available in the DB branch of PEAR.

    <?php
    require_once "DB.php";
    require_once 
    "DB/sqlite.php";
    $db = new DB_sqlite();
    ?>

    While some might say I go to extremes, I like to keep my files organized. It's nice to see such directories as css/, data/, devel/, imgs/ and lib/ when I log in as opposed to a glob of different files all having a party in the root directory of my account. Be sure to create a directory for SQLite's database files and make it writable.

    [user@example www]$ mkdir dbase
    [user@example www]$ chmod +w dbase

    More Database Articles Articles
    More By bluephoenix

    blog comments powered by Disqus

    DATABASE ARTICLES ARTICLES

    - Completing a Book Inventory Management System
    - Uploading Images for a Book Inventory Manage...
    - Finishing the Add Book Story for a Book Inve...
    - Integration Testing for a Book Inventory Man...
    - User Stories for a Book Inventory Management...
    - Unit Testing a Book Inventory Management Sys...
    - Testing a Book Inventory Management System
    - Implementing Models for a Book Inventory Man...
    - Book Inventory Application: Publishers and B...
    - Handling Publishers in a Book Inventory Mana...
    - Publisher Administration for Book Inventory ...
    - Book Inventory Management
    - Using the SQL Reference Manual
    - Using Oracle SQL Developer with SQL Statemen...
    - Fixing Errors with Oracle SQL Developer


    © 2003-2012 by Developer Shed. All rights reserved. DS Cluster 11 - Follow our Sitemap