Hello There,
I am stuck in a Design Implementation Problem. I am developing a Social Network With the help of Backendless. I have to implement a Central Notification System on my Backendless App. I tried with Creating a Notification Table with the columns as Sender and Reciever along with Notification Data , and while Retrieving Notifications : I set up my Query to match the Reciever as the current User whom I wish to send the data . This way , it could do the drill for smaller number of data Tables. As the Notifications would enlarge in number , I think one Notification row per notification along with querying those ‘Sender’ and ‘Reciever’ parameters won’t be fast enough.
Meanwhile , I got an Another Idea to Track Notifications . I could Create A Separate Array (Technically Json String ) and add the Data to that JSON FIle whenever a New Notification is Triggered from the Sender. That Very Array column is separate for separate users and Could be Retrieved according to Per User basis which could surely Limit the Query Search to many Rows rather than a single row.
(I got this Idea form this very Link : But I couldn’t grab the Idea and Conclusion behind this Discussion)
http://support.backendless.com/t/how-can-i-create-an-array-column-in-the-database
If there are any other Effective Ideas to Do this, Please guide me as I am not a database expert and these inferences are done from a very little research from my part. What Sort of System could be best as per the Implementation using Backendless ?
Hi Pujan,
Another alternative to consider is to leverage the file system for your notification mechanism. For example, all your Receiver users may have a directory:
/messages/receiver-objectId/
When a Sender sends a message, your code could create a JSON file in the directory matching the receiver. In your code (either client-side or custom server code) you’d lookup the contents of the directory and would have specific messages that need to be delivered.
For a system with a lot of users, this mechanism may perform better than doing lookups in the data table(s).
Regards,
Mark
@Mark Piller ,
Okay I got the Idea on how to do it .
Can We create JSON Files through Java I/O on our Server Side Code .
I have uploaded created files through Client Side code easily .
Can we do the same through basic Java file system in the Server side ?
The File Service API is available and can be used by both client-side and server-side code.
Regards,
Mark