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.

Comments On: PEAR::SQLite: The Lightweight Alternative

· Shouldnt the line in the first panel be$result = $db->query($query);and...    · You're right... There's actually another glitch, too. I wrote require_once...    · Remember that SQLite is embedded with PHP5 by default, so may not need to use...   >>> Post your comment now!