ODBC and Mobile Devices

[xclntdesign]

Does ODBC work with mobile devices (iPhone, Android, Windows Mobile, etc)? If so, which drivers do they support?

I'm creating an application that requires a local database for offline work and I am trying to come up with the best viable cross-platform solution.

If anyone has any other ideas that may work better, please let me know. I've been tossing around the idea of encrypting/decrypyting an XML file (databases will container user info, so they must be secured somehow) if I can't get the databases to work, but I'd much rather use an Access database.

[Klaus]

Hi xclntdesign,

database access is made possible with externals which are not yet supported in LiveCode iOS!

The upcoming version 4.6 will start to support externals and will come with support for SQLite
(and RevXML and RevZIP). The version is supposed to be released at the end of this month.

Hope that helps.


Best

Klaus

[xclntdesign]

So the upcoming version will support SQLite, no Access or Filemaker?

[Klaus]

SQLite, just as I wrote, nothing more but also nothing less!

[MrWizard]

Will externals be supported in the Android and Mindows Mobile releases at the same time as iOS? Easy local data storage is a MUST.

[FourthWorld]

Easy local data storage is a MUST.

If you don't need relationality, you should be able to use a text file, array file, or stack file for local storage.

[MrWizard]

Well, yeah, you can use a text file...but even for a single table db it is so easy to call "SELECT * FROM mytable WHERE id = 234" than to manually parse a text file. Also SQLite supports BLOB data easily, a text file would require encoding any binary data manually.

To be honest, I am interested in external support for more than just database support. There is just such a wealth of existing C/C++ code to perform so many calculation intensive tasks.