{"repo":"sebyx07/better_structure_sql","free":true,"listed":false,"github":"https://github.com/sebyx07/better_structure_sql","clone":"git clone https://github.com/sebyx07/better_structure_sql.git","description":"Clean database schema dumps for Rails (PostgreSQL, MySQL, SQLite) without external tool dependencies","language":"Ruby","stars":10,"topics":["database","database-schema","gem","multi-database","mysql","postgresql","rails","rails-engine","ruby","schema"],"license":"MIT","category":"databases-storage","readme_excerpt":"🗄️ BetterStructureSql Clean, maintainable database schema dumps for Rails PostgreSQL • MySQL • SQLite 📚 Documentation • 🐙 GitHub • 💎 RubyGems --- ⚠️ Beta Notice : Version 0.2.2 is feature-complete and production-ready for PostgreSQL . Multi-database support (MySQL, SQLite) is implemented but considered experimental. APIs are stable but may see minor refinements before v1.0. We welcome feedback and contributions! ✨ Why BetterStructureSql? Rails' database dump tools ( pg dump , mysqldump , etc.) create noisy structure.sql files with version-specific comments, inconsistent formatting, and metadata that pollutes git diffs. BetterStructureSql uses pure Ruby introspection to generate clean schema files: 🎯 Core Benefits - ✅ Clean diffs - Only actual schema changes - ✅ No external tools - Pure Ruby introspection - ✅ Multi-database - PostgreSQL, MySQL, SQLite - ✅ Deterministic - Same input = identical output 🚀 Advanced Features - ✅ Complete coverage - Tables, views, triggers, functions - ✅ Schema versioning - Store & retrieve versions - ✅ Multi-file output - Handle massive schemas - ✅ Rails integration - Drop-in replacement --- 🗃️ Database Support Feature PostgreSQL 12+ MySQL 8.0+ SQLite 3.35+ --------- ---------------- ------------ -------------- Tables & Columns ✅ Full ✅ Full ✅ Full Indexes ✅ btree, gin, gist, hash, brin ✅ btree, hash, fulltext ✅ btree Foreign Keys ✅ All actions ✅ All actions ✅ Inline with CREATE TABLE Unique Constraints ✅ ✅ ✅ Check Constraints ✅ ✅ (8.0.16+) ","default_branch":null,"files":null,"tree":[],"storefront":"/r/sebyx07","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/sebyx07/better_structure_sql/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."}