Yuav ua li cas rau configure Laravel siv ntau lub databases hauv koj qhov Project

Feem ntau ib txoj haujlwm tsim kho software suav nrog kev siv Database rau khaws cov ntaub ntawv hauv txoj hauv kev.

Rau cov haujlwm tshwj xeeb nws yuav tsum tau siv ntau cov ntaub ntawv.

Nrog Laravel, siv ntau lub databases, peb yuav tsum tau teeb tsa lub moj khaum thiab tshwj xeeb tshaj yog cov ntaub ntawv sib txuas.

Cia peb pom yuav ua li cas teeb tsa Laravel siv ntau lub databases.

Lub sijhawm nyeem ntawv kwv yees: 4 minuti

cov ntaub ntawv database.php in config directory

Cov ntaub ntawv no nyob hauv phau ntawv teev npe config ntawm koj daim ntawv thov Laravel.

Hauv cov ntaub ntawv database.php yog ua tau definish ntau qhov sib txuas database. Txhua qhov kev sib txuas yuav tsum yog definited li ib array. Lub array yuav tsum muaj cov ntaub ntawv hauv qab no:

• driver: tus neeg tsav tsheb database siv;
• host:npe host los yog qhov chaw nyob IP ntawm lub database server;
• port: database server chaw nres nkoj naj npawb;
• database: lub npe database;
• username: tus username rau kev txuas mus rau lub database;
• password: tus password rau kev txuas mus rau database;

Piv txwv li, cov cai hauv qab no defiMuaj ob qhov kev sib txuas database, ib qho rau MySQL thiab ib qho rau 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',
        ],

Yuav ua li cas txuas rau DB

Tom qab defiThaum koj muaj kev sib txuas database, koj tuaj yeem siv lawv hauv koj cov cai Laravel. Txhawm rau ua qhov no, koj tuaj yeem siv lub facade ntawm lub database. Nyob ntawd facade database muab ib tug unified interface rau interacting nrog databases.

Txhawm rau hloov ntawm kev sib txuas hauv database, koj tuaj yeem siv txoj kev Connection() della facade Cov ntaub ntawv. Txoj kev Connection() siv lub npe ntawm kev sib txuas database raws li kev sib cav.

Piv txwv li, cov cai hauv qab no mus los ntawm mysql DB mus rau pgsql DB:

use Illuminate\Support\Facades\DB;

DB::connection('pgsql');

Thaum koj hloov mus rau qhov kev sib txuas database, koj tuaj yeem siv nws los nug thiab cuam tshuam nrog cov ntaub ntawv.

Cov txiaj ntsig ntawm kev siv ntau lub databases hauv Laravel

Muaj ntau cov txiaj ntsig rau kev siv ntau cov ntaub ntawv hauv Laravel, suav nrog:

• Kev ua tau zoo dua: Kev siv ntau cov ntaub ntawv tuaj yeem txhim kho daim ntawv thov kev ua haujlwm los ntawm kev sib cais cov ntaub ntawv ntawm ntau hom. Piv txwv li, koj tuaj yeem khaws cov neeg siv cov ntaub ntawv hauv ib lub database thiab cov ntaub ntawv khoom hauv lwm qhov database.
• Ntxiv kev ruaj ntseg: Siv ntau lub databases tuaj yeem txhim kho daim ntawv thov kev ruaj ntseg los ntawm kev sib cais cov ntaub ntawv ntawm ntau hom. Piv txwv li, koj tuaj yeem khaws cov ntaub ntawv rhiab rau hauv ib lub database thiab cov ntaub ntawv tsis tshua muaj nyob hauv lwm lub database.
• Ntau dua scalability: Siv ntau lub databases tuaj yeem ua rau koj daim ntawv thov ua kom muaj zog ntxiv los ntawm kev tso cai rau koj faib koj cov ntaub ntawv hla ntau lub servers.

Cov kev coj ua zoo tshaj plaws rau kev siv ntau lub databases hauv Laravel

Nov yog qee qhov kev coj ua zoo tshaj plaws rau kev siv ntau cov ntaub ntawv hauv Laravel:

• Siv cov npe phooj ywg rau kev sib txuas hauv database: Qhov no yuav ua rau nws yooj yim dua los txheeb xyuas thiab tswj cov kev sib txuas hauv database.
• Siv txoj kev Connection() mus los ntawm ib DB mus rau lwm tus - qhov no yuav pab tau koj kom tsis txhob ua yuam kev khiav lus nug sul database yuam kev.
• Siv lub database migration system los tswj koj cov database schemas - qhov no yuav pab koj khaws koj cov database schemas hauv sync thoob plaws koj. database.

xaus

Kev siv ntau cov ntaub ntawv hauv Laravel tuaj yeem yog txoj hauv kev zoo los txhim kho kev ua haujlwm, kev ruaj ntseg, thiab ua kom muaj zog ntawm koj daim ntawv thov. Los ntawm kev ua raws li cov kev coj ua zoo tshaj plaws tau piav qhia hauv tsab xov xwm no, koj tuaj yeem siv ntau cov ntaub ntawv hauv Laravel zoo.

Kev Nyeem Ntawv

• Blockchain nws txhais li cas, qee qhov piv txwv ntawm kev siv thev naus laus zis hauv ntiaj teb tiag
• Laravel Database Seeder
• Sophos Active Adversary Playbook 2022 kev tshawb fawb qhia cybercriminals 'lub sij hawm nyob hauv lawv cov neeg raug tsim txom' tes hauj lwm nce 36%
• Blockchain lub ntsiab lus thiab nws yog dab tsi, muaj pes tsawg leeg thiab technology innovation
• JSP nrog SQL nkag, Yuav ua li cas tswj kev nkag mus rau sql DB hauv Java Server Page

Ercole Palmeri