Open Source Update / 2025 Summary

2026-01-03

ZOMG! I can't believe the year is over already. Happy new year!

I started the year off wanting to write up these summaries monthly, but apparently I'm easily distracted. Thankfully, I take good notes in my daily Obsidian journal, and so I was able to crank out a summary of everything I've done since the last update (with some help from Claude! ❤️).

So here we are: this post summarizes my open source work from April through December 2025. See previous updates for March and April if you're curious!

Nokogiri

sqlite3-ruby

Releases

Release 2.7.0 / 2025-06-09 · sparklemotion/sqlite3-ruby updating to sqlite v3.50.1.
Release 2.7.1 / 2025-06-30 · sparklemotion/sqlite3-ruby updating to sqlite v3.50.2.
Release 2.7.2 / 2025-07-05 · sparklemotion/sqlite3-ruby bugfix release.
Release 2.7.3 / 2025-07-18 · sparklemotion/sqlite3-ruby updating to sqlite v3.50.3.
Release 2.7.4 / 2025-09-19 · sparklemotion/sqlite3-ruby updating to sqlite v3.50.4.
Release 2.8.0 / 2025-11-05 · sparklemotion/sqlite3-ruby updating to sqlite v3.51.0.
Release 2.8.1 / 2025-11-29 · sparklemotion/sqlite3-ruby updating to sqlite v3.51.1.
Release 2.9.0 / 2025-12-27 · sparklemotion/sqlite3-ruby with Ruby 4 native gem support and some small features.

Contributions

Investigated gem install sqlite3 –platform=ruby fails to build starting at 2.6.0 · Issue #634 · sparklemotion/sqlite3-ruby. Reported upstream at SQLite User Forum: The ”autoconf” tarball pkgconf flags are insufficient to link on RHEL platforms. Applied upstream fix as a patch in Ensure we can resolve dlopen et al by flavorjones · Pull Request #635 · sparklemotion/sqlite3-ruby
Picked back up on the work to use the amalgamation: dep: Vendor the SQLite amalgamation instead of the autoconf tarball by flavorjones · Pull Request #636 · sparklemotion/sqlite3-ruby
Tightened up Ensure we can resolve dlopen et al by flavorjones · Pull Request #635 · sparklemotion/sqlite3-ruby by changing it to a patch of the upstream fix.
Bumped rdoc to v7 and republished the site with the new theme: https://sparklemotion.github.io/sqlite3-ruby/

Reviews and user help

Collaborated with captn3m0 on a feature to improve statement variable binding: Expose statement bind parameters · Issue #627 · sparklemotion/sqlite3-ruby and Implements stmt.named_params by captn3m0 · Pull Request #642 · sparklemotion/sqlite3-ruby.
Reviewed and merged Fix typos by ankane · Pull Request #631 · sparklemotion/sqlite3-ruby
Replied on Attempting to build packaged libsqlite unexpectedly links against system libraries · Issue #639 · sparklemotion/sqlite3-ruby
Reviewed feat: aarch64-mingw-ucrt support by YOU54F · Pull Request #650 · sparklemotion/sqlite3-ruby
Reviewed Allow calling each, each_hash without block by kch · Pull Request #656 · sparklemotion/sqlite3-ruby
User help at Fail to build with Ruby 4.0.0_preview2 · Issue #663 · sparklemotion/sqlite3-ruby

Rails

Contributions

Security

Attended monthly meetings of the Rails security triage team, and worked on a few issues related to sanitization.

Merged!

Not accepted

Wrote Introduce config.active_record.strict_safe_http_methods by flavorjones · Pull Request #54891 · rails/rails which was not accepted, for good reasons. I expect this will come back at some point, because it's a necessary feature for apps to use sqlite read replicas.

Still baking

Drafted a new feature to Introduce a ReplicationCoordinator class to support multiple AZs. Eventually I think this will become a feature in Rails, again to help support sqlite read replicas.