Thank you for visiting the BlackBerry Support Community Forums.
BlackBerry will be closing the BlackBerry Support Community Forums Device Forums on April 1st (Developers, see below)
BlackBerry remains committed to providing excellent customer support to our customers. We are delighted to direct you to the CrackBerry Forums, a well-established and thorough support channel, for continued BlackBerry support. Please visit http://forums.crackberry.com or http://crackberry.com/ask. You can also continue to visit BlackBerry Support or the BlackBerry Knowledge Base for official support options available for your BlackBerry Smartphone.
"When we launched CrackBerry.com 10 years ago, we set out to make it a fun and useful destination where BlackBerry Smartphone owners could share their excitement and learn to unleash the full potential of their BlackBerry. A decade later, the CrackBerry community is as active and passionate as ever and I know our knowledgeable members and volunteers will be excited to welcome and assist more BlackBerry owners with their questions."
- Kevin Michaluk, Founder, CrackBerry.com
Developers, for more information about the BlackBerry Developer Community please review Join the Conversation on the BlackBerry Developer Community Forums found on Inside BlackBerry.
05-27-2011 02:43 AM
I'm a little confused as to which Sqlite database to use. I saw a article here in the forum that suggest I use the Sqlite plug-in from Firefox. But when I checked the version of it, I noticed it was version 3.7.4. When I go to the Sqlite website sqlite.org, I noticed the latest version is 126.96.36.199 and the sites suggest I use this version for new development.
1. If 188.8.131.52 is the current version, how do I install it, and is there a GUI interface for it like I see for the firefox plug-in?
2. Does anyone know when the firefox plug-in will be upgraded?
05-27-2011 03:36 AM
05-27-2011 06:06 AM
Does this help:
You can not upgrade the SQLite version installed on the BlackBerry device - it is packaged with the OS.
05-27-2011 10:54 AM
So, I can't create my database on my local machine and then copy it to the Blackberry?
I take it that I have to write JaveMe code using the (net.rim.device.api.database) API in order to create my database, create tables, and load data, instead of doing this on my local PC? I need to create some fixed tables of items, to perform calculations and I assumed I could create this on my local machine, and create my SQL statement as well, to make things easier before I test on the phone.
05-27-2011 11:48 AM
"So, I can't create my database on my local machine and then copy it to the Blackberry?"
I'm not an expert at this, but I can't see why not. I think the version number really reflects the functionality and fixes available. I think the underlying database is accessible regardless.
I have copied databases to and from the phone and used the same database on my PC and phone.
05-27-2011 04:28 PM
I'll guess my question now is, How do I get these version on my pc?
BlackBerry Device Software 6.0 uses SQLite version 3.6.21. BlackBerry Device Software 5.0 uses SQLite version 3.6.16.
05-27-2011 06:35 PM
So just to clarify my previous answer, you do not need that version of SQLite on your PC. Any SQLite supporting version will do.
I use this: