Hi

I am after an app which utilises SQLITE as a database. The app will have three main sections.

The first will be the search section, the second a favourites section which stores items the user has saved. Third will be a favourites management where the user can create lists, delete lists. or delete items from a particular list.


The first section will be where the user is able to use UISLIDER, tick boxes, free text search and drop down list boxes to search the database.

All results will be returned to a list box, so when the user selects an item from that list, they are then taken to another view, which lists details for that chosen item.

EXAMPLE: The database will initialise with no results

User selects from a drop down list of categories, this automatically filters the other category fields to contain only those categories that remain. i would want around 4 of these list boxes.

The remaining search functionality will be in the form of UISLIDERs which when you move will also filter remaining results.

All of this has to happen dynamically without the user having to press a button to search.


After the user is satisfied with their search they can then look down the results list and select an item by tapping on the item name, this should take them to another screen where full details for that item are displayed, along with a thumbnail.

There should be two option available to the user at this point. either to save the item into their favourites, or to return to search results.

Choosing save, should open a view where they can create a new favourite list or to save to an existing favourite list.

Choosing return to search results takes the user back to search screen with all their search options intact.

I can provide the sqlite database and detailed screens of the various views that i want.