Hi,

It is completely native.  It consists of a queue table, a thread state table, a settings table, a stored procedure worker, an event to execute the worker (more than one run in parallel) and procs to drop off, check on, and get the results of a SQL statement (which always waits if the SQL is not done yet).

I don't know if MariaDB 5.5 or 10 adds GET DIAGNOSTICS, but it will work with any version that has it.  You can comment that out and just put a generic error into the table if it isn't supported, and it will work with any version that has SIGNAL.

--Justin

On Wed, Feb 24, 2016 at 10:01 AM, Federico Razzoli <federico_raz@yahoo.it> wrote:

Hi Justin!
The name reminds me a a fatal trap for developers and sys admins (async npm module), but the tools sounds useful.
Is it publicly available? Is it entirely implemented via stored procedures + event scheduler?

bye
Federico


--------------------------------------------
Mer 24/2/16, Justin Swanhart <greenlion@gmail.com> ha scritto:

 Oggetto: Re: [Maria-discuss] New Question: Non-blocking calls from PHP
 A: "AskMonty KB" <noreply@askmonty.org>
 Cc: "Maria Discuss" <maria-discuss@lists.launchpad.net>
 Data: Mercoledì 24 febbraio 2016, 15:32

 Replying
 here in addition to the web page (ugh Frankenstein's
 monster)...

 I just finished
 the first version of 'async' which runs queries in
 the background (in parallel!) using a queue table, a crafty
 stored procedure for a worker thread, and an event which
 executes the workers.
 http://swanhart.livejournal.com/138754.html

 On Sun, Feb 21, 2016 at
 8:55 AM, AskMonty KB <noreply@askmonty.org>
 wrote:
 Hello,



 A new question has been asked in " MariaDB Connector/C
 API Functions" by shestero. Please answer it at http://mariadb.com/kb/en/non-blocking-calls-from-php/
 as the person asking the question may not be subscribed to
 the mailing list.



 --------------------------------

 I want to use non-blocking API ( https://mariadb.com/kb/en/mariadb/non-blocking-api-reference
 ) from PHP.

 Is it possible now?

 If no, can anybody give me directions how to implement my
 own PHP-extension in C (using Connector/C) or update the
 existing module? I don't think it's very complex, do
 I need to add just wraper-like implementations using
 blocking function as samples, don't I?

 --------------------------------



 To view or answer this question please visit: http://mariadb.com/kb/en/non-blocking-calls-from-php/



 _______________________________________________

 Mailing list: https://launchpad.net/~maria-discuss

 Post to     : maria-discuss@lists.launchpad.net

 Unsubscribe : https://launchpad.net/~maria-discuss

 More help   : https://help.launchpad.net/ListHelp

 -----Segue allegato-----

 _______________________________________________
 Mailing list: https://launchpad.net/~maria-discuss
 Post to     : maria-discuss@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~maria-discuss
 More help   : https://help.launchpad.net/ListHelp