Mokhoa oa ho hlophisa Laravel ho sebelisa li-database tse ngata ho Morero oa hau

Ka tloaelo morero oa nts'etsopele ea software o kenyelletsa tšebeliso ea Database bakeng sa ho boloka data ka mokhoa o hlophisitsoeng.

Bakeng sa merero e itseng ho ka 'na ha hlokahala hore ho sebelisoe li-database tse ngata.

Ka Laravel, ho sebelisa li-database tse ngata, re hloka ho hlophisa moralo mme haholo-holo faele ea tlhophiso ea likhokahano.

Ha re boneng mokhoa oa ho hlophisa Laravel ho sebelisa li-database tse ngata.

Khakanyo ea nako ea ho bala: 4 minuti

faele database.php in config dibaka

Faele ena e fumaneha bukeng config ea kopo ea hau ea Laravel.

Ka faeleng database.php hoa khoneha defitlosa likhokahano tse ngata tsa database. Khokahano e ngoe le e ngoe e tlameha ho ba defie entsoe joalo ka sehlopha. Sehlopha se tlameha ho ba le lintlha tse latelang:

• driver: mokhanni oa database oo u ka o sebelisang;
• host: lebitso host kapa aterese IP ea seva sa database;
• port: nomoro ea boema-kepe ea seva sa database;
• database: lebitso la database;
• username: lebitso la mosebedisi bakeng sa ho hokela polokelongtshedimosetso;
• password: phasewete ea ho hokela ho database;

Ka mohlala, khoutu e latelang defiHo na le likhokahano tse peli tsa database, e 'ngoe ea MySQL le e' ngoe bakeng sa 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',
        ],

Mokhoa oa ho hokela DB

Kamora defiHa u se u e-na le likhokahano tsa database, u ka li sebelisa khoutu ea hau Laravel. Ho etsa sena, o ka sebelisa sesebelisoa facade ea database. Mono facade database e fana ka sebopeho se kopaneng sa ho sebelisana le database.

Ho chencha lipakeng tsa likhokahano tsa database, o ka sebelisa mokhoa Connection() ya facade Databases. Mokhoa Connection() e nka lebitso la khokahanyo ea database e le khang.

Mohlala, khoutu e latelang e tloha ho mysql DB ho ea ho pgsql DB:

use Illuminate\Support\Facades\DB;

DB::connection('pgsql');

Hang ha u fetohela ho khokahanyo ea database, u ka e sebelisa ho botsa le ho sebelisana le database.

Melemo ea ho sebelisa li-database tse ngata ho Laravel

Ho na le melemo e mengata ea ho sebelisa li-database tse ngata ho Laravel, ho kenyelletsa:

• Ts'ebetso e betere: Ho sebelisa li-database tse ngata ho ka ntlafatsa ts'ebetso ea ts'ebeliso ka ho arola data ea mefuta e fapaneng. Mohlala, o ka boloka data ea mosebelisi polokelong e le 'ngoe le data ea sehlahisoa sebakeng se seng sa polokelo.
• Ts'ireletso e ntlafalitsoeng: Ho sebelisa li-database tse ngata ho ka ntlafatsa ts'ireletso ea ts'ebeliso ka ho arola data ea mefuta e fapaneng. Ka mohlala, u ka 'na ua boloka boitsebiso ba bohlokoa ka har'a database e le' ngoe le boitsebiso bo fokolang bo fokolang sebakeng se seng sa polokelo.
• Scalability e kholoanyane: Ho sebelisa li-database tse ngata ho ka etsa hore kopo ea hau e fokotsehe haholoanyane ka ho u lumella ho aba lintlha tsa hau ho li-server tse ngata.

Mekhoa e metle ea ho sebelisa li-database tse ngata ho Laravel

Mona ke mekhoa e metle ea ho sebelisa li-database tse ngata ho Laravel:

• Sebelisa mabitso a botsoalle bakeng sa likhokahano tsa database: Sena se tla nolofaletsa ho tseba le ho laola likhokahano tsa database.
• Sebelisa mokhoa Connection() ho tloha ho enngwe DB ho e mong - sena se tla u thusa ho qoba ho matha ka phoso potso ka boroa polokelongtshedimosetso phoso.
• Sebelisa mokhoa oa ho falla ha database ho laola schemas ea hau ea polokelo ea boitsebiso - sena se tla u thusa ho boloka meralo ea hau ea polokelo ea boitsebiso e lumellana hohle hohle. polokelongtshedimosetso.

bofello

Ho sebelisa li-database tse ngata ho Laravel e ka ba mokhoa o motle oa ho ntlafatsa ts'ebetso, ts'ireletso le sekhahla sa ts'ebeliso ea hau. Ka ho latela mekhoa e metle e hlalositsoeng sengolong sena, o ka sebelisa li-database tse ngata ho Laravel ka nepo.

Litemana Tse Amanang

• Blockchain seo e se bolelang, mehlala e meng ea tšebeliso ea theknoloji lefatšeng la sebele
• Laravel Database Seeder
• Lipatlisiso tsa Sophos Active Adversary Playbook 2022 li senola "nako ea ho lula ha li-cybercriminals ho marang-rang a bahlaseluoa" e eketsehile ka 36%.
• Blockchain moelelo le seo e leng sona, tlhamo le popontshwa ya thekenoloji
• JSP e nang le phihlello ea SQL, Mokhoa oa ho laola phihlello ea sql DB Leqepheng la Seva ea Java

Ercole Palmeri