SQL Server Guide

This topic introduces you to the SQL server.

Purpose

THE SQL server is an implementation of SQLite v3.3.17.

SQL server services

SQL server performs the all SQL operations called from an application, including:

  • creating a SQL database,

  • opening an existing SQL database,

  • retrieving the last SQL error message,

  • executing 8-bit and 16-bit SQL statements,

  • setting the transaction isolation level,

  • retrieving the database security policy,

  • attaching additional SQL databases to the current connection,

  • detaching previously attached SQL database from current connection.

Platform Security

SQL server also manages all platform security related activities for secure databases including:

  • loading/storing database security policies when creating/opening a database connection,

  • asserting client rights to perform a specific database operation,

  • maintaining security related internal data structures.

Using the SQL server

The SQL server is started when an application attempts to:

  • create a database,

  • open a database,

  • copy a database,

  • delete a database.

The SQLDB.dll class RSqlDatabase invokes a call to start the server as soon as an operation is initiated that requires the database server. Your application must include the sqldb.lib library, instantiate the RSqlDatabase object and perform one of the operations listed above to start the SQL server.

See the Basic SQL example application for an example.

Once started, the server manages the SQL session and all SQL commands and operations sent as part of that session.