I am trying to develop an app where users can add, delete, and update records in a database. I want them to be able to see a macro view of the records and click to display the detail. I would probably also use the data in other areas for totals of records. I understand that SQLite is probably a good database format for this. However, I am having a lot of trouble with the user interface. So far, it looks like I have to do a lot of coding any XCode for utilizing this functionality. I love Buzztouch and being able to maintain the majority of the content for my app here. Does anyone have an idea on constructing an interface to accomplish this? I was thinking an html page, which I could have in Buzztouch. However, I have been unable to find good information on how this could work/link to a SQLite database. Any suggestions would be greatly appreciated. Thanks.

SQLite can cause some headaches, so I'm told. Have a wee read at this thread on StackOverFLow, might give you some ideas. http://stackoverflow.com/questions/3630/sqlite-vs-mysql It shows some tricky config and setup for SQLite, especially if you have multiple people accessing the same data and trying to write to the CSV or file. Lots of the users on here do have forms running to capture data from a user and send to a remote DB, cannot think of any threads or people that have implemented SQLite yet though, that doesn't mean they are not out there though.

Thanks for the information. It looks like SQLite would be the best option. Any suggestions on developing interface screens? I would like to have the user be able to see the records in a table view, add, and edit. within the app. It would be great if this code could be contained within my BuzzTouch app without doing anything special in Xcode. Thanks.