DatabaseValidations
QueryTrack
| DatabaseValidations | QueryTrack | |
|---|---|---|
| 3 | 1 | |
| 503 | 294 | |
| 0.6% | - | |
| 0.0 | 4.4 | |
| 11 months ago | 3 months ago | |
| Ruby | Ruby | |
| MIT License | MIT License |
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.
DatabaseValidations
-
Uniqueness validation does not work since the beginning of Ruby on Rails.
DatabaseValidations provides database-driven validations for ActiveRecord.
-
Ecto's uniqueness constraint vs. Rails' uniqueness validation
Love this post, great exploration of the nuances of uniqueness validations.
I came here to mention that there is also the https://github.com/toptal/database_validations gem which allows you to handle uniqueness validations in Rails in a similar manner to Ecto.
-
Rails application boilerplate for fast MVP development
add database_validations
QueryTrack
-
Tracking long queries into csv
I found query_tracker gem which displays all the info I needed. It also allows slack integration. In my case, I wanted it to store query informations into CSV. Fortunately the gem allows custom handlers.
What are some alternatives?
DatabaseConsistency - The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.
SchemaPlus - SchemaPlus provides a collection of enhancements and extensions to ActiveRecord
Squasher - Squasher - squash your old migrations in a single command
BatchLoader - :zap: Powerful tool for avoiding N+1 DB or HTTP queries
Database Cleaner - Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.
Upsert - Upsert on MySQL, PostgreSQL, and SQLite3. Transparently creates functions (UDF) for MySQL and PostgreSQL; on SQLite3, uses INSERT OR IGNORE.
Redis Dashboard - Sinatra app to monitor Redis servers.
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.
Foreigner - Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb
SecondBase - Seamless second database integration for Rails.
Scenic - Versioned database views for Rails