#activerecord — Public Fediverse posts

私の order: がこんなに効かないわけがない(Mongoidの includes と scope: の話)
https://qiita.com/Yamamoto1012/items/c03d12ce4325c2ebbc4e?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #Ruby #Rails #MongoDB #ActiveRecord #mongoid

ActiveRecord: опасная магия. Часть 2

В первой части статьи мы обсуждали, как обманчивая простота ActiveRecord приводит к проблеме N+1 запросов, и я предложила решение. После публикации и обсуждений я поняла: магия ActiveRecord оказалась ещё коварнее, чем я думала. В своём примере я упустила важнейший нюанс... Какой нюанс?

https://habr.com/ru/articles/1061820/

#activerecord #rubyonrails #sql #n+1 #solution

🎏 🐶 flag_shih_tzu v1.0.0 is finally out, 8 years after 0.3.23. There are breaking changes, and many new features, including multi-bit flags 🩵 think multiple enum attributes in a single integer column! Also complete Truffleruby and JRuby support.

:ruby: I write about the most important breaking change here:
https://dev.to/galtzo/why-flagshihtzu-is-changing-its-default-sql-for-bit-flags-41l9
#ruby #bitfields #activerecord

🎏 🐶 flag_shih_tzu v1.0.0 is finally out, 8 years after 0.3.23. There are breaking changes, and many new features, including multi-bit flags 🩵 think multiple enum attributes in a single integer column! Also complete Truffleruby and JRuby support.

:ruby: I write about the most important breaking change here:
https://dev.to/galtzo/why-flagshihtzu-is-changing-its-default-sql-for-bit-flags-41l9
#ruby #bitfields #activerecord

It happens you need some field in the database to not contain an empty string, but to be NULL. For example, a unique index has been added to this field, meaning there can only be one record with an empty string. However, if the field has a NULL value, it is unique and there can be multiple such records.

#Ruby #Rails #ActiveRecord #Normalization #NULL #Empty #UNIQUE

At Kaigi on Rails 2025, Rails Committer Yasuo Honda walked through:

• Protocol 3.2 & extended cancel keys
• Why pg ≥ 1.6 matters
• UNLOGGED partition removal
• pg_stat_statements improvements
• Virtual generated columns (now default in PG18)
• Rails 8.1 adapter support

This is a great example of ecosystem coordination:
PostgreSQL core → pg gem → Rails adapter → production apps.

Full technical breakdown 👇

https://rubystacknews.com/2026/02/11/rails-meets-postgresql-18/

#Rails #PostgreSQL #Ruby #ActiveRecord #OpenSource

At Kaigi on Rails 2025, Rails Committer Yasuo Honda walked through:

• Protocol 3.2 & extended cancel keys
• Why pg ≥ 1.6 matters
• UNLOGGED partition removal
• pg_stat_statements improvements
• Virtual generated columns (now default in PG18)
• Rails 8.1 adapter support

This is a great example of ecosystem coordination:
PostgreSQL core → pg gem → Rails adapter → production apps.

Full technical breakdown 👇

https://rubystacknews.com/2026/02/11/rails-meets-postgresql-18/

#Rails #PostgreSQL #Ruby #ActiveRecord #OpenSource

e.g. Yesterday I Learned about #ActiveRecord's overloading of the #Ruby "shovel" ("<<") operator, and a couple of weeks ago I started a foray into #Rails YAML serialisation, which seems to have changed quite a bit between versions, leading to inconsistently-formatted data in the database, and the exciting prospect of writing a data migration that runs raw SQL queries 😵

ActiveRecord: опасная магия

В Ruby‑разработке ActiveRecord давно стал стандартом: он интуитивно понятен, встроен в Rails и позволяет быстро проводить CRUD‑операции. По мере роста проекта его «удобство» нередко начинает оборачиваться скрытыми проблемами.

https://habr.com/ru/articles/970042/

#ruby #rubyonrails #sql #activerecord #ошибки_и_грабли #n+1 #orm

