(1, 'First Post', 'first-post', 'This is the first post.', 1, NOW(), NOW()); If you are using PostgreSQL, connect to the cake_cms database and execute the following SQL instead: CREATE TABLE users ( 'className' => 'Cake\Database\Connection', // Replace Mysql with Postgres if you are using PostgreSQL 'driver' => 'Cake\Database\Driver\Mysql', 'persistent' => false, 'database' => 'cake_cms', // Comment out the line below if you are using PostgreSQL 'encoding' => 'utf8mb4', 'timezone' => 'UTC', 'cacheMetadata'

(1, 'First Post', 'first-post', 'This is the first post.', 1, NOW(), NOW()); If you are using PostgreSQL, connect to the cake_cms database and execute the following SQL instead: CREATE TABLE users ( => [ 'className' => 'Cake\Database\Connection', // Replace Mysql with Postgres if you are using PostgreSQL 'driver' => 'Cake\Database\Driver\Mysql', 'persistent' => false, 'host' => 'localhost', 'username' 'password' => 'AngelF00dC4k3~', 'database' => 'cake_cms', // Comment out the line below if you are using PostgreSQL 'encoding' => 'utf8mb4', 'timezone' => 'UTC', 'cacheMetadata' => true, ], ], // More configuration

goodies will help you take full advantage of Laravel, but they are not required:  SQLite, MySQL, PostgreSQL, or SQL Server PDO drivers.  Memcached or APC. 12 Problems? If you are having problems DATABASE CONFIGURATION Laravel supports the following databases out of the box:  MySQL  PostgreSQL  SQLite  SQL Server All of the database configuration options live in the application/config/database using MySQL or PostgreSQL. Note: Need a good SQLite manager? Check out this Firefox extension. 77 Configuring Other Databases If you are using MySQL, SQL Server, or PostgreSQL, you will need

(1, 'First Post', 'first-post', 'This is the first post.', 1, NOW(), NOW()); If you are using PostgreSQL, connect to the cake_cms database and execute the following SQL instead: CREATE TABLE users ( Migrations provide a platform-independent way to run queries so the subtle differences between MySQL, PostgreSQL, SQLite, etc. don’t become obstacles. bin/cake bake migration CreateUsers email:string password:string supported database engine versions were updated: MySQL (5.7 or higher) MariaDB (10.1 or higher) PostgreSQL (9.6 or higher) Microsoft SQL Server (2012 or higher) SQLite 3 Auth Auth has been removed. Use

(1, 'First Post', 'first-post', 'This is the first post.', 1, NOW(), NOW()); If you are using PostgreSQL, connect to the cake_cms database and execute the following SQL instead: CREATE TABLE users ( Migrations provide a platform-independent way to run queries so the subtle differences between MySQL, PostgreSQL, SQLite, etc. don’t become obstacles. bin/cake bake migration CreateUsers email:string password:string database engine versions were updated: – MySQL (5.7 or higher) – MariaDB (10.1 or higher) – PostgreSQL (9.6 or higher) – Microsoft SQL Server (2012 or higher) – SQLite 3 5.0 Migration Guide 33 CakePHP

will utilize one. CakePHP supports a variety of database storage engines: MySQL (4 or greater) PostgreSQL Microsoft SQL Server SQLite Note All built-in drivers require PDO. You should make sure you have time, they are. CakePHP is designed to be agnostic and will work with MySQL, Microsoft SQL Server, PostgreSQL and others. You can create your database tables as you normally would. When you create your Model models represent. In many cases, the data is retrieved from a relational database such as MySQL, PostgreSQL or Microsoft SQL Server. CakePHP is distributed with several database-specific datasources (see

utilize one. CakePHP supports a variety of database storage engines: • MySQL (4 or greater) • PostgreSQL • Microsoft SQL Server • SQLite Note: All built-in drivers require PDO. You should make sure time, they are. CakePHP is designed to be agnostic and will work with MySQL, Microsoft SQL Server, PostgreSQL and others. You can create your database tables as you normally would. When you create your Model models represent. In many cases, the data is re- trieved from a relational database such as MySQL, PostgreSQL or Microsoft SQL Server. CakePHP is distributed with several database-specific datasources (see

supports a variety of database storage engines: MySQL (5.5.3 or greater) MariaDB (5.5 or greater) PostgreSQL Microsoft SQL Server (2008 or higher) SQLite 3 Note All built-in drivers require PDO. You should Supported Databases CakePHP supports the following relational database servers: MySQL 5.5+ SQLite 3 PostgreSQL 8.3+ SQLServer 2008+ Oracle (through a community plugin) You will need the correct PDO extension schema Used in PostgreSQL database setups to specify which schema to use. unix_socket Used by drivers that support it to connect via Unix socket files. If you are using PostgreSQL and want to use Unix

variety of database storage engines: • MySQL (5.5.3 or greater) • MariaDB (5.5 or greater) • PostgreSQL • Microsoft SQL Server (2008 or higher) • SQLite 3 209 CakePHP Cookbook Documentation, Release Databases CakePHP supports the following relational database servers: • MySQL 5.5+ • SQLite 3 • PostgreSQL 8.3+ • SQLServer 2008+ • Oracle (through a community plugin) You will need the correct PDO extension schema Used in PostgreSQL database setups to specify which schema to use. unix_socket Used by drivers that support it to connect via Unix socket files. If you are using PostgreSQL and want to use Unix

and databases PHP offers various built-in libraries to work with databases, for example: 82 PostgreSQL MySQL / MariaDB MongoDB I do not cover this in the handbook because I think this is a big topic