> The APIs dont provide any means to join the tables, you can
> not open more
> than
> one database at a time. these facts force you to design your
database
> tables
> in denormalized format.
The Sybase Ultralite software does this for you. The code you write
does not directly reference any Palm DBs, it just uses embedded SQL to
access your tables. You would write the SQL just like you would with
any relational database regardless witch platform you actually deploy
your application to (ie Win32, DOS, CE, Palm, RIM, ...)
Here is a couple of examples:
EXEC SQL
INSERT INTO ULIdentifyServer( "server_id" )
VALUES ( :sql_server_id );
EXEC SQL UPDATE ORDERS
SET "server_id" = :sql_server_id
WHERE "table_id" = :sql_table_id
AND "order_status" <> :sql_order_status;
JOINS:
EXEC SQL BEGIN DECLARE SECTION;
long sql_table_id;
long sql_pk;
EXEC SQL END DECLARE SECTION;
EXEC SQL
SELECT kp.table_id, min( "key_id" )
INTO :sql_table_id, :sql_pk
FROM KEY_POOL kp, KEY_POOL_TABLE kpt
WHERE kp.table_id = kpt.table_id
AND kpt.table_name = :sql_table_name
GROUP BY kp.table_id;
You have full access to the functions the database supports, like the
above min() function.
The file needs to be pre-processed and then compiled in with your
application. We have a CodeWarrior 5 plugin that automates this for
you. It will also add any files to the project that is required.
Since many of our applications need performance, the projects I have
worked on, queries on tables that contain over 15,000 rows had
sub-second response times! These have been running mainly on Palm III
and IIIx.
Any updates to the database are automatically flagged for
synchronization, which is also taken care of for you with any of the
major DBMS vendors out there.
I am happy to answer any questions people might have.
David Fishburn
Mobile and Embedded Computing (MEC) Sivision
Sybase
> -----Original Message-----
> From: Mandar Joshi [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 22, 1999 12:32 AM
> To: [EMAIL PROTECTED]
> Subject: Re: relational databases?
>
>
>
>
> Hi Michael,
>
> I dont have much idea about the Olite on Palm.
> But its quite tough job to implement relational database in
> the current
> palm
> database format.
> The APIs dont provide any means to join the tables, you can
> not open more
> than
> one database at a time. these facts force you to design your
database
> tables
> in denormalized format.
>
> Comments welcome.
>
> Mandar
>
> Michael McFarland wrote:
>
> > Is there a fast/easy way to manipulate relational
> databases (such as
> > Oracle Lite,
http://www.oracle.com/mobile/olite/html/olite35_ds.htm)
> > through the Palm SDK? Or how difficult is it to implement
> a relational
> > database type of structure based on the standard Palm
> databases? Any
> tips
> > or resources would be appreciated.
> >
> > Michael
>
>
