Database Articles

  Home arrow Database Articles arrow Page 6 - 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 - Unsupported SQL Commands


    (Page 6 of 6 )

    Each database seems to have its own interpretation of the SQL92 standard and SQLite is no different, so beware. Some deviations are understandable and stem from SQLite's embedded design scheme (such as lack of GRANT and REVOKE). Others might just be plain annoying.

    A list of SQL features supported by SQLite can be found at http://www.sqlite.org/lang.html.

    Information on SQL features which are currently unsupported by SQLite can be found at http://www.sqlite.org/omitted.html and http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSql.

    About the Author

    Timothy Boronczyk lives in Syracuse, NY, where he works as an E-Services Coordinator for a local credit union. He has a background in elementary education, over 5 years experience in web design and has written tutorials on web design, PHP, Ruby, XML and various other topics. His hobbies include photography and composing music.


    DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.
    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 5 - Follow our Sitemap