Einmal ins Rabbit Hole von RubyonRails und ActiveRecord abtauchen und zurück?
Viel Spaß!
... und keine Klagen, wenn ihr länger drin geblieben seid als geplant 😆
https://www.youtube.com/watch?v=B4gEyuEQaBM
#rubyonrails #activerecord #deepdive

⏰ Just one hour away, our June online meetup is starting ⏰
Join us today at 12pm Eastern for An ActiveRecord Rewrite: the Story Behind the Attributes API talk from Tess Griffin! Find us and the meetup link on discord: https://discord.gg/KfBeRSjK?event=1384536117914894458

#online #meetup #ruby #rails #activerecord

JRuby's activerecord-jdbc-adapter doesn't yet support ActiveRecord 8. How should a gem which depends on ActiveRecord try to best support both CRuby and JRuby?
https://rubygems.org/gems/activerecord-jdbc-adapter/versions/71.0-java

#activerecord #jruby

JRuby's activerecord-jdbc-adapter doesn't yet support ActiveRecord 8. How should a gem which depends on ActiveRecord try to best support both CRuby and JRuby?
https://rubygems.org/gems/activerecord-jdbc-adapter/versions/71.0-java

#activerecord #jruby

Shardines: SQLite3 Database-per-Tenant with ActiveRecord

https://blog.julik.nl/2025/04/a-can-of-shardines

#HackerNews #Shardines #SQLite3 #ActiveRecord #DatabasePerTenant #HackerNews

Shardines: SQLite3 Database-per-Tenant with ActiveRecord

https://blog.julik.nl/2025/04/a-can-of-shardines

#HackerNews #Shardines #SQLite3 #ActiveRecord #DatabasePerTenant #HackerNews

Wide Models and Active Record custom validation contexts, by @bensheldon

https://island94.org/2025/04/wide-models-and-active-record-custom-validation-contexts

> This post is a brief description of a pattern I use a lot using when building features in Ruby on Rails apps and that I think needed a name:

> Wide Models have many attributes (columns in the database) that are updated in multiple places in the application, but not always all at once i.e. different forms will update different subsets of attributes on the same model.

#ruby #ActiveRecord

Wide Models and Active Record custom validation contexts, by @bensheldon

https://island94.org/2025/04/wide-models-and-active-record-custom-validation-contexts

> This post is a brief description of a pattern I use a lot using when building features in Ruby on Rails apps and that I think needed a name:

> Wide Models have many attributes (columns in the database) that are updated in multiple places in the application, but not always all at once i.e. different forms will update different subsets of attributes on the same model.

#ruby #ActiveRecord

How fast can an ActiveRecord SQL query run?, by Fritz Meissner
https://thoughtbot.com/blog/how-fast-can-an-activerecord-sql-query-run

