Good Morning.
To date, I know of the following applications written using UltraLite:
Restaurant
Inventory management (uses the Symbol/Palm devices)
Healthcare
Travel
Golf
Lookup times with the Symbol scanning devices (while scanning UPC
codes) was sub-second on 15,000 rows in the table.
You have asked about dataset sizes, it all depends on what you run out
of first memory of software limitations.
You can have 65,000 tables
and 65,000 rows in each table.
You tune the database just like any other database, indicies, primary
keys, check constraints, ...
You can use any of the datatypes that ASA (Adaptive Server Anywhere)
supports:
char, varchar, long varchar
binary, varbinary, long binary,
bit, tinyint, smallint, integer, bigint (64)
date, time, datetime, timestamp
numeric, decimal
float, real
Probably the most impressive feature is the ability to exchange data
with any of the main DBMS vendors:
Sybase (ASE, ASA)
Oracle
DB2
Microsoft SQL Server
This means your applications will work against whatever backend your
clients are using, they are not locked into using Sybase.
We have written the database portion once, and then simply wrote
different front ends for the different devices (CE, Palm, ...).
Evaluation copies are available:
http://www.sybase.com/products/anywhere/index.html
Since I have developed/invloved with the above projects, I am happy to
answer any questions.
Here is another website for someone who currently has a golf
application.
http://www.scorecardpro.com/
David Fishburn
Principal Technical Consultant
Mobile and Embedded Computing (MEC) Division
Sybase
> -----Original Message-----
> From: Samir Raiyani [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 22, 1999 12:57 AM
> To: [EMAIL PROTECTED]
> Subject: RDBMS choices - Oracle Lite or Ultralite (was: relational
> databases?)
>
>
>
>
>
> I had a few questions on this subject:
> - What are the biggest data sets stored on Sybase Ultralite?
> - What are the biggest data sets stored on Oracle Lite?
> - Does anyone have good/bad application development
> experiences on either
> of these platforms?
> - There have been a couple of other "independent" initiatives
> posted on
> this list for providing RDBMS functionality on the Palm
> platform. Does
> anyone know of these?
>
> I will be grateful for any data whatsoever for these questions.
>
> Thanks much!
> Samir
>
> Mandar Joshi writes:
> >
> > 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
> >
> >
> >
>
>
