Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Native Development

Reply
New Developer
Posts: 92
Registered: ‎01-23-2009
My Device: Z10
My Carrier: klarmobil
Accepted Solution

SQL databases in BlackBerry 10

What kind of SQL database uses BlackBerry 10? It seems it is not SQLite. The docs (https://developer.blackberry.com/cascades/documentation/device_platform/data_access/working_with_sql... are not very helpful about anything more than a trivial example and I would like to know what is possible regarding data types and DDL. Thanks in advance.

Developer
Posts: 6,473
Registered: ‎12-08-2010
My Device: PlayBook, Z10
My Carrier: none

Re: SQL databases in BlackBerry 10

I'm not sure why you say "it seems it is not SQLite". I'm fairly sure it actually is.

Peter Hansen -- (BB10 and dev-related blog posts at http://peterhansen.ca.)
Author of White Noise and Battery Guru for BB10 and for PlayBook | Get more from your battery!
Developer
Posts: 60
Registered: ‎04-18-2012
My Device: BB10 Dev Alpha C
My Carrier: T-Mobile

Re: SQL databases in BlackBerry 10

It's SQLite, Cascades offer own interface to access DB, but you can use standard QtSql module too.
--
Oleg Shparber
New Developer
Posts: 92
Registered: ‎01-23-2009
My Device: Z10
My Carrier: klarmobil

Re: SQL databases in BlackBerry 10

Well ... "VARCHAR(50)" ... as used in example let me think of something else than SQLite.

Highlighted
Developer
Posts: 6,473
Registered: ‎12-08-2010
My Device: PlayBook, Z10
My Carrier: none

Re: SQL databases in BlackBerry 10

SQLite does support VARCHAR and many other things, even if they're not (as you probably knew) that widely used in SQLite work. See http://www.sqlite.org/datatype3.html#affinity and the section 2.2 Affinity Name Examples.


Peter Hansen -- (BB10 and dev-related blog posts at http://peterhansen.ca.)
Author of White Noise and Battery Guru for BB10 and for PlayBook | Get more from your battery!