is brew database preferable? | developer.brewmp.com is brew database preferable? | developer.brewmp.com

Developer

is brew database preferable?

Forums:

Hi All,

i m developing a bussiness application and therefore i need to store a huge amount of data on the handset device and access it throughout the application whereever it is required.
i was wondering whether using the brew database (idatabase, idbrecord ) apis will be an better option.

earlier i used to maintain my own text files for saving user data, therefore i was looking for some better option as managing files is becoming a tedious job.

my main concern is whether the brew database apis are standard across all brew phones..

Please let me know your views over this matter. it will guide me in improving my application design.

Pribhi

Use ISQL.. IDatabase is not suitable for large databases ..
Download ISQL from developer extranet

Use ISQL.. IDatabase is not suitable for large databases ..
Download ISQL from developer extranet

hi..
thanks for ur reply oceans eleven..
i have downloaded the ISQL extension but not able to use it.
i havent used extension in any of my applications before. actually i have no idea how to use the extensions in our own applications.
i wud be glad if some1 cud help me in using the extensions. any sample app or any detailed help documents will be useful..
Pribhi.

hi..
thanks for ur reply oceans eleven..
i have downloaded the ISQL extension but not able to use it.
i havent used extension in any of my applications before. actually i have no idea how to use the extensions in our own applications.
i wud be glad if some1 cud help me in using the extensions. any sample app or any detailed help documents will be useful..
Pribhi.

Using extension is just like using any other interface.
1
- Include the extension libraries (mod in target or dll files in simulator)
2
- Include the extension headers in your applications
- Use the extension functions (check the API documentation) just like various Interface functions being used (like ISHELL, IFILEMGR etc).
Check this link http://www.developer.com/ws/brew/article.php/3499241 for more information on extensions..

Using extension is just like using any other interface.
1
- Include the extension libraries (mod in target or dll files in simulator)
2
- Include the extension headers in your applications
- Use the extension functions (check the API documentation) just like various Interface functions being used (like ISHELL, IFILEMGR etc).
Check this link http://www.developer.com/ws/brew/article.php/3499241 for more information on extensions..

How large does a database have to be on the device to consider using ISQL instead of IDatabase?

How large does a database have to be on the device to consider using ISQL instead of IDatabase?

For your info:
Brew SQL Extension 1.0.x requires BREW 3.1.4 or higher.
Brew SQL Extension 1.1.0 and above, requires BREW 3.1.5 or higher.
Please see release notes of the specific Brew SQL extension to know the exact BREW version requirements.
UiOne components are not available OTA, and neither is ISQL. So the device would need to already support ISQL. If it does not, the requiring app will fail on NSTL testing.
1. Which handsets (if any) come preloaded with ISQL? Even many of the latest BREW 3.1.5 handsets don't.
[Atul] All handsets supporting uiOne SDK 1.3.0 or above. uiOne SDK 1.3.0 incorporates Brew SQL extension 1.1.0. Please see Devi pack (Device Specification\Device model info\uiOne SDK version) to check the uiOne support.
2. Since ISQL is not available OTA, does that mean a multi-mod approach is acceptable and the only solution?
[Atul] No, it is not possible to include the extension in a multi-mod submission. The BDS keeps track of all class IDs, across all submissions (including multi-mod). Even if one developer were able to submit using the extension, they would now “own” the class ID, and no one else would be able to submit.

For your info:
Brew SQL Extension 1.0.x requires BREW 3.1.4 or higher.
Brew SQL Extension 1.1.0 and above, requires BREW 3.1.5 or higher.
Please see release notes of the specific Brew SQL extension to know the exact BREW version requirements.
UiOne components are not available OTA, and neither is ISQL. So the device would need to already support ISQL. If it does not, the requiring app will fail on NSTL testing.
1. Which handsets (if any) come preloaded with ISQL? Even many of the latest BREW 3.1.5 handsets don't.
[Atul] All handsets supporting uiOne SDK 1.3.0 or above. uiOne SDK 1.3.0 incorporates Brew SQL extension 1.1.0. Please see Devi pack (Device Specification\Device model info\uiOne SDK version) to check the uiOne support.
2. Since ISQL is not available OTA, does that mean a multi-mod approach is acceptable and the only solution?
[Atul] No, it is not possible to include the extension in a multi-mod submission. The BDS keeps track of all class IDs, across all submissions (including multi-mod). Even if one developer were able to submit using the extension, they would now “own” the class ID, and no one else would be able to submit.