I need to create autocomplete input, which will suggest options based on Backendless database. I know, how to create autocompelte itself, the question is - how to suggest options from database. Let’s say the certain database table contain ~10.000 rows to be suggested. I guess the dumbest decision is to search through this table on each input change.
What is an alternative? Should I make some kind of script to save the certain column of the database table to the file and make autocomplete input search through it?
I use ReactJS with flux architecture, so, I guess another option is to create a Store, which will request whole database table in the background after webapp was loaded, and search through the created json object?
Hi, Anton,
We have not yet implemented this type of search, though this task is already on our roadmap.
The approach you are thinking of is right at the moment: if you are not limited to using strictly real-time data, you may load all the needed fields into some fast storage and then do a search against this storage.
Regards,
Sergey
Is there way to retrieve only one/few certain columns instead of whole table?
Yes, but you can do it only using REST. You can play with it with REST Console. Here’s an example:
http://support.backendless.com/public/attachments/c8a3d9d97db74fc06774b64a06495dda.jpg</img>
