Can anybody provide insight into why I would choose one over the other?
In the past, I've used drizzle, so I've already gone through the extra steps needed to deploy.
I can imagine the benefits of lua-resy-mysql for deployment reasons since the dependencies are more contained and the code is all lua instead of a mix of lua and special drizzle config syntax.
Any others? How would they compare performance-wise..even theoretically? Does one have a connection re-use advantage over the other? Is there a performance impact of the internal location capture? My response sizes are only a few rows, but it does require json parsing in my lua code.
My use-case is pretty simple. 99% of my queries are multi-table join selects. I don't serve the rows to users, but parse them in lua and make rewrite decisions.
For the purposes of discussion, I'm free to use any version of lua-jit, lua-resty-msql, nginx...etc.
..but I'm stuck at a specific version of drizzle so as to avoid the huge dependencies. I get the drizzle source from:
drizzle_url http://openresty.org/download/drizzle7-2011.07.21.tar.gz
..In writing this email, I discovered: lua-rds-parser which I should probably look at to avoid the unnecessary json decode in lua.