×

Discussion Board

Results 1 to 4 of 4
  1. #1
    Nokia Developer Champion
    Join Date
    Jun 2008
    Location
    Noida,India
    Posts
    4,073

    using database API's

    Trying to utilize symbian database API RDbNamedDatabase. While going through various threads, found that these native API's does not allow one to connect tables within a database, though they have a method to fetch the table names etc(seems to be a bit irony, as what would one do with multiple table if they cannot be connected?, please correct if i am wrong as i am a no db expert).

    So am i left with only option to utilize the open source database SQLiteS60 available from SourceForge or are there options available to connect tables elsewhere?

    NOTE: i need give support from S60 3rd FP1 devices till S^3( tried looking at RSqlDatabase class, but its from S60 3rd FP2 onwards) for a Non-Qt application
    Last edited by vineet.jain; 2012-05-07 at 21:04.

  2. #2
    Nokia Developer Moderator
    Join Date
    Feb 2006
    Location
    Oslo, Norway
    Posts
    28,734

    Re: using database API's

    Quote Originally Posted by vineet.jain View Post
    Trying to utilize symbian database API RDbNamedDatabase. While going through various threads, found that these native API's does not allow one to connect tables within a database, though they have a method to fetch the table names etc(seems to be a bit irony, as what would one do with multiple table if they cannot be connected?, please correct if i am wrong as i am a no db expert).
    That is true. However you can still connect them in your code at C++ level.
    So am i left with only option to utilize the open source database SQLiteS60 available from SourceForge or are there options available to connect tables elsewhere?
    If you want SQL-level joins and multi-table operations, yes.
    NOTE: i need give support from S60 3rd FP1 devices till S^3( tried looking at RSqlDatabase class, but its from S60 3rd FP2 onwards) for a Non-Qt application
    I remember that one of the first success stories with Open C/C++ was about porting Berkeley DB, http://www.nokia.com/NOKIA_COM_1/Dev...ucc_Oracle.pdf but I do not know if the actual port is available somewhere.

  3. #3
    Nokia Developer Champion
    Join Date
    Jun 2008
    Location
    Noida,India
    Posts
    4,073

    Re: using database API's

    I actually wanted to avoid hassles which come across while using OpenC/C++. Had a bad experience with OpenC/C++ while using it with SOAP web-services. So i think the only option i am left(if i do not go with OpenC options) with is to manipulate the code by own to join tables or to use a single table(just hoping that it does not makes the program slow).

  4. #4
    Nokia Developer Moderator
    Join Date
    Feb 2006
    Location
    Oslo, Norway
    Posts
    28,734

    Re: using database API's

    Remember that in this use case everything happens locally. So putting load on the "server" (if there would be joins) versus putting load on your client (coding joins with for loops over RDbRowSet-s) will result in more or less the same performance. Especially since the RDbs-thing is not open for 3rd-parties, so you can use the RFs-thing only (or the RDbStoreDatabase), thus not even IPC will cause performance loss, because the DB engine will be running in your own process (so there is no "server" in fact).
    (In contrast to a "real" remote databasing scenario, where your phone could put the workload on some power-house database server).

Similar Threads

  1. [moved] Why the difference in response using HTTP Api's and RSocket API's?
    By newbie2201 in forum Symbian Networking & Messaging (Closed)
    Replies: 8
    Last Post: 2010-02-19, 18:39
  2. Replies: 4
    Last Post: 2009-12-19, 15:35
  3. How to communicate with a web database to read/write data from/to database.
    By kuddy_abc in forum Symbian Networking & Messaging (Closed)
    Replies: 3
    Last Post: 2009-08-08, 20:45
  4. HIgh Level API's Vs Low Level API's
    By saravanak8 in forum Mobile Java General
    Replies: 5
    Last Post: 2007-10-17, 10:30
  5. Replies: 1
    Last Post: 2007-09-05, 10:53

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
×