Features

mIRC SQLite

Features
SQLite Key Features
You might be wondering why I've decided to write a library for SQLite, and not for MySQL for example. The following list of features hopefully speaks for itself. I have made it brief purposefully, in case you want to read more about SQLite's features, read this: http://www.sqlite.org/different.html.
  • Serverless!
  • SQLite doesn't require a server to run as a seperate process/service.
  • No configuration needed!

  • You just connect to a specified database. That's it.
  • Fast!

  • SQLite is fast! To see user contributed speed comparisons, see: http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison.
  • Portable!

  • Because SQLite stores a database in a single file, it's very easy move databases around.
  • Compact!

  • SQLite is extremely small in size, which makes it painless to download.
  • Dynamic types!

  • SQLite implements so called manifest typing. You can insert any type of data to a table, regardless of the declared type.
    This is especially good for simplicity's sake, as you don't even need to declare a data type for columns.
  • Variable-length records!

  • Unlike many other SQL database engines, SQLite only stores as many bytes it needs.
    This results into smaller and more efficient database files.
mSQLite Key Features
So what about mIRC SQLite then? What does it offer?
  • Easy to use!

  • mSQLite provides a complete, easy to use and throughly documented API to interface with SQLite.
  • Hash tables!

  • When fetching rows mSQLite will store the results efficiently in a hash table.
  • Flexible error handling!

  • Every single mSQLite command updates the error variables, so you don't need to spend hours of time to debug an error.
  • Regular expressions!

  • SQLite doesn't support regular expression matching by default, but mSQLite adds support for them. You can use the REGEXP keyword to do a regular expression matches.
  • Binary data!

  • mSQLite extends the SQLite query syntax by implementing support for mIRC binary variables.
  • User defined functions!

  • mSQLite allows users to register their own functions and aggregates to SQL with an ease.
  • Garbage collecting!

  • In case you forget to free some resources, mSQLite will free them for you upon unloading!