Download the PHP package soluble/schema without Composer
On this page you can find all versions of the php package soluble/schema. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download soluble/schema
More information about soluble/schema
Files in soluble/schema
Download soluble/schema
More information about soluble/schema
Files in soluble/schema
Vendor soluble
Package schema
Short Description Database information schema
License MIT
Homepage https://github.com/belgattitude/soluble-schema
Package schema
Short Description Database information schema
License MIT
Homepage https://github.com/belgattitude/soluble-schema
FAQ
After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.
Example:
Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories.
In this case some credentials are needed to access such packages.
Please use the auth.json textarea to insert credentials, if a package is coming from a private repository.
You can look here for more information.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?
Informations about the package schema
Soluble\Schema
Introduction
Query your database schema to know everything about your tables, columns, types, foreign keys...
Features
- Inspect, query and discover your database structure.
- Rely on information schema tables for deep and accurate info.
- Support database extended informations (native types, relations...)
- Fast and reliable implementation (at least as fast as possible).
Requirements
- PHP engine 5.4+, 7.0+ or HHVM >= 3.2.
Supported databases
Currently only MySQL and MariaDB are supported.
| Database | Driver | Source class |
|---|---|---|
| MySQL 5.1+ | pdo_mysql, mysqli | Soluble\Schema\Source\MysqlInformationSchema |
| Mariadb 5.5+ | pdo_mysql, mysqli | Soluble\Schema\Source\MysqlInformationSchema |
You can create new schema sources (oracle, postgresql...) by implementing the Soluble\Schema\Source\SchemaSourceInterface.
Please see the contribution guide and send a pull request.
Documentation
- Manual in progress and API documentation available.
Installation
Instant installation via composer.
Most modern frameworks will include Composer out of the box, but ensure the following file is included:
Examples
Connection
Initialize the Schema\Source\MysqlInformationSchema with a valid PDO or mysqli connection.
Retrieve table informations in a database schema
Get table columns information
Retrieve table primary key(s)
Retrieve information about unique keys
Get foreign keys informations
Retrieve references informations
API methods
Once a Schema\Source\SchemaSourceInterface is intitalized, you have access to the following methods
| Methods | Return | Description |
|---|---|---|
getSchemaConfig() |
ArrayObject |
Retrieve full extended schema config |
getTables() |
array |
Retrieve table names |
getTablesInformation() |
array |
Retrieve extended tables information |
hasTable() |
boolean |
Whether table exists |
getColumns($table) |
array |
Retrieve column names |
getColumnsInformation($table) |
array |
Retrieve extended columns information |
getPrimaryKey($table) |
string |
Retrieve primary key (unique) |
getPrimaryKeys($table) |
array |
Retrieve primary keys (multiple) |
getUniqueKeys($table) |
array |
Retrieve unique keys |
getForeignKeys($table) |
array |
Retrieve foreign keys information |
getReferences($table) |
array |
Retrieve referencing tables (relations) |
getIndexes($table) |
array |
Retrieve indexes info |
Future enhancements
- Supporting more sources like postgres, oracle
- PSR-6 cache implementation
Contributing
Contribution are welcome see contribution guide
Coding standards
All versions of schema with dependencies
PHP Build Version
Package Version
Requires
php Version
^5.4.4 || ^7.0
soluble/dbwrapper Version ^1.3.0
zendframework/zend-config Version >=2.1.0,<3.0.0
soluble/dbwrapper Version ^1.3.0
zendframework/zend-config Version >=2.1.0,<3.0.0
The package soluble/schema contains the following files
Loading the files please wait ....