Modules/sqlite3
From the makers of InspIRCd.
(Redirected from SQLite3 Service Provider Module)
| Description
|
| This module is a service provider module, which means it has no real directly usable functions of its own, however it provides an essential service which is used by other modules. This module allows other modules to access SQL using a unified interface, minimizing the number of persistent connections and abstracting the actual database software from the SQL queries sent to it. |
| Configuration Tags
|
To use this module you must define one or more database connections, using tags like the one below:
<database hostname="/full/path/to/database.db"
id="anytext">
The variables in the tag have the following meanings:
You may define as many databases as you wish, but remember it is most secure to only define ones that your modules will actually use. |
| Additional Modes
|
| None |
| Additional Commands
|
| None |
| Special Notes
| ||
| SQLite3 databases are not very resource intensive in terms of memory usage or CPU, however they are usually for local use only. If you want to use a remote database, with more resource intensive operations (eg. date manipulation, string functions etc.) and advanced features like views, stored procedures and triggers, you should consider the m_mysql or m_pgsql modules.
Because SQLite databases are local, and don't require sockets or other marshalling code, queries to SQLite databases will block. This will not usually be an issue, especially due to the efficient design of SQLite, however you should make sure your queries are optimized and as efficient as possible. See also: When to use SQLite
|
| Dependencies
|
| *SQLite v3.3 - The SQLite 3 Database Library |
