07-29-2008 03:31 PM
Has anyone looked into getting sqlite onto the BlackBerry platform? I am no database expert (so I don't know about its merit), but I see a few open source projects are already adopting it (Mozilla for one and two other "open" mobile platform Android and Symbian.)
Just for those who are not familar with sqlite, it is "a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine" (whatever that means.) And the entire source code is in public domain (so not anything like GNU or Apache licence) available in C, so I don't really see a reason not to adopt it to make cross platform developers' life easier (as least for simple applications). http://www.sqlite.org/about.html
And yes, I am aware of existing solution providers for database (as mentioned here http://supportforums.blackberry.com/rim/board/mess
07-29-2008 03:56 PM
07-29-2008 04:05 PM
...would mean porting it from C to J2ME which, from looking at the SQLite source, would probably not be a fun task.
That's probably true if it's up us lowly developer... :-) But I would have guessed that RIM can do it relatively easily. I know the API is exposed to developers in Java, but it's hard to believe that RIM doesn't use C or C++ to optimize the backend.
07-29-2008 04:47 PM
10-24-2008 05:16 PM
I read something about sqlite support announced at the Blackberry DevCon just recently. Will this be released as a separate library jar that we can use in our blackberry apps? or be a part of the next version api? I really really hope it's not the latter. When will this be available? Any info would great. Thanks.
Please hurry and bring sqlite support to Blackberry.
10-24-2008 08:52 PM
Can someone post any example of a realistic legitimate application for a handheld device with <1mbps of IO, a few meg;s of ram, no disk, difficult user IO, for a real database that you couldn't do better with a few indicies and a random access file or hash table?
10-29-2008 01:00 PM
Could you please clarify what you mean by next release? 4.8? Thanks.
The only semi official reporting of this comes from one line:
"The company is developing an API called SQLite to make more advanced links into corporate or Web databases."
10-29-2008 02:26 PM
It was stated pretty clearly in a futures session that the next iteration of the software platform there will be a fairly complete implementation of the SQLite RDBMS included. I believe they said it would be a native code implementation and not a port to Java.
This was actually demonstrated at the conference at one of the sessions.
10-29-2008 11:53 PM