Preface and Information

mIRC SQLite is an implementation of the SQLite library for mIRC. It requires mIRC version 6.2 or higher.
It offers a flexible and easy-to-use API (Application Programming Interface) which is strongly inspired by the PHP's SQLite API.
This documentation has two purposes, first and foremost it works as a reference and secondly it has a lot of useful information on how to use the library. This includes explanation of features such as handling binary data with mIRC SQLite, registering and using user defined functions and aggregates, and how to handle errors.

This documentation is solely for documenting mIRC SQLite and assumes you are familiar with SQL already. It doesn't teach you SQL. You can find SQLite's documentation for the SQL language here: http://www.sqlite.org/lang.html.
If you're familiar with other SQL databases such as MySQL, but have no prior experience with SQLite, feel reassured. SQLite isn't that much different at all. However I strongly recommend you to read this short document so you'll get an understanding of what SQL features SQLite doesn't support: http://www.sqlite.org/omitted.html.

This library has no external dependencies aside from the script file and the DLL (msqlite.mrc and msqlite.dll respectively).
If you find any bugs, or have feedback and/or suggestions, please get in touch with me on IRC, or e-mail me at the above address.
IMPORTANT. When you send me an e-mail make sure to include the word "mIRC" or "SQLite" (without quotes) in the subject, otherwise my mail filter won't catch it.