{"repo":"djezzzl/database_consistency","free":true,"listed":false,"github":"https://github.com/djezzzl/database_consistency","clone":"git clone https://github.com/djezzzl/database_consistency.git","description":"The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.","language":"Ruby","stars":1191,"topics":["ruby-on-rails","activerecord","tool","database","consistency","optimization","performance","rails","ruby"],"license":"MIT","category":"databases-storage","readme_excerpt":"DatabaseConsistency The main goal of the project is to help you avoid various issues due to inconsistencies and inefficiencies between a database schema and application models. If the project helps you or your organization, I would be very grateful if you contribute or donate. Your support is an incredible motivation and the biggest reward for my hard work. The project is greatly supported by Pennylane! Huge appreciation to the organization, and please join them if you find the gem valuable for you! For detailed information, please read the wiki. Currently, the tool can: - find missing null constraints - find missing check constraints for numericality validations - find missing length validations - find missing presence validations - find missing uniqueness validations - find missing foreign keys for BelongsTo associations - find missing unique indexes for uniqueness validation - find missing indexes for HasOne and HasMany associations - find primary keys with integer/serial type - find mismatching primary key types with their foreign keys - find redundant non-unique indexes - find redundant uniqueness constraints - find mismatching enum types with their values - find mismatching foreign key cascades - find inconsistent values between enums in the database and ActiveRecord's enums/inclusion validations - find redundant case sensitive: false option for unique validations for case-insensitive types - find missing null constraints on boolean fields - find broken associations tha","default_branch":null,"files":null,"tree":[],"storefront":"/r/djezzzl","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/djezzzl/database_consistency/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}