09-24-2019, 07:53 AM
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:
Some current and future uses for this module:
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.
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.