Welcome Guest, Not a member yet? Register   Sign In
Database Schemas Module
#1

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.
Reply


Messages In This Thread
Database Schemas Module - by MGatner - 09-24-2019, 07:53 AM
RE: Database Schemas Module - by MGatner - 07-13-2020, 01:34 PM
RE: Database Schemas Module - by aschmitz - 10-03-2020, 06:54 AM
RE: Database Schemas Module - by MGatner - 10-03-2020, 08:32 AM
RE: Database Schemas Module - by aschmitz - 10-07-2020, 02:03 AM
RE: Database Schemas Module - by MGatner - 10-07-2020, 03:51 AM
RE: Database Schemas Module - by aschmitz - 10-16-2020, 02:43 PM
RE: Database Schemas Module - by nc03061981 - 10-16-2020, 05:43 PM



Theme © iAndrew 2016 - Forum software by © MyBB