Stephen Margheim

icon indicating a website link fractaledmind.github.io icon indicating an email [email protected]

icon location Berlin, Germany icon location Hey, I’m Stephen. I'm an American expat living in Berlin with my wife and two dogs. I am a contributor to Rails and the sqlite3-ruby gem as well as the maintain

Results 153 comments of Stephen Margheim

ActiveRecord::ReadOnlyError: Write query attempted while in readonly mode: UPDATE

This is a great report. Thank you. I bet that `update_all` doesn't call ActiveRecord's `transaction` method. I need to study the call stack to find if there is a single...

Steps with Await Jobs raise RuntimeError with GoodJob

Hmmm... That sucks. I'll need to dig into good_job more and think about how to rework this feature with that constraint in mind. I don't have an idea off the...

Steps with Await Jobs raise RuntimeError with GoodJob

I removed awaiting jobs as a first-party feature in v1 because the implementation is a large support burden and was itself around 30% of the overall codebase. However, I am...

Add default pragma values for newly opened databases

Minus the `temp_store` setting, these are exactly the defaults that @oldmoe and I recommend and are now default in Rails: https://fractaledmind.github.io/2023/09/07/enhancing-rails-sqlite-fine-tuning/ https://github.com/rails/rails/pull/49349

Implement an ActiveRecord adapter

I started experimenting in the Rails codebase to see what I needed to patch/alias from Extralite to have the default Rails SQLite adapter work with Extralite instead. I haven't finished...

Proof of Concept: Release GVL in Statement#step

In the Extralite gem, @noteflakes iterated on this problem and landed with a configurable `gvl_release_threshold` that defaults to 1000: > In order to support multi-threading, Extralite releases the [Ruby GVL](https://www.speedshop.co/2020/05/11/the-ruby-gvl-and-scaling.html)...

Database#pragma returns only 1 result and raw values, even for complex result sets

Option 3 leads to be believe that it is possible for the single `#pragma` method to return either multiple records or a single record. If that is true, my first...

Compatibility with Rails 7.2 or Rails 8.0

I'm on vacation this week, but I'll sort this out next week

#retry_job raises NoMethodError when used with GoodJob

I definitely want the problem solved

#retry_job raises NoMethodError when used with GoodJob

@ahacop: I _believe_ that this problem is resolved in v1. Can you confirm?