[MGatner]

Hi all- I have two new modules I'm excited about. The first stands alone and assists with handling database structures. It is early in its life but can already map directly from a database or from a PHP file and provide a flexible and comprehensive schema for your application. I hope for this to be a builder block for many other uses:

Tatter/Schemas - Database schema management, for CodeIgniter 4

Basic usage:

1. Install with Composer: `> composer require tatter/schemas`
2. Use the CLI to generate a schema: `> php spark schemas`

The CLI command will prompt for parameters but can also be scripted for your handlers. E.g. to run from a cron to periodically cache your schema you might do:

PHP Code:

php spark schemas database model -export cache 


Some current and future uses for this module:

• View your entire database mapped out in a cascading structure
  
• Read or detect table relationships for easy object-relation mapping (see e.g. Tatter\Relations)
  
• Get helpful advice on optimizations to your database structure with schema analysis
  
• Backup, restore, or deploy an entire database structure between servers or environments
  
• Generate CodeIgniter 4 migration files from an existing database
  
• Transfer projects to CodeIgniter 4 by reading schema files from other supported formats
  

---

Thanks for reading! I'm always glad for feedback and suggestions, feel free to leave a comment here or check out the repo at https://github.com/tattersoftware/codeigniter4-schemas.