> Your database monitoring (perhaps Amazon RDS performance insights, Skylight, or the #Postgres pg_stat_activity view) is telling you that one particular query in your Rails app is causing heavy load. Unfortunately, it already seems pretty fast. What are the odds that you can get it to run any faster?

#ruby #SQL #ActiveRecord

How fast can an ActiveRecord SQL query run?, by Fritz Meissner
https://thoughtbot.com/blog/how-fast-can-an-activerecord-sql-query-run

> Your database monitoring (perhaps Amazon RDS performance insights, Skylight, or the #Postgres pg_stat_activity view) is telling you that one particular query in your Rails app is causing heavy load. Unfortunately, it already seems pretty fast. What are the odds that you can get it to run any faster?

#ruby #SQL #ActiveRecord

It's always great to see @rosa and she talked about her #SolidQueue implementation at #rubycommunityconference in #krakow.

She also gave a shout-out to @bensheldon's #goodjob and mentioned how @getajobmike's @sidekiq is blazingly fast.

#ruby #rails #queue #rubyonrails #activerecord #poland #37signals #backgroundprocessing #backgroundprocesses #sidekiq

It's always great to see @rosa and she talked about her #SolidQueue implementation at #rubycommunityconference in #krakow.

She also gave a shout-out to @bensheldon's #goodjob and mentioned how @getajobmike's @sidekiq is blazingly fast.

#ruby #rails #queue #rubyonrails #activerecord #poland #37signals #backgroundprocessing #backgroundprocesses #sidekiq

I know #SQLite3 supports #SQL comments in newer versions with the right flags, but `rails g` for #ActiveRecord ďoesn’t seem to support them except in #PostgreSQL or #MySQL / #MariaDB. Is there a workaround?

I know #SQLite3 supports #SQL comments in newer versions with the right flags, but `rails g` for #ActiveRecord ďoesn’t seem to support them except in #PostgreSQL or #MySQL / #MariaDB. Is there a workaround?

Made a gem out of an earlier proof-of-concept: https://github.com/henrik/activemodel-with_conditions

This lets you do things like

``` ruby
with_conditions(if: :feature_x_is_on?) do
validate :free_plans_must_have_x, if: :free_plan?
end
```

where the conditions merge intuitively, unlike `with_options`.

#RubyOnRails #ActiveRecord #ActiveModel

Made a gem out of an earlier proof-of-concept: https://github.com/henrik/activemodel-with_conditions

This lets you do things like

``` ruby
with_conditions(if: :feature_x_is_on?) do
validate :free_plans_must_have_x, if: :free_plan?
end
```

where the conditions merge intuitively, unlike `with_options`.

#RubyOnRails #ActiveRecord #ActiveModel

Railsで使われるテーブル結合方法について
https://qiita.com/k12da/items/2ea1b4196790f3ea9f3a?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #Rails #ActiveRecord #SQL

Am I the only one that dont like other ORMs than Rails Active Record? I mean, FastAPI's SQLAlchemy, SQLModel in combination with pydantic as well as Symfonys Doctrine feels a little bit pain in the a** when it comes to complex relations. Active Record just feels smooth compared to the other ones...

#rubyonrails #activerecord #fastapi #sqlalchemy #sqlmodel #pydantic #doctrine #symfony #python #orm #database

Am I the only one that dont like other ORMs than Rails Active Record? I mean, FastAPI's SQLAlchemy, SQLModel in combination with pydantic as well as Symfonys Doctrine feels a little bit pain in the a** when it comes to complex relations. Active Record just feels smooth compared to the other ones...

#rubyonrails #activerecord #fastapi #sqlalchemy #sqlmodel #pydantic #doctrine #symfony #python #orm #database

Eradicating N+1s: The Two-phase Data Load and Render Pattern in Go, by @brandur

> Using a two-phase data load and render pattern to prevent N+1 queries in a generalized way. Especially useful in Go, but applicable in any language.

#golang #ActiveRecord #ruby

Eradicating N+1s: The Two-phase Data Load and Render Pattern in Go, by @brandur

> Using a two-phase data load and render pattern to prevent N+1 queries in a generalized way. Especially useful in Go, but applicable in any language.

#golang #ActiveRecord #ruby

Why is ActiveRecord > 7.1 still broken on JRuby? Appears activerecord-jdbc-adapter still hasn't been updated.
https://github.com/ronin-rb/ronin-db-activerecord/actions/runs/9264533331/job/25484805001
#activerecord #jruby

Why is ActiveRecord > 7.1 still broken on JRuby? Appears activerecord-jdbc-adapter still hasn't been updated.
https://github.com/ronin-rb/ronin-db-activerecord/actions/runs/9264533331/job/25484805001
#activerecord #jruby

How do you safely close the sqlite3 database file when using ActiveRecord in a Sinatra app? Doling a Ctrl^C results in the sqlite3 lock files being left behind.
#sinatra #activerecord

How do you safely close the sqlite3 database file when using ActiveRecord in a Sinatra app? Doling a Ctrl^C results in the sqlite3 lock files being left behind.
#sinatra #activerecord

What do people prefer for ensuring that ActiveRecord connections get freed (in a Sinatra app)?
#activerecord #sidekiq #sinatra

What do people prefer for ensuring that ActiveRecord connections get freed (in a Sinatra app)?
#activerecord #sidekiq #sinatra

ORMs get a bad rap. Sometimes deservedly. But I really do love #ActiveRecord.

Why do I keep getting this error with ActiveRecord in this Sinatra+Sidekiq app:

could not obtain a connection from the pool within 5.000 seconds (waited 5.000 seconds); all pooled connections were in use

I'm already passing `pool: 4` to `ActiveRecord::Base.establish_connect(...)` to set the connection pool size, which is what Google/StackOverflow recommends, but it's still randomly occurring.
#activerecord

Why do I keep getting this error with ActiveRecord in this Sinatra+Sidekiq app:

could not obtain a connection from the pool within 5.000 seconds (waited 5.000 seconds); all pooled connections were in use

I'm already passing `pool: 4` to `ActiveRecord::Base.establish_connect(...)` to set the connection pool size, which is what Google/StackOverflow recommends, but it's still randomly occurring.
#activerecord

Another day, another #ActiveRecord feature proposal from our team. 😆

This one would allow a middleware-esque design for altering the behavior/configuration of DB transactions.

https://discuss.rubyonrails.org/t/proposal-activerecord-transaction-middleware/85517

#Rails

Another day, another #ActiveRecord feature proposal from our team. 😆

This one would allow a middleware-esque design for altering the behavior/configuration of DB transactions.

https://discuss.rubyonrails.org/t/proposal-activerecord-transaction-middleware/85517

#Rails

Excellent article from @bensheldon about taking advantage of prepared statements in Rails:

Rails Active Record: Will it bind?

https://island94.org/2024/03/rails-active-record-will-it-bind

#ruby #rails #activerecord

https://dev.to/jordantaylorj/ruby-active-record-2d4b - #Ruby's #ActiveRecord is elegantly simple and immensely powerful. Thanks for learning in public https://www.linkedin.com/in/jordantjoseph/

https://dev.to/jordantaylorj/ruby-active-record-2d4b - #Ruby's #ActiveRecord is elegantly simple and immensely powerful. Thanks for learning in public https://www.linkedin.com/in/jordantjoseph/

A neat idea for preventing #ActiveRecord DB access within the scope of a block, from another of my too smart coworkers. https://discuss.rubyonrails.org/t/proposal-prevent-activerecord-access/85322

#Rails

A neat idea for preventing #ActiveRecord DB access within the scope of a block, from another of my too smart coworkers. https://discuss.rubyonrails.org/t/proposal-prevent-activerecord-access/85322

#Rails

Коммуникация по RESTful API: синхронизируем данные с маркетплейсами

В статье разбирается код на Ruby и в Ruby on Rails, в частности, на примере задачи по разработке web-сервиса синхронизации данных с внешними источниками. Погружение в программное решение начинается с разбора бизнес-задачи. Через освещение реальных API с маркетплейсов OZON и Яндекс.Маркет обосновываются способы принятия архитектурных решений и способы оптимизации кода. Эта статья также является авторской попыткой раскрыть принцы SOLID при реализации логики реального бэкенд приложения по переработке структурированных данных в условиях эксплуатации стороннего REST API.

https://habr.com/ru/articles/796169/

#ruby_on_rails #restful_api #postgresql #sidekiq #redis #solid #development #logger #ruby #activerecord

I also had way too much fun this morning playing with #ActiveRecord instrumentation to log SQL queries and do a before/after on a PR of mine 😅

【Rails】ActiveRecordでSQLっぽくテーブル結合する方法
https://qiita.com/teddy_bear_eng/items/0f7c7723f5d121a493f9?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #Ruby #Rails #ActiveRecord #SQL

ActiveRecord's callback hell is worse than JavaScript's callback hell.

Prove me wrong.

#rails #ruby #callbacks #CallbackHell #ActiveRecord #javascript