Languages

Menu
Sites
Language
[CLOSED] Quick question: Is built-in sqlite library compiled with multi-threading support?

From sqlite documentation about multi-threading, it says that multi-threading must be enabled at compile time. If yes, then one can choose which thread-safety level to use (including single-threading), otherwise all the threading option will return error at run-time.

So the quick question - is the built-in sqlite in Tizen, compiled with multi-threading support? I hope it does, so I can avoid embedding my own sqlite.c into the project.

Platform: Tizen Wearable 2.3.2, Gear S3.

cheers!

Edited by: James B on 24 Feb, 2017
List

Responses

2 Replies
Safwan

Hello James, As far as I've explored Tizen I didn't faced any positive or negative notice regarding multi-threading support for SQLite. What this API reference says is:

 

Tizen: SQLite

Implements a lightweight sql database within a library, widely used for embedded client-local storage.

Version: 3.7.13

 

Link:

https://developer.tizen.org/development/api-references/native-application?langswitch=en&redirect=%2Fdev-guide%2F2.3.1%2Forg.tizen.native.wearable.apireference%2Fgroup__OPENSRC__SQLITE__FRAMEWORK.html


History Of SQLite Releases says 3.7.13 was released on 2012-06-11.

Link: http://www.sqlite.org/chronology.html

 

As 'not supported' is not specified in the documents I've looked on, I guess as per default 'multi-threading support' should be availabe. You may try mailing directly to the mailing lists provided on the forum for assurance, if you really need that.

Mailing List:  https://www.tizen.org/community/mailing-lists?langswitch=en 

 

Bonus:

These documents on SQLite in Tizen seemed useful.   (I guess, you may have already checked them)

Sqlite: Managing the SQL Database

Complete tutorial for sqlite database CRUD operation and data access from Tizen native application

Guide to Developing Tizen Native Application Book (pdf, SQLite pages: 797-817)

Encrypted Database Tutorial

 

 

 

James B

Thank you Safwan.

I actually did an empirical test and confirms that sqlite is indeed compiled with threading enabled; at least for my platform and device. Not sure for other platform/version/devices.

This kind of thing is quite frustrating. If sqlite is a standard component of Tizen, then it should be documented exactly how it is compiled (or what is and is not supported), especially for package like sqlite because it has about a zillion build-time options. Even a note that "sqlite is compiled with default flags" is sufficient. Sure I can always drop sqlite.c into my project and include it in my build, but what's the purpose of having a "standard" component then?

Anyway, enough ranting, back to work.

cheers!