Foreigner vs Lol DBA

Foreigner

Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb (by matthuhiggins)

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. (by plentz)

Database Tools Rails Database Migrations SQL Ruby ruby-on-rails Gem database-migrations

Source Code

Suggest alternative

Edit details

Our great sponsors

WorkOS - The modern identity platform for B2B SaaS

InfluxDB - Power Real-Time Data Analytics at Scale

SaaSHub - Software Alternatives and Reviews

Our great sponsors

Foreigner		Lol DBA
	Project
-	Mentions	2
1,327	Stars	1,571
-	Growth	-
0.0	Activity	0.0
about 5 years ago	Latest Commit	about 2 months ago
Ruby	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.

Foreigner

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

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

Lol DBA

Posts with mentions or reviews of Lol DBA. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-02-02.

Must-have gems for mature Rails
8 projects | dev.to | 2 Feb 2024

gem "lol_dba" - https://github.com/plentz/lol_dba | Inspect the state of table indexes.
Rails application boilerplate for fast MVP development
63 projects | dev.to | 6 Aug 2021

lol_dba for indexing

What are some alternatives?

When comparing Foreigner and Lol DBA you can also consider the following projects:

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

PgHero - A performance dashboard for Postgres

SecondBase - Seamless second database integration for Rails.

Scenic - Versioned database views for Rails

Large Hadron Migrator - Online MySQL schema migrations

Rails DB - Rails Database Viewer and SQL Query Runner

Blazer - Business intelligence made simple

SchemaPlus - SchemaPlus provides a collection of enhancements and extensions to ActiveRecord

QueryTrack - Find time-consuming database queries for ActiveRecord-based Rails Apps

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

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