<?xml version="1.0" encoding="utf-8"?>

<!-- Copyright (c) 2007-2010 Nokia Corporation and/or its subsidiary(-ies) All rights reserved. -->

<!-- This component and the accompanying materials are made available under the terms of the License 

"Eclipse Public License v1.0" which accompanies this distribution, 

and is available at the URL "http://www.eclipse.org/legal/epl-v10.html". -->

<!-- Initial Contributors:

    Nokia Corporation - initial contribution.

Contributors: 

-->

<!DOCTYPE concept

  PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd">

<concept id="GUID-C9A1CC1E-2398-5887-8C64-7B8EE0B22022" xml:lang="en"><title>SQL

Interfaces</title><shortdesc>This document examines both SQL options in the Symbian platform:

Symbian SQL and SQLite.</shortdesc><prolog><metadata><keywords/></metadata></prolog><conbody>

<section id="GUID-C2260AFE-8003-45A7-A492-E98F6F4C7221"><title>Purpose</title> <p>If you are creating or porting an SQL capable

application to Symbian platform you should read this document to get a better

understanding of the issues and options. </p> <p><b>Intended

audience:</b> </p> <p>This document is intended to be used by Symbian platform

licensees and third party application developers. </p> </section>

<section id="GUID-A566BEF7-254D-4AFE-BF06-7EB7B9E79F8C"><title>Introduction</title> <p>Symbian platform exposes two interfaces

to SQL: </p> <ol id="GUID-EC4FEAFB-BF19-5B50-9375-D01DE46B93FF">

<li id="GUID-6503D03A-7D56-5D90-A0A9-A22BB47292F3"><p>the Symbian SQL component

of Symbian platform </p> </li>

<li id="GUID-D30E8F76-CCC4-556C-9082-1B823875017F"><p>the open source SQLite

3 API. </p> </li>

</ol> <p>If you are developing an application for Symbian platform which involves

accessing a database with SQL you must decide which of these interfaces to

use before you begin. This is for two reasons. </p> <ol id="GUID-DBDCA7D4-3CC9-5D98-A159-A0BE9BA579F5">

<li id="GUID-AB276B85-649B-5711-9FF8-554A1F4D1A2A"><p>It is not possible to

access the same database with both interfaces, whether concurrently or not. </p> </li>

<li id="GUID-EEA6698B-9407-5EB7-AF61-E78325A5E187"><p>The two interfaces are

different and do not have identical functionality. </p> </li>

</ol> <p><b>Choose

an SQL interface</b> </p> <p>Here is a simple set of rules to help you select

the interface most appropriate to your development needs. </p> <ul>

<li id="GUID-8D28DF39-824E-5E0A-801B-33CB924BF406"><p> <xref href="GUID-1F12E3F5-45B2-55EC-B021-00338277C608.dita">Symbian

SQL DB</xref> if you are developing a new application for the Symbian platform </p> </li>

<li id="GUID-83033CC7-D55F-5C96-9BB1-DC1A6B00ECA1"><p> <xref href="GUID-5CA62D99-15E2-5556-966F-CFC3FCE3B246.dita"> SQLite</xref> 3

interface if you are porting an existing SQLite application written in C </p> </li>

</ul> </section>

<section id="GUID-446D6569-74E5-4577-9F2D-EB6177767A43"><title>Advantage of Symbian SQL</title> <p>The advantages of using

Symbian SQL to develop a Symbian platform database application are its close

integration into the Symbian platform as a whole and the consequent robustness,

efficiency and security that this provides. </p> <ul>

<li id="GUID-0F131E72-2374-5E23-B675-790D0B5C2861"><p>Symbian SQL is robust

because applications are isolated from the server. Errors in the application

do not affect the server and vice versa. </p> </li>

<li id="GUID-9E6100F8-2D80-574D-9252-9E893C877628"><p>Symbian SQL is robust

because an application can be configured to be included in database backup

and restore. </p> </li>

<li id="GUID-2BC27055-6799-5FA7-82BB-E353B2587CC3"><p>Symbian SQL is efficient

because multiple applications share one instance of a database cache. The

server has a single connection to the file system and there is no need of

multiple caches that duplicate the use of memory. </p> </li>

<li id="GUID-B3FD8457-9107-5EB6-817D-B7226C41A8FA"><p>Symbian SQL is efficient

because the single connection from the server to the file system eliminates

the need for mutexes. This makes efficient use of kernel resources. </p> </li>

<li id="GUID-61CAB80A-1A51-5CF4-B9BC-2529269046DC"><p>Symbian SQL is efficient

because it sets up a soft heap limit. This means that the server reuses free

memory before it attempts to allocate more. The limit may still be overridden,

for example when a blob or a large text column is accessed. This limits RAM

usage. </p> </li>

<li id="GUID-33FF23F0-96DF-5FB2-A300-82D59D44C6E9"><p>Symbian SQL is efficient

because it provides asynchronous APIs. This allows the application to make

a database call and perform other work while it waits for the call to return. </p> </li>

<li id="GUID-AA010085-DA9F-5944-AC8D-28A07BB5FBA6"><p>Symbian SQL is efficient

because the server is single threaded and no file locking mechanism is required. </p> </li>

</ul> </section>

<section id="GUID-ED633559-1D6D-4D35-A903-92CB758B3275"><title>Advantages of SQLite 3 API</title> <p>The advantages of the

SQLite 3 API are its open source status, excellent documentation, widespread

use and large developer community. For a single cross platform application

written by a team of developers it may not be worthwhile mastering the C++

interface and to use the SQLite 3 API instead. </p> <p>The SQLite 3 API exposes

many functions not available in Symbian SQL, particularly the SQLite C extension

API. However, it should be noted that Symbian SQL provides several built-in

collation functions and a built-in implementation of the LIKE operator. </p> <p>SQLite

3 API supports multi-threaded applications and provides concurrent database

access. </p> </section>

</conbody><related-links>

<link href="GUID-22844C28-AB5B-5A6F-8863-7269464684B4.dita"><linktext>SQL Overview</linktext>

</link>

<link href="GUID-5CA62D99-15E2-5556-966F-CFC3FCE3B246.dita"><linktext>SQLite Overview</linktext>

</link>