Thomas Lumley shared a smart way to fit generalized linear models by a SQL query to a database. I have to say frankly that I can no longer deal with the math now, but this post did remind me of a blog post written by my friend Yixuan Qiu in 2011, in which he showed how to fit a linear regression by using SQL queries. There might be a lot of existing research in this area, which I don’t know, but I was quite impressed by Yixuan’s post when I first saw it. It was a totally new perspective to me.
As a freelancer (currently working as a contractor) and a dad of three kids, I truly appreciate your donation to support my writing and open-source software development! Your contribution helps me cope with financial uncertainty better, so I can spend more time on producing high-quality content and software. You can make a donation through methods below.
Venmo: @yihui_xie, or Zelle: xie@yihui.name
Paypal
If you have a Paypal account, you can follow the link https://paypal.me/YihuiXie or find me on Paypal via my email xie@yihui.name. Please choose the payment type as “Family and Friends” (instead of “Goods and Services”) to avoid extra fees.
If you don’t have Paypal, you may donate through this link via your debit or credit card. Paypal will charge a fee on my side.
Other ways:
| WeChat Pay (微信支付：谢益辉) | Alipay (支付宝：谢益辉) |
|---|---|
 |
 |
When sending money, please be sure to add a note “gift” or “donation” if possible, so it won’t be treated as my taxable income but a genuine gift. Needless to say, donation is completely voluntary and I appreciate any amount you can give.
Please feel free to email me if you prefer a different way to give. Thank you very much!
I’ll give back a significant portion of the donations to the open-source community and charities. For the record, I received about $30,000 in total (before tax) in 2024-25, and gave back about $15,000 (after tax).