AltSQLite to Mobile Content

Andre Garzia soapdog at mac.com
Sat May 27 13:06:37 EDT 2006


Michael,

I think people on the list will be able to correct me if I speak  
something that has a better solution.

First thing I think you should decide is if you want to go with the  
online solution or the offline solution.


	THE ONLINE SOLUTION

the online solution is easier to implement for no PDA/PocketPC  
programming is involved. You do everything on the server. The bad  
side is that your mobile agent must be online for access the web app.  
If you're talking about Mobile SmartPhones, then almost all big  
carriers in the world have some cheap GPRS solution that enables your  
smartphones to access the net, or some convergence device sports gprs  
and wifi features.

For this approach you'll need to build a CGI like solution but your  
html output should be designed for tiny screens. What you'll do is a  
web conduit that will talk to your database and output the data to  
the web. Others in this list did this kind of tool for blackberries.

Some entrypoints for this are:

To learn Revolution CGI basics you can go to http:// 
www.hyperactivesw.com/cgitutorial/index.html

Microsoft is distributing a smartphone/pocketpc emulator that you can  
use to test your apps (if you're running windows).

I'll be giving a presentation on RevConWest that will present topics  
on WebApps, not specific for tiny screens, but that's the easy part.  
Maybe we'll meet there.


	THE OFFLINE SOLUTION

This solution is not what you might be looking because this will sure  
involve some third party program, coded by you or not. If all you  
want is to carry the data and access it without modification or  
syncronization with the Desktop version then you can choose which  
format you'll be translating your altSQLite data into. For example,  
if it is a simple contact database, then you can generate a CSV file  
and import it to most contact applications. So its not very hard if  
all you want is to view raw data. Now if you want to interact with  
the data, then, you're in a bad situation because you'll need to buy  
some app or to build it using some other language since Revolution  
has no engine for pocketPC.

You can always vote on feature request #1200 <http:// 
support.runrev.com/bugdatabase/show_bug.cgi?id=1200> and tell RunRev  
that you'd really like a WindowsCE engine.

Cheers
andre

On May 27, 2006, at 1:32 PM, Michael Mandaville wrote:

> Andre,
> That's terrific.   Do you have any guidelines or samples on this?   
> Or any
> direction that you can point me in?
>
> I'd really appreciate it.
>
> Michael
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution




More information about the use-livecode mailing list