unasync VS woocommerce-custom-orders-table

Nice! This is similar to the solution here: https://github.com/python-trio/unasync

Lastly, I found another project name unasync that is pretty interesting and might works for me. Basically, you write the async version, you run unasync, it generate the sync version from the AST. This project is used by the official elastic search python client.

Fibers "allow blocking and non-blocking implementations to share the same API"

That's an interesting contrast to Python where the need to use "value = await fn()" v.s. "value = fn()" depending on whether or not that function is awaitable causes all kinds of API design complexity, all the way up to the existence of tools like https://github.com/python-trio/unasync which can code-generate the non-async version of a library from the async version.

Async Python has proven faster in my uses for IO and non-CPU-related stuff. But I think Python, either as a community or within the language, needs to solve the anti-pattern of maintaining separate sync and async versions of a library. I'm thinking specifically of aioredis and redis-py, both of which I've worked on.

Some people are looking at ways to solve this. I know urllib3, elasticsearch-py, and a few others use unasync (https://github.com/python-trio/unasync) to transform async code into sync code, leaving one codebase supporting both uses in different namespaces. This leaves you with some conditional logic (is_async_mode() -- https://github.com/python-trio/hip/blob/master/src/ahip/util...). I'm seriously considering this approach.

If you want that functionality right now you can use https://github.com/liquidweb/woocommerce-custom-orders-table I've used it multiple times, and have never had problems. There actually is a good chance custom tables could land in WooCommerce this year as all they have to do is integrate that plugin into WooCommerce. The plugin has already gotten heavy use on many big websites, and I know that the WooCommerce team knows about the plugin's existence.

I just want to preface this with a "Tread carefully" - but this might be worth keeping an eye on: https://github.com/liquidweb/woocommerce-custom-orders-table

WooCommerce also has a severe limitation right now, and that's that the orders are still currently a custom post type, and the postmeta table grows to millions of records, eventually slowing down the site. If your site is going to be processing a large quantity of orders, you might be able to use something like this: https://github.com/liquidweb/woocommerce-custom-orders-table , but you should at least be aware of this problem now.