I need a proof of concept solution for Android and iPhone(later on) capable of getting data from the network ( a web site or a socket ) and feed a list with it.
Data are stored on a data base( preferable mysql) and has 3 fields
FIELD 1:ID ( uniq primary key)
FIELD 2:TEXT TO BE POPULATE
FIELD 3:PICTURE (blob or path to a location on server HDD)
The information which comes from the net should feed the list.
Each list item should contain only the text and the picture.(FIELD 2 and 3) but order is important and will be kept ascending based on ID(FIELD 1).
I do not care the layout format ( KISS ), only keep in mind that both pieces of i information comes from the net ( the text and the picture) nothing must be retain locally on the phone in a persistent manner( DB, files etc) only in memory.
While scrolling down to the list will load over the network more and more items and discard the ones in top in order to keep the RAM a reasonable number of records for scroll [url removed, login to view] the user will scroll all the way up the list will be filled back from the network as well with the same information which was before( from the net as well).
Order is very important to be conserved.
If the network is slow each reported item which is brought from network must show in the main UI Thread a round spinner which show the Loading activity.