This is an old revision of the document!
This is article on new scheme of database access.
There are lots of objects which need to use database access. Most of that type of access is provided by respective
DAO means data access object) objects. Instances of each
*DAO object consist in
TrackCollection holds also database connection and populates it on all
In Mixxx 1.11 if you want to conduct database access you must:
The main problem of such scheme is conducting the db access mostly from the Main thread. That's why while query's pending we face UI locking.
The main requirement is avoid hanging of UI (or minimize hanging up to 16 ms given by the display refresh rate, but not more).
There are lots of inherited complexity in the db usage:
We propose new scheme of the db accessing. This scheme requires usage of lambdas which was presented in new C++11.
Thanks to the introduction of Lambdas into C++11 it is much easier to write RPC, so we can avoid callbacks or using signal-slots (as it need us to write lots of overhead). Lambdas (in our case) is alternative to callbacks. But, as for me (and you can see at small example here https://github.com/troyane/lambdaConcurrent) lambdas syntax is little bit unusual, but very clear and much shorter then other ones.
Lambda also can behaves as closure (closure unlike a plain function pointer allows a function to access those non-local variables even when invoked outside of its immediate lexical scope).
We move execution of lambda to separate thread.
Without chaining the Mixxx 1.11 business logic too much we got ability to provide database access in separate thread. As it was required.
We are going to keep all
DAO class hierarchy and keep behaviour mostly the same, except
one important moment – conduct all database access in dedicated database thread.
TrackCollection becomes our separate thread. It is creating in
Library, also connects to database, holds this connection, initializes all
DAO objects and begins its own “event loop” (
while cycle in
run() method where thread waits for incoming lambdas containing db queries).
We got into cycle body every time someone places lambda to queue by calling
callAsync()/callSync. Here we dequeue lambda and execute it (in
What do I need to do with some code to apply new scheme?
callAsync/callSyncwhere the first parameter will be lambda with its catched values (most common – this).
thismember variables are used in a thread save way. We must rely on fact that object will be still alive when lambda'll execute in separate thread.
It guarantees your code will be placed into queue and executed as soon as possible in
TrackCollections thread. Must admit that
callAsync is asynchronous function. It means that all operations on placing lambda into queue happen in less than 16 ms and execution from your context goes on. We can't say exactly when lambda will be executed (as soon as it is placed to queue and becomes at the top of queue).
Here is sarcastic comics on theme of locking – http://dottech.org/93827/how-many-people-madly-click-their-mouse-when-a-program-freezes-comic/
There is no sense to queue lot of identical queries, so we must not lock all UI, but just lock ability to do some other queries (so, lock just left sidebar and library for example).
For this purposes we created new binary control [Playlist] “isBusy” with range (0.0f — off, else on). And it makes library widget grey (enabled==false).
So, we can use this CO this way:
m_pCOTPlaylistIsBusy = new ControlObjectThread(ConfigKey(“[Playlist]”, “isBusy”));. And we are locking/unlocking UI through this CO from
This can be uses safely during construction time of Mixxx but should be avoided in run time.
If you can't move on until code in lambda executes. For example, when you need results of some query in initialization of your class. Do it with
Completing this instruction, we do as it was previously, but with pause of further execution until respective lambda will be executed and respective mutex will be unlocked. Beware your lambda must wait whole lambda queue.
There is the upper bound for lambda queue (
MAX_LAMBDA_COUNT). Someone someday could wait in
callAsync if there is no empty positions in lambdas queue.
In this case this debug message: “…” will be printed to the mixxx.log file.