SQLite for BlackBerry

Question

Is SQLite available for BlackBerry ?

Is any other Database option available other than SQLite ?

score 5 · Answer 1 · answered Dec 09 '10 at 18:39

5

SQLite has been shipped in Blackberry 5.0; here is the link: http://docs.blackberry.com/en/developers/deliverables/8682/SQLite_overview_701956_11.jsp

answered Dec 09 '10 at 18:39

gadget00

301
6
18

score 3 · Answer 2 · answered May 11 '09 at 09:58

3

SQLite is scheduled to be released in the next version of the BlackBerry device software, no idea when that will be. Think they were scheduled to announce at hte recent WES event.

You could try using Sybase SQL Anwhere as it's available for Blackberry.

answered May 11 '09 at 09:58

Fermin

34,961
21
83
129

1

At WES 2009 they announced 5.0 (which will include support for SQLite) will be released in the fall of 2009. – Marc Novakowski May 18 '09 at 06:06
1

I wouldn't trust SQL Anywhere. The team I'm on couldn't get it to work properly, and the demo app crashed with Sybase demoed it to us. – Dan Gifford Apr 30 '10 at 13:28
So you vote me down for a 2 year old question that was applicable at the time but isn't now? – Fermin Jan 25 '11 at 16:20

score 2 · Answer 3 · answered Dec 16 '11 at 21:25

SQLite is available as of BlackBerry OS version 5.0. Here's the link for more information:

http://docs.blackberry.com/en/developers/deliverables/8682/SQLite_overview_701956_11.jsp

Please be aware that there are a couple of things you have to watch out for when using SQLite in BlackBerry development. One is that there is a known issue when writing a SQLite to internal memory of certain devices (ie; Bold 9700 series).

In terms of other options for databases on the BlackBerry, no. At least none that I'm aware of. You have to use SQLite. This isn't necessarily a problem as SQLite is efficient and has a small memory footprint.

In terms of other methods of storage, you could use the Persistent Store. This can be a little tricky, but you could use a Vector object to organize how you are storing data.

score 1 · Answer 4 · answered Sep 01 '11 at 17:43

As stated before: "SQLite has been shipped in Blackberry 5.0; here is the link: http://docs.blackberry.com/en/developers/deliverables/8682/SQLite_overview_701956_11.jsp"

but SQLite is also available in the WebWorks SDK. See: http://www.blackberry.com/developers/docs/webworks/api/Database.html

score 0 · Answer 5 · answered Sep 28 '12 at 11:02

0

I simply use txt files, it is a lot more complicated but the problem is some phones require a a memory card and others don't in order to use SQLite DB and the developers cant control whether the subscribers have a memory card or not.

answered Sep 28 '12 at 11:02

Nequita

89
7

How do text files act as a database? – Sep 28 '12 at 14:09

score 0 · Answer 6 · edited Apr 08 '12 at 15:16

0

Yes you can use Persistent Store for storing data in a Blackberry Application

see this Persistent data storage

edited Apr 08 '12 at 15:16

Lucifer

29,392
25
90
143

answered Mar 06 '12 at 11:08

Deepika

566
2
10

score -2 · Answer 7 · answered May 11 '09 at 09:11

-2

UltraliteJ is paid version for SQLite.

answered May 11 '09 at 09:11

iOSDev

3,617
10
51
91

Many forums say Sqlite soon to be launched for Blackberry...Any idea when it is going to be launched? – iOSDev May 11 '09 at 09:16
No, it's not. It's a version of one of SQLite's proprietary rivals, SQL Anywhere (by Sybase). – Matthew Flaschen May 11 '09 at 09:17
Yeah! So no chance to built a database like SqLite on Blackberry phones? – iOSDev May 11 '09 at 09:18
1

There obviously /is/ a chance, as seen by the blog post linked above and other posts elsewhere. But so far, it's vaporware. – Matthew Flaschen May 11 '09 at 09:19
That's a different question entirely, and the answer is not obvious (unless you want to pay for proprietary SQL Anywhere). – Matthew Flaschen May 11 '09 at 09:25
i m looking for an open source option so is there any other option available for me . – May 11 '09 at 09:30

SQLite for BlackBerry

7 Answers7

Linked