Uyilungiselela kanjani iLaravel ukuthi isebenzise imininingwane eminingi kuProjekthi yakho

Ngokuvamile iphrojekthi yokuthuthukisa isofthiwe ihilela ukusetshenziswa Kwedathabhesi yokugcina idatha ngendlela ehlelekile.

Kumaphrojekthi athile kungase kudingeke ukuthi kusetshenziswe imininingwane eminingi.

Nge-Laravel, ukusebenzisa imininingo egciniwe eminingi, sidinga ukumisa uhlaka futhi ikakhulukazi ifayela lokucushwa kokuxhumana.

Ake sibone ukuthi ungayimisa kanjani i-Laravel ukusebenzisa imininingwane eminingi.

Isikhathi sokufunda esilinganiselwe: 4 imizuzu

Ifayela database.php in config Isiqondisi

Leli fayela litholakala ohlwini lwemibhalo config yohlelo lwakho lokusebenza lwe-Laravel.

Efayelini database.php kungenzeka defisebenzisa ukuxhumana okuningi kwe-database. Konke ukuxhumana kufanele kube defiifakwe njenge-array. Uhlu kufanele luqukathe ulwazi olulandelayo:

• driver: umshayeli wesizindalwazi ozosetshenziswa;
• host: igama host noma ikheli IP yeseva yedathabheyisi;
• port: inombolo yembobo yesizindalwazi;
• database: igama lesizindalwazi;
• username: igama lomsebenzisi lokuxhuma kusizindalwazi;
• password: iphasiwedi yokuxhuma kusizindalwazi;

Isibonelo, ikhodi elandelayo defiKukhona ukuxhumana okubili kwedathabhesi, eyodwa ye-MySQL neyodwa ye-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',
        ],

Ungaxhuma kanjani ku-DB

Ngemuva defiUma usunokuxhumana kwesizindalwazi, ungakusebenzisa kukhodi yakho Laravel. Ukuze wenze lokhu, ungasebenzisa i- facade yesizindalwazi. Lapho facade Isizindalwazi sinikeza isikhombimsebenzisi esihlanganisiwe sokusebenzelana nesizindalwazi.

Ukushintsha phakathi kokuxhumana kwesizindalwazi, ungasebenzisa indlela Connection() della facade Imininingo egciniwe. Indlela Connection() ithatha igama loxhumano lwesizindalwazi njengengxabano.

Isibonelo, ikhodi elandelayo isuka ku-mysql DB iye ku-pgsql DB:

use Illuminate\Support\Facades\DB;

DB::connection('pgsql');

Uma usushintshele ekuxhumekeni kwedathabheyisi, ungayisebenzisa ukuze ubuze futhi uxhumane nesizindalwazi.

Izinzuzo zokusebenzisa imininingwane eminingi eLaravel

Kunezinzuzo eziningi zokusebenzisa imininingwane eminingi eLaravel, kufaka phakathi:

• Ukusebenza okungcono: Ukusebenzisa imininingo egciniwe eminingi kungathuthukisa ukusebenza kohlelo lokusebenza ngokuhlukanisa idatha yezinhlobo ezahlukene. Isibonelo, ungase ugcine idatha yomsebenzisi kusizindalwazi esisodwa kanye nedatha yomkhiqizo kwenye isizindalwazi.
• Ukuvikeleka okukhulisiwe: Ukusebenzisa izizindalwazi eziningi kungathuthukisa ukuphepha kohlelo lokusebenza ngokuhlukanisa idatha yezinhlobo ezahlukene. Isibonelo, ungase ugcine idatha ebucayi kusizindalwazi esisodwa kanye nedatha ebucayi kancane kwenye isizindalwazi.
• Ukukaleka okukhulu: Ukusebenzisa isizindalwazi esiningi kungenza uhlelo lwakho lokusebenza lukhule kakhulu ngokukuvumela ukuthi usabalalise idatha yakho kumaseva amaningi.

Izindlela ezinhle kakhulu zokusebenzisa imininingwane eminingi eLaravel

Nansi imikhuba emihle yokusebenzisa imininingwane eminingi eLaravel:

• Sebenzisa amagama anobungane ekuxhumeni kusizindalwazi: Lokhu kuzokwenza kube lula ukuhlonza nokuphatha ukuxhumana kwesizindalwazi.
• Sebenzisa indlela Connection() ukusuka kokukodwa DB komunye - lokhu kuzokusiza ukugwema ukugijima ngephutha umbuzo isib database okungalungile.
• Sebenzisa isistimu yokuthutha egciniwe ukuze uphathe izikimu zesizindalwazi sakho - lokhu kuzokusiza ugcine izikimu zesizindalwazi sakho zivumelanisiwe kuzo zonke izindawo zakho. database.

isiphetho

Ukusebenzisa imininingo egciniwe eminingi ku-Laravel kungaba indlela enhle yokuthuthukisa ukusebenza, ukuvikeleka, kanye nokukaleka kohlelo lwakho lokusebenza. Ngokulandela izinqubo ezinhle kakhulu ezichazwe kulesi sihloko, ungasebenzisa imininingwane eminingi eLaravel ngempumelelo.

Ukufundwa Okuhlobene

• Blockchain ukuthi kusho ukuthini, ezinye izibonelo zokusetshenziswa kobuchwepheshe emhlabeni wangempela
• I-Laravel Database Seeder
• Ucwaningo lwe-Sophos Active Adversary Playbook 2022 luveza 'isikhathi sokuhlala kwezigebengu ze-inthanethi kumanethiwekhi ezisulu zabo' sikhuphuke ngo-36%.
• Blockchain incazelo nokuthi iyini, ukwakheka kanye nokuqanjwa okusha kwezobuchwepheshe
• I-JSP enokufinyelela kwe-SQL, Ungakuphatha kanjani ukufinyelela ku-sql DB ekhasini leseva ye-Java

Ercole Palmeri