Pehea e hoʻonohonoho ai iā Laravel e hoʻohana i nā ʻikepili he nui i kāu papahana

ʻO ka mea maʻamau ka papahana hoʻomohala polokalamu e pili ana i ka hoʻohana ʻana i kahi Database no ka mālama ʻana i ka ʻikepili ma kahi ala i hoʻonohonoho ʻia.

No nā papahana kikoʻī pono paha e hoʻohana i nā ʻikepili lehulehu.

Me Laravel, no ka hoʻohana ʻana i nā ʻikepili he nui, pono mākou e hoʻonohonoho i ka framework a me nā faila hoʻonohonoho pili.

E ʻike kākou pehea e hoʻonohonoho ai iā Laravel e hoʻohana i nā ʻikepili lehulehu.

Manaʻo manawa heluhelu: 4 minuke

File database.php in config papa kuhikuhi

Aia kēia faila ma ka papa kuhikuhi config o kāu palapala Laravel.

Ma ka waihona database.php hiki hiki definish mau pili waihona. Pono kēlā me kēia pilina defiHoʻopili ʻia ma ke ʻano he array. Pono e loaʻa i ka array nā ʻike penei:

• driver: ka mea hoʻokele waihona e hoʻohana;
• host: ka inoa host a i ʻole ka helu wahi IP o ke kikowaena waihona;
• port: ka helu awa kikowaena waihona;
• database: ka inoa waihona;
• username: ka mea hoʻohana no ka hoʻohui ʻana i ka waihona;
• password: ka ʻōlelo huna no ka hoʻohui ʻana i ka waihona;

No ka laʻana, ke code ma lalo nei defiʻElua mau pilina waihona, hoʻokahi no MySQL a hoʻokahi no PostgreSQL:

'connections' => [
        'sqlite' => [
            'driver' => 'sqlite',
            'url' => env('DATABASE_URL'),
            'database' => env('DB_DATABASE', database_path('database.sqlite')),
            'prefix' => '',
            'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true),
        ],

        'mysql' => [
            'driver' => 'mysql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
            'engine' => null,
            'options' => extension_loaded('pdo_mysql') ? array_filter([
    PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
            ]) : [],
        ],

        'pgsql' => [
            'driver' => 'pgsql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '5432'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
            'schema' => 'public',
            'sslmode' => 'prefer',
        ],

Pehea e hoʻopili ai i ka DB

Mahope iho defiKe loaʻa iā ʻoe nā pilina waihona, hiki iā ʻoe ke hoʻohana iā lākou i kāu code Laravel. No ka hana ʻana i kēia, hiki iā ʻoe ke hoʻohana i ka facade o ka waihona. Ma laila facade Hāʻawi ka waihona i kahi kikowaena hui no ka launa pū ʻana me nā waihona.

No ka hoʻololi ʻana ma waena o nā pilina waihona, hiki iā ʻoe ke hoʻohana i ke ʻano Connection() della facade Nā waihona waihona. ʻO keʻano Connection() lawe i ka inoa o ka pili waihona ma ke ʻano he hoʻopaʻapaʻa.

No ka laʻana, hele kēia code mai ka mysql DB i ka pgsql DB:

use Illuminate\Support\Facades\DB;

DB::connection('pgsql');

Ke hoʻololi ʻoe i kahi pili waihona, hiki iā ʻoe ke hoʻohana iā ia e nīnau a launa pū me ka waihona.

Nā pōmaikaʻi o ka hoʻohana ʻana i nā waihona ʻikepili ma Laravel

Nui nā pōmaikaʻi i ka hoʻohana ʻana i nā ʻikepili he nui ma Laravel, me:

• ʻOi aku ka maikaʻi: ʻO ka hoʻohana ʻana i nā ʻikepili he nui hiki ke hoʻomaikaʻi i ka hana noi ma ka hoʻokaʻawale ʻana i nā ʻikepili o nā ʻano ʻano like ʻole. No ka laʻana, hiki iā ʻoe ke mālama i ka ʻikepili mea hoʻohana i hoʻokahi waihona a me ka ʻikepili huahana ma kahi waihona ʻē aʻe.
• Hoʻonui i ka palekana: ʻO ka hoʻohana ʻana i nā ʻikepili he nui hiki ke hoʻomaikaʻi i ka palekana noi ma o ka hoʻokaʻawale ʻana i nā ʻikepili o nā ʻano like ʻole. No ka laʻana, hiki iā ʻoe ke mālama i ka ʻikepili koʻikoʻi i loko o kahi waihona a me ka ʻikepili liʻiliʻi ma kahi waihona ʻē aʻe.
• ʻOi aku ka scalability: ʻO ka hoʻohana ʻana i nā ʻikepili he nui hiki ke hoʻonui i kāu noi ma ka ʻae ʻana iā ʻoe e puʻunaue i kāu ʻikepili ma nā kikowaena lehulehu.

ʻO nā hana maikaʻi loa no ka hoʻohana ʻana i nā ʻikepili he nui ma Laravel

Eia kekahi mau hana maikaʻi loa no ka hoʻohana ʻana i nā ʻikepili he nui ma Laravel:

• E hoʻohana i nā inoa aloha no nā pilina waihona: E maʻalahi kēia e ʻike a mālama i nā pilina waihona.
• E hoʻohana i ke ʻano Connection() e hele mai kahi DB i kekahi - e kōkua kēia iā ʻoe e pale i ka holo ʻana nīnau hulina hema hōkeoʻikepili hewa.
• E hoʻohana i kahi ʻōnaehana neʻe ʻikepili no ka hoʻokele ʻana i kāu schemas database - e kōkua kēia iā ʻoe e mālama i kāu mau papa kuhikuhi waihona i ka sync ma kāu āpau. hōkeoʻikepili.

ka hopena

ʻO ka hoʻohana ʻana i nā ʻikepili he nui ma Laravel he ala maikaʻi loa ia e hoʻomaikaʻi ai i ka hana, palekana, a me ka scalability o kāu noi. Ma ka hahai ʻana i nā hana maikaʻi loa i wehewehe ʻia ma kēia ʻatikala, hiki iā ʻoe ke hoʻohana i nā ʻikepili he nui ma Laravel me ka maikaʻi.

Heluhelu Pili

• Blockchain he aha ia mea, kekahi mau laʻana o ka hoʻohana ʻana i ka ʻenehana i ka honua maoli
• Laravel Database Seeder
• ʻO ka noiʻi ʻo Sophos Active Adversary Playbook 2022 e hōʻike ana i ka manawa o ka cybercriminals 'noho manawa i kā lākou mau mea i hōʻeha ʻia' i hoʻonui ʻia e 36%
• Blockchain ka manaʻo a me ke ʻano o ia mea, haku mele a me ka ʻenehana hou
• ʻO JSP me ke komo SQL, Pehea e hoʻokele ai i ke komo ʻana i kahi sql DB ma kahi ʻaoʻao Server Java

Ercole Palmeri