aiomysql.create_pool 需要 await 吧？没有 await 它返回的是个 coroutine，试试：

self.pool = self.loop.run_until_complete(aiomysql.create_pool(...))

把 pool 放到 main 里面？

import aiomysql
import asyncio


async def select(pool, sql):
async with pool.acquire() as conn:
async with conn.cursor() as cur:
await cur.execute(sql)
r = await cur.fetchone()
print(r)


async def insert(pool, sql):
async with pool.acquire() as conn:
async with conn.cursor() as cur:
await cur.execute(sql)
await conn.commit()


async def main(loop):
pool = await aiomysql.create_pool(host='127.0.0.1', port=3306,
user='root', password='123456',
db='test', loop=loop)
c1 = select(pool, sql='select * from minifw')
c2 = insert(pool, sql="insert into minifw (name) values ('hello')")
tasks = [
asyncio.ensure_future(c1),
asyncio.ensure_future(c2)
]
return await asyncio.gather(*tasks)

if __name__ == '__main__':
cur_loop = asyncio.get_event_loop()
cur_loop.run_until_complete(main(cur_loop))

@Geoion #26 https://github.com/PyMySQL/mysqlclient-python

接力： http://vanilla.matthewpalmer.net/r/41bffac7

公司最主要的项目已经在使用 Python 3.6 了。

@guyskk #9 ORM 支持不咋的，有在生产环境使用，一个并不涉及到数据库的项目：

https://github.com/bosondata/prerender

@freestyle #7 并不是同步跑 WSGI ，自定义 gunicorn worker 跑 asyncio event loop

@cheetah aiohttp 2.0 也废弃了 WSGI 支持，估计以后 gaiohttp 也没法用了。

http://aiohttp.readthedocs.io/en/latest/migration.html#wsgi

@cheetah #4 actually ，即便实现了 __call__ 也不好继续下去，因为 Sanic 并不兼容 WSGI ， gunicorn 的 gaiohttp worker 是基于 WSGI 的

@cheetah 根本起不来

gunicorn simple_server:app --bind localhost:8000 --worker-class gaiohttp --capture-output
[2017-03-20 20:13:34 +0800] [3226] [INFO] Starting gunicorn 19.6.0
[2017-03-20 20:13:34 +0800] [3226] [INFO] Listening at: http://127.0.0.1:8000 (3226)
[2017-03-20 20:13:34 +0800] [3226] [INFO] Using worker: gaiohttp
[2017-03-20 20:13:34 +0800] [3260] [INFO] Booting worker with pid: 3260
Application object must be callable.
[2017-03-20 20:13:34 +0800] [3260] [INFO] Worker exiting (pid: 3260)
[2017-03-20 20:13:34 +0800] [3226] [INFO] Shutting down: Master
[2017-03-20 20:13:34 +0800] [3226] [INFO] Reason: App failed to load.

也需要一些 hack ，比如类似： https://github.com/messense/sanic-gunicorn/commit/e60a683f976cd66a36f3c1ee88b92f4be190067a#diff-757823b0d65a4f88a48899c3fd4135c8R54

或者自己实现下 __call__

@cheetah 好像 aiohttp 的速度不够快啊，不过我也没试……待验证。

上海玻森数据，以往 JD:

https://www.v2ex.com/t/147911
https://www.v2ex.com/t/307297
https://www.v2ex.com/t/295744

欢迎简历， messense (at) icloud.com

JSON Schema

@killpanda 目前发现的两个问题：

1. 它自己的 logging 用得不太对
2. 请求出现异常的时候 request 对象可能是 None ，日志会非常难 debug

@ryd994 https://www.python.org/dev/peps/pep-0328/

感觉 buildbot 太复杂了，造了个轮子： https://github.com/bosondata/badwolf