Lol DBA vs Scenic

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

Scenic

Versioned database views for Rails (by scenic-views)

#Database Tools #Ruby #SQL #Rails #Schema #Postgres #Database #ActiveRecord

Source Code

Our great sponsors

Mergify - Automate your Pull Request with Mergify

Scout APM - Less time debugging, more time building

SonarLint - Deliver Cleaner and Safer Code - Right in Your IDE of Choice!

Our great sponsors

Lol DBA		Scenic
	Project
1	Mentions	4
1,437	Stars	2,929
-	Growth	0.7%
4.7	Activity	5.4
23 days ago	Latest Commit	about 17 hours 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.

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 2021-08-06.

Rails application boilerplate for fast MVP development
63 projects | dev.to | 6 Aug 2021

lol_dba for indexing

Scenic

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

Utilizando views SQL no Ruby on Rails
1 project | dev.to | 28 Mar 2022
Frameworks for SQL Development in Rails?
3 projects | reddit.com/r/rails | 5 Oct 2021

I use the scenic gem to manage views which uses raw sql files: https://github.com/scenic-views/scenic
Rails application boilerplate for fast MVP development
63 projects | dev.to | 6 Aug 2021

add scenic
Logidze 1.0, postgres-specific alternative to eg paper_trail for recording ActiveRecord change history
1 project | reddit.com/r/ruby | 27 Jan 2021

TIL about fx gem for storing triggers in schema.rb. That makes me so happy because scenic gem for creating database views is one of my favorites. Postgres is very powerful and it's great to see tools for exposing that through Rails.

What are some alternatives?

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

Rails DB - Rails Database Viewer and SQL Query Runner

PgHero - A performance dashboard for Postgres

SecondBase - Seamless second database integration for Rails.

Foreigner - Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb

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

Large Hadron Migrator - Online MySQL schema migrations

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

Ruby PG Extras - Ruby PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.

DatabaseConsistency - The tool to find inconsistency between models schema and database constraints.

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

Lol DBA vs SchemaPlus

Scenic vs SchemaPlus

Lol DBA vs Large Hadron Migrator

Scenic vs BatchLoader

Scenic vs Ruby PG Extras

Scenic vs DatabaseConsistency

Lol DBA vs Upsert