Forum | Appery.io

For the first time, I have a need to access a DB of mine with more than 1,500 records - and the required paging is leading to what I perceive are areas Appery can and should address.

RECOMMENDATION #1: Based on my understanding of prior threads, Appery does not support the ability to append multiple database service results to a list or other page control.

E.g. if my DB collection has 2,000 records, I need to call the service twice due to the 1,500 limit - the first for 1,500 records and the second for 500 records. The second call will delete the list contents from the first - and so you have to go through many steps to work around that (which I have not yet mastered). It would be great to simply select to allow such appending.

In my case, the collection contains several hundred columns, and those columns are subject to change over time - so I would rather not have to manually use the model approach to manually type in all of the column names.

RECOMMENDATION #2: Allow models to automatically use DB column names.

RECOMMENDATION #3: Finally, I don't believe Appery's local storage API provides for appending of contents, and that would be great to have.

Hi Robert -

Please excuse us for the delayed response here, we had forwarded your recommendations to our developers team for review, we'll get back with an update when we got information from them.

Thank you Illya.

Hi Robert -

ol
liYes, you are right. But this problem can be solved by using our Server code./li
liFor now you can check our App Creator Express, this feature now can create model of existing DB.
https://devcenter.appery.io/documenta... /li
liCould you please explain it with more details, what do you mean by appending content here? /li
/ol

Hi Illya - Thanks for your response.

1. With Appery support's help, I implemented a relatively simple process for paging my database and this proved completely workable.

2. Nice. I'm looking forward to using this.

3. In retrospect, I think the current functionality is not a problem to work with.