What is the best way to collect data for iphone sqlite db

Question

I want to build an iphone app with data pre-filled sqlite db. But how to fill data in the beginning comes to be a small problem.

My partner and I may both need to access the db and edit data.

I thought to build a web interface to edit the data, but my host service only provide PHP+MYSQL solution for me, then if I put the data in MYSQL, how to extract it all into a sqlite db?

Any good suggestion for my question? is there any solution for sqlite db remote editing and we can download that sqllite db in the end?

Answer 1

I don't know about concurrent editing of a SQLite database, but one option you have is to create your database in MySQL then export it as a sql file which you then import into SQLite when you are satisfied with the contents.

There is one obvious problem with this though, the syntax of the two databases differs slightly. As long as you aren't using advanced features of MySQL, the majority of the SQL you export from MySQL, using something like the command line tool mysqldump or the export feature in PHPMyAdmin, should work in SQLite.

You would need to prune out the additional data inserted by MySQL for MySQL. Luckily people have wanted to do this before and a quick google search brings up a bunch of promising results.

The SQLite site has some options too: http://www.sqlite.org/cvstrac/wiki?p=ConverterTools

There a bunch of links for software you have to buy, but there is a free shell script about half way down that looks like it might work.

Answer 2

A free and easy solution: Open a Google Spreadsheet, work on it both, each time you need the result to be inputted into the core data DB just save it as .txt or a .csv and import into the DB.
A plugin for Firefox that you may find useful for the last part: SQLite Manager.
Good luck.