lol_dba
Index checker
A tool that analyzes application models to identify columns that likely need indexing and generates migration scripts for adding or removing these indexes.
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.
2k stars
14 watching
69 forks
Language: Ruby
last commit: 9 months ago
Linked from 2 awesome lists
databasedatabase-migrationsgemmigrationsrailsrubyruby-on-railssql
markets/awesome-ruby
sdogruyol/awesome-rubyRelated projects:
| Repository | Description | Stars |
|---|---|---|
 lowlydba/dba-multitool | A collection of scripts for automating administrative tasks and optimizing storage in databases. | 88 |
 djezzzl/database_consistency | A tool to identify and correct inconsistencies between application models and database schema in Ruby on Rails applications. | 1,063 |
 microsoft/kernel-memory | An AI service for efficient indexing and retrieval of data using natural language queries and semantic search | 1,602 |
 p0pr0ck5/lua-ffi-libinjection | A Lua binding to a library providing FFI bindings for libinjection, a tool for detecting SQLi and XSS in strings. | 36 |
 fern4lvarez/piladb | A lightweight, RESTful database engine based on stack data structures | 206 |
 palkan/logidze | A tool for logging changes to PostgreSQL database records in a standardized and structured way. | 1,609 |
 netrusov/zabbixdba | Service to monitor multiple RDBMS databases in real-time | 98 |
 lab2023/blankable | Adds blank slates to index view for managing customers | 8 |
 exaspark/batch-loader | A tool to reduce unnecessary queries by batching data loads | 1,043 |
| lab2023/bin_checker | A Ruby-based application that checks Turkish banks' bin numbers against a pre-existing list. | 11 |
 italolelis/reachable | A CLI tool to check the availability of web domains | 33 |
 baldwin-agency/magento2-module-url-data-integrity-checker | A Magento 2 module to detect and report potential URL-related issues in product and category data for improved SEO integrity | 263 |
 sashamelentyev/usestdlibvars | Detects potential misuse of standard library variables in Go code | 43 |
 daurnimator/lua-psl | A Lua library providing bindings to the Public Suffix List (PSL) library. | 9 |
 lausser/check_mysql_health | A plugin that checks various MySQL database metrics | 35 |