Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

Welcome, Guest
Guest Settings

Thread: Need interfacing advice between two applications using sqlite database

This question is not answered. Helpful answers available: 2. Correct answers available: 1.

Permlink Replies: 0
Sean Mackey

Posts: 5
Registered: 9/15/15
Need interfacing advice between two applications using sqlite database  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 9, 2015 11:58 AM
Hello All,

I am looking for the best way to accomplish a task in C++ Builder XE8. Basically, I am going to have one firemonkey application pushing updates to a sqlite database (please advise if there is a better alternative) and another firemonkey application that is going to be interfacing between it and some custom made hardware. So, my question is, what is the fastest, most "live action" way to communicate that the database has been updated. Event handlers? I dont want to use a timer that just refreshes the livebindings every 100ms as that seems to be expensive. Keep in mind, this is going to be running on Android, iOS and Windows devices. Some of them may be underpowered. There is really no need for security or encryption for the communication.

My ideas are now is the original application will push updates as needed to the sqlite database, which is just a file on the disk. The interfacing firemonkey application will need to know when these updates have happened either by an event listener, or from what I have read, these RTL messages that are multiplatform. The idea is to have the fastest communication with the lowest amount of memory footprint. I am not sure how we are handling the hardware yet, but for right now, I just need to get point A to point B and I will worry about Point C (the hardware) later. So any advice on making the interfacing application listen for database updates from the original GUI application would be great.

Thank you all for this advice, as I have read about 10 different ways to do things. You are all fantastic.

Sean M.
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02