[QUESTION] Swoole hooks vs. Coroutine clients - which is Hyperf using? Which is better?

[kingIZZZY]

In this swoole documentation it sounds like Coroutine Clients are not recommended, instead Swoole Hooks is better to use.

What does Hyperf framework do? It looks like there are coroutine clients like hyperf/database-pgsql using Swoole\Coroutine\PostgreSQL

Is it better to use hooks or coroutine clients?
Is there a reason why it's better to use coroutine clients in the Hyperf framework?
Is it possible to use either / both? Which one should I use ?

Thank you 🙏

[kingIZZZY]

By the way - I'm sorry 对不起我不会说中文
I just use Google Chrome Translate on the documentation pages

[Torontototokyo]

hyperf uses Swoole_hook_all flags when bootstrap

[kingIZZZY]

So if I don't use hyperf/database-pgsql and I only use regular PDO and PDOStatement, will it be compatible with coroutines? Will it be non-blocking and able to execute in parallel?

Will it have any advantages or disadvantages compared to using hyperf/database-pgsql ?

What is the purpose of hyperf/database-pgsql ?

[sy-records]

If you need to use the pgsql client, you can use hyperf/database-pgsql.
pdo-pgsql is not hooked and does not support coroutine. It degrades to blocking mode when used.

[kingIZZZY]

OK thank you

So I understand that if I use regular PDO and PDOStatement with PHP extension ext-pdo and ext-pdo_pgsql, it will be blocking even if Hyperf has SWOOLE_HOOK_ALL. The only way to do PDO with PostgreSQL with coroutine/non-blocking support is by using Swoole\Coroutine\PostgreSQL in hyperf/database-pgsql.
Correct?

In that case - I will hope to find a good answer for how to use PDOStatment::bindParam with PDO::PARAM_LOB 🙏

Thanks again

[sy-records]

So I understand that if I use regular PDO and PDOStatement with PHP extension ext-pdo and ext-pdo_pgsql, it will be blocking even if Hyperf has SWOOLE_HOOK_ALL. The only way to do PDO with PostgreSQL with coroutine/non-blocking support is by using Swoole\Coroutine\PostgreSQL in hyperf/database-pgsql. Correct?

yeah.