NewLC - DBMS Classes In Symbian - Comments

Re: DBMS Classes In Symbian

vin2ktalks — Mon, 19 Nov 2007 00:32:56 +0100

Hi dude, though you've replied for an old post I hope it'll be helpful to those of who have some doubt in this. . It would've been better if you can create an FN wiki page or an article on the NewLC. So that it will be reaching wide range of people and will be helpful to them.

Re: DBMS Classes In Symbian

srikanth_trulyit — Fri, 16 Nov 2007 19:35:27 +0100

What is the main difference between RDbNamedDatabase and RDbStoreDatabase classes in Symbian

RDbNamedDatabase provides shared access to the data in the tables.
Use it when data intense applications and multiple applications need data access.

RDbStoreDatabase provides a single thread access, in the sense only that application access from the thread.
Use it for simple data based applications

Why exactly two different classes provided?

From the beginning of database designs shared and exclusive accesses are treated separately. They are also divided depending on the intense of usage.

Is there any benifit for RDbStoreDatabase over RDbNamedDatabase class?

It depends on the thumb rule : "how u want it". If u need for a simple mapping purpose, RDbStoreDatabase serves ur purpose. If intense data transactions are required by multiple clients RDbNamedDatabase will help.
also when a file-store database is constructed using the RDbNamedDatabase interface, there is no access to the underlying store for compression.

and for ur question regarding lmitations on db plz refer SDK
Symbian OS v9.2 » Symbian OS guide » System libraries » Using DBMS » Interface to DBMS databases » Implementation limits
Hope it helps u.

Re: DBMS Classes In Symbian

vin2ktalks — Mon, 23 May 2005 15:02:11 +0200

Hi all,

I have some more doubts regarding the DBMS...

How many tables can we create in a single databse?
How many fields are possible to create In a single table? and
What should be the maximum length of a text field?

If anybody knows plz give me an answer...

DBMS Classes In Symbian

vin2ktalks — Tue, 12 Apr 2005 17:33:03 +0200