database.php
1 <?php 2 3 use Illuminate\Support\Str; 4 5 return [ 6 7 /* 8 |-------------------------------------------------------------------------- 9 | Default Database Connection Name 10 |-------------------------------------------------------------------------- 11 | 12 | Here you may specify which of the database connections below you wish 13 | to use as your default connection for database operations. This is 14 | the connection which will be utilized unless another connection 15 | is explicitly specified when you execute a query / statement. 16 | 17 */ 18 19 'default' => env('DB_CONNECTION', 'sqlite'), 20 21 /* 22 |-------------------------------------------------------------------------- 23 | Database Connections 24 |-------------------------------------------------------------------------- 25 | 26 | Below are all of the database connections defined for your application. 27 | An example configuration is provided for each database system which 28 | is supported by Laravel. You're free to add / remove connections. 29 | 30 */ 31 32 'connections' => [ 33 34 'sqlite' => [ 35 'driver' => 'sqlite', 36 'url' => env('DB_URL'), 37 'database' => env('DB_DATABASE', database_path('database.sqlite')), 38 'prefix' => '', 39 'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true), 40 'busy_timeout' => null, 41 'journal_mode' => null, 42 'synchronous' => null, 43 ], 44 45 'mysql' => [ 46 'driver' => 'mysql', 47 'url' => env('DB_URL'), 48 'host' => env('DB_HOST', '127.0.0.1'), 49 'port' => env('DB_PORT', '3306'), 50 'database' => env('DB_DATABASE', 'laravel'), 51 'username' => env('DB_USERNAME', 'root'), 52 'password' => env('DB_PASSWORD', ''), 53 'unix_socket' => env('DB_SOCKET', ''), 54 'charset' => env('DB_CHARSET', 'utf8mb4'), 55 'collation' => env('DB_COLLATION', 'utf8mb4_unicode_ci'), 56 'prefix' => '', 57 'prefix_indexes' => true, 58 'strict' => true, 59 'engine' => null, 60 'options' => extension_loaded('pdo_mysql') ? array_filter([ 61 PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'), 62 ]) : [], 63 ], 64 65 'mariadb' => [ 66 'driver' => 'mariadb', 67 'url' => env('DB_URL'), 68 'host' => env('DB_HOST', '127.0.0.1'), 69 'port' => env('DB_PORT', '3306'), 70 'database' => env('DB_DATABASE', 'laravel'), 71 'username' => env('DB_USERNAME', 'root'), 72 'password' => env('DB_PASSWORD', ''), 73 'unix_socket' => env('DB_SOCKET', ''), 74 'charset' => env('DB_CHARSET', 'utf8mb4'), 75 'collation' => env('DB_COLLATION', 'utf8mb4_unicode_ci'), 76 'prefix' => '', 77 'prefix_indexes' => true, 78 'strict' => true, 79 'engine' => null, 80 'options' => extension_loaded('pdo_mysql') ? array_filter([ 81 PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'), 82 ]) : [], 83 ], 84 85 'pgsql' => [ 86 'driver' => 'pgsql', 87 'url' => env('DB_URL'), 88 'host' => env('DB_HOST', '127.0.0.1'), 89 'port' => env('DB_PORT', '5432'), 90 'database' => env('DB_DATABASE', 'laravel'), 91 'username' => env('DB_USERNAME', 'root'), 92 'password' => env('DB_PASSWORD', ''), 93 'charset' => env('DB_CHARSET', 'utf8'), 94 'prefix' => '', 95 'prefix_indexes' => true, 96 'search_path' => 'public', 97 'sslmode' => 'prefer', 98 ], 99 100 'sqlsrv' => [ 101 'driver' => 'sqlsrv', 102 'url' => env('DB_URL'), 103 'host' => env('DB_HOST', 'localhost'), 104 'port' => env('DB_PORT', '1433'), 105 'database' => env('DB_DATABASE', 'laravel'), 106 'username' => env('DB_USERNAME', 'root'), 107 'password' => env('DB_PASSWORD', ''), 108 'charset' => env('DB_CHARSET', 'utf8'), 109 'prefix' => '', 110 'prefix_indexes' => true, 111 // 'encrypt' => env('DB_ENCRYPT', 'yes'), 112 // 'trust_server_certificate' => env('DB_TRUST_SERVER_CERTIFICATE', 'false'), 113 ], 114 115 ], 116 117 /* 118 |-------------------------------------------------------------------------- 119 | Migration Repository Table 120 |-------------------------------------------------------------------------- 121 | 122 | This table keeps track of all the migrations that have already run for 123 | your application. Using this information, we can determine which of 124 | the migrations on disk haven't actually been run on the database. 125 | 126 */ 127 128 'migrations' => [ 129 'table' => 'migrations', 130 'update_date_on_publish' => true, 131 ], 132 133 /* 134 |-------------------------------------------------------------------------- 135 | Redis Databases 136 |-------------------------------------------------------------------------- 137 | 138 | Redis is an open source, fast, and advanced key-value store that also 139 | provides a richer body of commands than a typical key-value system 140 | such as Memcached. You may define your connection settings here. 141 | 142 */ 143 144 'redis' => [ 145 146 'client' => env('REDIS_CLIENT', 'phpredis'), 147 148 'options' => [ 149 'cluster' => env('REDIS_CLUSTER', 'redis'), 150 'prefix' => env('REDIS_PREFIX', Str::slug(env('APP_NAME', 'laravel'), '_').'_database_'), 151 ], 152 153 'default' => [ 154 'url' => env('REDIS_URL'), 155 'host' => env('REDIS_HOST', '127.0.0.1'), 156 'username' => env('REDIS_USERNAME'), 157 'password' => env('REDIS_PASSWORD'), 158 'port' => env('REDIS_PORT', '6379'), 159 'database' => env('REDIS_DB', '0'), 160 ], 161 162 'cache' => [ 163 'url' => env('REDIS_URL'), 164 'host' => env('REDIS_HOST', '127.0.0.1'), 165 'username' => env('REDIS_USERNAME'), 166 'password' => env('REDIS_PASSWORD'), 167 'port' => env('REDIS_PORT', '6379'), 168 'database' => env('REDIS_CACHE_DB', '1'), 169 ], 170 171 ], 172 173 ];