in-memory local database

Ask the community
,
1

Hello,
Is it possible in Wix to create in-memory local database or collection (not wix-storage)?
My requirement is, if 100 users visit my site, then some data will be generate by reading site’s database contents and write in their respective browser’s in-memory database or collection. This local data will be used to render few sections of a webpage. For example JavaScript solutions such as LokiJS or PouchJS.
Also, if this solution could possible using Wix API, then let me know.
Any help in this would be highly appreciated.

Thanks,
Raj

2

Hi,
You can save data directly to the browser’s memory using the wix-storage API , please clarify what you wish to achieve using this data.

3

Hello,
I believe, my requirement is bit complex for me(may be easy for you) :-). I would he happy if you could provide an effective solution.
The requirements is as follows.
I have a table or collection containing the product list with unique product ids.
Table1
IDs | Cat
AJU09Y | Beauty
GHY78L | Kitchen
GLK23J | Baby
HJUY1L | Auto

  1. When an user open the site, from the above table, IDs will be read and a remote API call would be made. On return, all the latest product details fetched will be saved on temporary collection.
  2. From this temp collection, data will be used to fill the page details such as repeaters, gallery etc.

However there are few constrains.

  1. There should be few calls made to the API servers.
  2. Data should be of latest information.
  3. Site admin should fill the above Table 1, need not to bother about filling the temp collection.

Apart from this I have few other questions

  1. In Wix, if a collection has read-write access to anyone, then if 100 users write the data to the collection at a time, then will there be any discrepancy in data? If yes
  2. Is is possible to create temporary collection for each users(guest users, not registered)? Once the user is out, the collection should destroy.

Thanks,
Raj

4

Hi Raj,
Are there any changes to the “temp collection”? If not, why do you need it?
You can connect the repeaters and galleries to data without saving it in the browser’s memory.
I’d recommend you to check out more about the browser’s storage. check out this thread about the local and session storage.

As to your other question, there isn’t a limit for submitting data to a collection.
Anyway, you can create a temporary collection for each user using the session storage.