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!
- No configuration needed!
- Fast!
- Portable!
- Compact!
- Dynamic types!
- Variable-length records!
SQLite doesn't require a server to run as a seperate process/service.
You just connect to a specified database. That's it.
SQLite is fast! To see user contributed speed comparisons, see: http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison.
Because SQLite stores a database in a single file, it's very easy move databases around.
SQLite is extremely small in size, which makes it painless to download.
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.
This is especially good for simplicity's sake, as you don't even need to declare a data type for columns.
Unlike many other SQL database engines, SQLite only stores as many bytes it needs.
This results into smaller and more efficient database files.
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!
- Hash tables!
- Flexible error handling!
- Regular expressions!
- Binary data!
- User defined functions!
- Garbage collecting!
mSQLite provides a complete, easy to use and throughly documented API to interface with SQLite.
When fetching rows mSQLite will store the results efficiently in a hash table.
Every single mSQLite command updates the error variables, so you don't need to spend hours of time to debug an error.
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.
mSQLite extends the SQLite query syntax by implementing support for mIRC binary variables.
mSQLite allows users to register their own functions and aggregates to SQL with an ease.
In case you forget to free some resources, mSQLite will free them for you upon unloading!