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
georg
Posts: 86
Registered: ‎01-23-2009
My Device: Z10
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.

Please use plain text.
Developer
peter9477
Posts: 6,473
Registered: ‎12-08-2010
My Device: PlayBook, Z10

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!
Please use plain text.
Developer
trollixx
Posts: 60
Registered: ‎04-18-2012
My Device: BB10 Dev Alpha C

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
Please use plain text.
New Developer
georg
Posts: 86
Registered: ‎01-23-2009
My Device: Z10

Re: SQL databases in BlackBerry 10

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

Please use plain text.
Developer
peter9477
Posts: 6,473
Registered: ‎12-08-2010
My Device: PlayBook, Z10

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!
Please use plain text.