-
Notifications
You must be signed in to change notification settings - Fork 137
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Best way to play around with Solid Queue in development? #332
Comments
Hey @jeromedalbert, good question! I think the best way to play around with Solid Queue (and Solid Cache) in development is to keep the databases separate as well. I think your idea of an install command for dev or a commented out example is good, that'll help people for sure. |
Related: #334 and rails/solid_cable#37 added instructions to use a single database. Although with those solutions you would have a single database for both development and production. |
Just some updates on how I currently set up my
Reusing the same config in development and prod makes for a shorter and simpler |
Solid Queue used to use migrations on a single database, which was nice if you wanted to have everything in the same database in development.
Now Solid Queue uses schemas, which is nice since it does not clutter a brand new Rails 8 app with migrations. The schemas are for separate databases, which makes sense for production (it would be nice to document why by the way, e.g. better isolation or performance). I understand that the library is more intended for production as explained by Rosa:
But it would be nice to be able to easily play around with it in on your local environment, to kick the tires, reproduce production issues in your local, get a feel for how it works with mission_control-jobs, and see if any configuration changes you're making to your Solid Queue setup works correctly on your local before deploying them to minimize issues.
If Solid Queue in development is not a default, then I think it should be easy to set it up on one's local. So far I can think of 3 ways:
Keep Solid Queue in a separate schema in production, but one schema in development. I don't know if that's possible. But having everything in one schema keeps the development setup simple, since having multiple databases looks more like a production concern. That would be the simplest setup short of using the async adapter. However it would be harder to remove solid queue (short of using
--skip-solid
) since I guess you would have to manually edit the schema.Provide an example
database.yml
setup in some way, like in docs or as comments in that file, so someone can get up and running quickly even if they are not familiar with multi-db setups. This is how I set it up on my local for a new app using postgres:That works fine although I feel like it is a bit cluttered for a new app. Maybe I could simplify this but I am unsure how.
I guess I could dynamically set the database names likedatabase: "myapp_#{Rails.env}_queue"
) and hoist those definitions in&queue
etc. Edit: that doesn't actually work when creating or dropping multiple DBs at the same timeProvide a command like
bin/rails solid_queue:install:dev
that sets up everything for your development environment (with adatabase.yml
similar to point 2).What do people think is the best way to play around with Solid Queue in development?
(I realize this question applies to Solid Cache and Solid Cable too since they also use a separate schema, so it may be more of a general Rails question. I can repost on the Rails forum or the Rails github discussions if needed)
The text was updated successfully, but these errors were encountered: