Okay, I'm new to blackberry development and I was wondering if anyone could give me a list of database options available for blackberry applications? What do developer's "normally" do when faced with the requirement of utilizing a server for their blackberry applications? Is there any one specific database that is used for a majority of the applications (like Oracle?) out there now for blackberry? I did a Google search, but all I got back was old stuff that I'm sure has improved by now. I'm looking for some tutorial or explanation on how to remote connect to a database. Thanks for any help and advice you can give to a new blackberry developer!
+3
A:
Blackberry OS versions 5 and up include SQLite on the device. All devices have a proprietary storage mechanism called the Persistent Store. (You may have to use it if you need broad device support). There also the old cruddy J2ME 'record store' mechanisms.
seand
2010-09-14 02:17:19
A:
Check out this answer for more database options for devices running an OS version less than 5 (i.e. your friend's 8120).
Marc Novakowski
2010-09-14 05:02:26
+1
A:
Hi Josh,
I'd direct you to this page. It lists the current storage solutions for the Blackberry, and allows you to choose the best one for you.
Data Storage Overview - BlackBerry
As one previous poster suggested, SQLite is certainly a good option. It will allow you to have the flexability to use the same Database framework for other mobile apps - Android, iOS and Symbian all have the ability to use SQLite.
However, SQLite does come with some drawbacks. Query size, and pre-loading the database into RAM are probably the biggest two (so big queries and databases can be tricky) as well as the fact that your app will not be available to any pre-OS5 phones.
You should refer to this page for more information on that.
Hope this helps,
Stuart
Spedge
2010-09-15 11:08:59