Question 1

How do I set up a second database with SecondBase in Rails 5?

Accepted Answer

Update your database.yml to include a 'secondbase' key with configurations per environment, and ensure models for the second database inherit from SecondBase::Base. Migrations are stored in db/secondbase/migrate, and you can generate them using the second_base:migration generator.

Question 2

SecondBase vs Rails 6 multiple databases: which is better?

Accepted Answer

For Rails 6+, native multiple database support is better as it's built-in, actively maintained, and more integrated with Rails core. SecondBase is only recommended for Rails 5.x or earlier projects where native support isn't available, but it's deprecated.

Question 3

Can I use SecondBase for more than two databases?

Accepted Answer

No, SecondBase is specifically designed for dual databases only. It manages a second database alongside the primary one, but doesn't natively support additional databases, so you'd need custom solutions for more.

Question 4

How to handle cross-database associations with SecondBase?

Accepted Answer

SecondBase allows ActiveRecord associations between models from different databases by inheriting from SecondBase::Base for second database models. However, complex operations like transactions might require manual intervention, as noted in the README for query cache handling.

Question 5

Is SecondBase deprecated and should I still use it?

Accepted Answer

Yes, SecondBase is deprecated for Rails 6 and higher. It's only useful for maintaining legacy Rails 5.x or earlier applications. For new projects, upgrade to Rails 6+ and use the native multiple database support instead.

Question 6

How to migrate from SecondBase to Rails 6 native support?

Accepted Answer

Refer to Rails guides on multiple databases to reconfigure your database.yml without the secondbase key, update models to use ActiveRecord::Base with appropriate database configurations, and adapt migrations. The README links to official Rails documentation for guidance.

Question 7

Does SecondBase work with Rails 7?

Accepted Answer

No, SecondBase is not recommended for Rails 7 or any Rails 6+ version. It was built for Rails 4.0+ up to Rails 5.x, and using it with newer versions may lead to compatibility issues and lack of support.

SecondBase

What is SecondBase?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions