Maitiro ekugadzirisa Laravel kushandisa akawanda dhatabhesi muProjekti yako

Kazhinji chirongwa chekuvandudza software chinosanganisira kushandiswa kweDatabase yekuchengetedza data nenzira yakarongeka.

Kune mapurojekiti chaiwo zvingave zvakakosha kushandisa akawanda dhatabhesi.

NaLaravel, kushandisa akawanda dhatabhesi, isu tinofanirwa kugadzirisa iyo dhizaini uye kunyanya iyo yekubatanidza yekumisikidza faira.

Ngationei maitiro ekugadzirisa Laravel kushandisa akawanda dhatabhesi.

Inofungidzirwa nguva yekuverenga: 4 minuti

faira database.php in config dhairetori

Iri faira riri mudhairekitori config yeLaravel application yako.

Mufaira database.php zvinogoneka definish akawanda database yekubatanidza. Kubatana kwese kunofanirwa kuve defiyakaitwa seyakarongwa. The array inofanira kuva nemashoko anotevera:

• driver: mutyairi we database yekushandisa;
• host:zita host kana kuti kero IP ye database server;
• port: iyo database server port nhamba;
• database: zita re database;
• username: zita rekushandisa rekubatanidza kune database;
• password: password yekubatanidza kune database;

Semuenzaniso, iyo inotevera kodhi defiKune maviri ekubatanidza database, imwe yeMySQL uye imwe yePostgreSQL:

'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',
        ],

Ungabatanidza sei kuDB

Pashure defiPaunenge uchinge uine database yekubatanidza, unogona kuzvishandisa mukodhi yako Laravel. Kuti aite izvi, unogona kushandisa facade ye database. Ikoko facade database inopa yakabatana interface yekudyidzana nedatabase.

Kuchinja pakati pekubatanidza database, unogona kushandisa nzira Connection() della facade Databases. Nzira Connection() inotora zita rekubatanidza database senharo.

Semuenzaniso, iyo inotevera kodhi inoenda kubva kune mysql DB kuenda kune pgsql DB:

use Illuminate\Support\Facades\DB;

DB::connection('pgsql');

Paunenge uchinge wachinja kune dhatabhesi yekubatanidza, unogona kuishandisa kubvunza uye kupindirana nedhatabhesi.

Mabhenefiti ekushandisa akawanda dhatabhesi muLaravel

Kune akawanda mabhenefiti ekushandisa akawanda dhatabhesi muLaravel, kusanganisira:

• Kuita kurinani: Kushandisa akawanda dhatabhesi kunogona kuvandudza mashandiro ekushandisa nekuparadzanisa data remhando dzakasiyana. Semuenzaniso, unogona kuchengetedza data remushandisi mune imwe dhatabhesi uye chigadzirwa data mune imwe dhatabhesi.
• Kuchengetedzwa kwakawedzerwa: Kushandisa akawanda dhatabhesi kunogona kuvandudza chengetedzo yekushandisa nekuparadzanisa data remhando dzakasiyana. Semuenzaniso, iwe unogona kuchengetedza data rakadzama mune imwe dhatabhesi uye isina kusimba data mune imwe dhatabhesi.
• Kuwedzera scalability: Kushandisa akawanda dhatabhesi kunogona kuita kuti application yako iwedzere nekukubvumidza iwe kugovera data rako pamaseva akawanda.

Maitiro akanakisa ekushandisa akawanda dhatabhesi muLaravel

Heano mamwe akanakisa maitiro ekushandisa akawanda dhatabhesi muLaravel:

• Shandisa mazita ane hushamwari ekubatanidza database: Izvi zvichaita kuti zvive nyore kuziva uye kubata database yekubatanidza.
• Shandisa nzira Connection() kuenda kubva kune imwe DB kune imwe - izvi zvichakubatsira kudzivisa kumhanya netsaona mubvunzo s Database zvakaipa.
• Shandisa dhatabhesi yekufambisa sisitimu kubata yako dhatabhesi schemas - izvi zvichakubatsira iwe kuchengetedza dhatabhesi schemas yako mukuwirirana pane ako ese. Database.

mhedziso

Kushandisa akawanda dhatabhesi muLaravel inogona kuve nzira huru yekuvandudza mashandiro, chengetedzo, uye scalability yechishandiso chako. Nekutevera akanakisa maitiro anotsanangurwa muchinyorwa chino, unogona kushandisa akawanda dhatabhesi muLaravel zvinobudirira.

Related Readings

• Blockchain zvazvinoreva, mimwe mienzaniso yekushandisa tekinoroji munyika chaiyo
• Laravel Database Seeder
• Sophos Active Adversary Playbook 2022 tsvagiridzo inoratidza cybercriminals 'nguva yekugara muvanovashungurudza' network yakawedzera ne36%
• Blockchain zvinoreva uye kuti chii, kuumbwa uye kuvandudzwa kwetekinoroji
• JSP ine SQL yekuwana, Maitiro ekugadzirisa kuwana kune sql DB muJava Server Peji

Ercole Palmeri