Over time, a lot of requests have been made for a simple CRUD database example. Recently I created a sample app with the purpose of demonstrating the power of two elements which I have had the privilege of testing and helping in the development cycle. The are :
- Coronium developed by @develphant for the MySQL interaction
- widget.newEditField developed by @Atanas for the edit fields on the record detail page
For the purposes of demonstration, I wrote the app to use a MySQL database hosted on the Coronium server and there is no local data storage. This approach is quite an unlikely scenario in a typical mobile app, nevertheless it was chosen to keep the sample simple and to showcase the ease and power of Coronium in getting to connect to and manipulate web based databases.
So what is Coronium? - Here's how its developer, @develephant answers this question.
In our example, we use Coronium to host a simple database table containing 4 fields.
- First Name
- Last Name
- Date of Birth
- Role / Profile
When you run the sample, it connects to the Coronium server and pulls this information down to bring up a simple tableView which can be seen below.
Clicking / tapping New Record brings us to our detail view which at its heart has the amazing widget.newEditField developed by @Atanas.
You can read more about the development of this 3rd party widget at by clicking here. You can get a [free] copy of this widget and other sample code by registering on : http://widgetstown.com/ .
In the words of its developer, @Atanas,