[BillCN]

Hello:

I have posted this question as part of another question I have had, but I thought it might be useful to create a new topic for it.

Basically, my question is: What database tools are available for MobiOne development? Does Genuitec have an in-house database tool, or do you recommend another?

If such a thing does exist, then other questions come to mind, such as:

1. Can the database tool reside on the iPhone itself? If so, what is its initial “footprint”? 1a. What might be the maximum number of records that the RDBMS can store (independently of memory limitations), if any?
2. If the RDBMS cannot reside on the device itself, then does Genuitec recommend any web-service providers, or does Genuitec offer data storage to its customers?

Any replies would be welcome!

Bill Colby-Newton

[BillCN]

Still looking for an answer to this question.

Hello:

I have posted this question as part of another question I have had, but I thought it might be useful to create a new topic for it.

Basically, my question is: What database tools are available for MobiOne development? Does Genuitec have an in-house database tool, or do you recommend another?

If such a thing does exist, then other questions come to mind, such as:

1. Can the database tool reside on the iPhone itself? If so, what is its initial “footprint”? 1a. What might be the maximum number of records that the RDBMS can store (independently of memory limitations), if any?
2. If the RDBMS cannot reside on the device itself, then does Genuitec recommend any web-service providers, or does Genuitec offer data storage to its customers?

Any replies would be welcome!

Bill Colby-Newton

[support-michael]

>Basically, my question is: What database tools are available for MobiOne development? Does Genuitec have an in-house database tool, or do you recommend another?

Yes, see the MyEclipse Professional or greater editions that include RDBM design and development tools for server-side and desktop databases. http://myeclipseide.com

>1. Can the database tool reside on the iPhone itself? If so, what is its initial “footprint”? 1a. What might be the maximum number of records that the RDBMS can store (independently of memory limitations), if any?

I’m not aware of any db tools that run on a device. I’m not saying there aren’t as the space is large and there are tons of OSS and startup efforts. iOS and android include implementations of sqlite rdb as well as other local storage mechanisms: See this before moving forward http://www.html5rocks.com/en/tutorials/offline/storage/

There are two webdb apis you can use choose from (both are javascript based):
1) w3c spec (deprecated) http://html5doctor.com/introducing-web-sql-databases/
Live example: http://playground.html5rocks.com/#async_transactions

2) Cordova / phonegap (native apps only) – http://docs.phonegap.com/en/2.9.0/cordova_storage_storage.md.html#Storage

I believe with ios6 max storage is 20mb per app (google to keep me honest). You need to be super sensitive that mobile devices have limited memory and cpu.

I recommend upgrading to MobiOne 2.5 milestone-1 and using the new Mobile Web Simulator that runs on Chrome. Chrome provides a very good inspector for viewing and interacting with a locally stored database in your app. You can find MobiOne 2.5 milestone-1 download link below the main production link at http://genuitec.com/mobile/download.html

[BillCN]

WAYNE! Thanks a million!

[Author]

Posts