Rails DB vs Database Cleaner

Rails DB

Rails Database Viewer and SQL Query Runner (by igorkasyanchuk)

Database Tools

Source Code

railsjazz.com

Suggest alternative

Edit details

Database Cleaner

Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing. (by DatabaseCleaner)

Database Tools Testing Ruby database-cleaner testing-tools

Source Code

rubydoc.info

Suggest alternative

Edit details

Our great sponsors

SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App

WorkOS - The modern identity platform for B2B SaaS

InfluxDB - Power Real-Time Data Analytics at Scale

Our great sponsors

Rails DB		Database Cleaner
	Project
-	Mentions	3
1,451	Stars	2,914
-	Growth	0.2%
3.6	Activity	0.0
about 1 month ago	Latest Commit	4 months ago
JavaScript	Language	Ruby
MIT License	License	MIT License

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

Rails DB

Posts with mentions or reviews of Rails DB. We have used some of these posts to build our list of alternatives and similar projects.

We haven't tracked posts mentioning Rails DB yet.
Tracking mentions began in Dec 2020.

Database Cleaner

Posts with mentions or reviews of Database Cleaner. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-04-21.

How a big application is usually tested regarding to its database data persistence? Also, tip on starting tests on existing codebase.
1 project | /r/rails | 30 Sep 2021

i'll introduce the gem https://github.com/DatabaseCleaner/database_cleaner.
Como configurar ambiente de testes em Ruby on Rails com RSpec
7 projects | dev.to | 21 Apr 2021
10 Signs of a good Ruby on Rails Developer
10 projects | dev.to | 15 Apr 2021

If your are using gems like faker , factory_bot_rails and database_cleaner to create and clean test records then creating unnecessary records can cost you time and speed.

What are some alternatives?

When comparing Rails DB and Database Cleaner you can also consider the following projects:

Blazer - Business intelligence made simple

PgHero - A performance dashboard for Postgres

Lol DBA - lol_dba is a small package of rake tasks that scan your application models and displays a list of columns that probably should be indexed. Also, it can generate .sql migration scripts.

Seed dump - Rails 4/5 task to dump your data to db/seeds.rb

Seed Fu - Advanced seed data handling for Rails, combining the best practices of several methods together.

SecondBase - Seamless second database integration for Rails.

Squasher - Squasher - squash your old migrations in a single command

BatchLoader - :zap: Powerful tool for avoiding N+1 DB or HTTP queries

Upsert - Upsert on MySQL, PostgreSQL, and SQLite3. Transparently creates functions (UDF) for MySQL and PostgreSQL; on SQLite3, uses INSERT OR IGNORE.