Yadda ake saita Laravel don amfani da bayanai da yawa a cikin Aikin ku

Yawanci aikin haɓaka software ya ƙunshi amfani da Database don adana bayanai ta hanyar da aka tsara.

Don takamaiman ayyuka yana iya zama dole don amfani da bayanan bayanai da yawa.

Tare da Laravel, don amfani da bayanan bayanai da yawa, muna buƙatar saita tsarin kuma musamman fayil ɗin daidaitawar haɗin kai.

Bari mu ga yadda ake saita Laravel don amfani da ma'ajin bayanai da yawa.

Kiyasta lokacin karantawa: 4 minti

fayil database.php in config directory

Wannan fayil ɗin yana cikin kundin adireshi config na aikace-aikacen Laravel.

A cikin fayil database.php mai yiwuwa ne definish mahara database sadarwa. Dole ne kowace haɗi ta kasance definited a matsayin tsararru. Ya kamata tsarin ya ƙunshi bayanai masu zuwa:

• driver: direban bayanai don amfani;
• host: suna host ko kuma adireshin IP na uwar garken bayanai;
• port: lambar tashar tashar uwar garken bayanai;
• database: sunan bayanai;
• username: sunan mai amfani don haɗawa da bayanan;
• password: kalmar sirri don haɗi zuwa bayanan;

Misali, lambar mai zuwa defiAkwai haɗin bayanai guda biyu, ɗaya don MySQL kuma ɗaya don 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',
        ],

Yadda ake haɗawa da DB

Bayan defiDa zarar kuna da haɗin bayanai, zaku iya amfani da su a cikin lambar ku Laravel. Don yin wannan, za ka iya amfani da facade na database. Akwai facade database yana ba da haɗin haɗin kai don hulɗa tare da bayanan bayanai.

Don canzawa tsakanin haɗin bayanai, zaka iya amfani da hanyar Connection() della facade Databases. Hanyar Connection() yana ɗaukar sunan haɗin bayanai a matsayin hujja.

Misali, lambar mai zuwa tana tafiya daga mysql DB zuwa pgsql DB:

use Illuminate\Support\Facades\DB;

DB::connection('pgsql');

Da zarar ka canza zuwa haɗin bayanai, za ka iya amfani da shi don tambaya da mu'amala tare da bayanan.

Fa'idodin amfani da rumbun adana bayanai da yawa a cikin Laravel

Akwai fa'idodi masu yawa don amfani da bayanan bayanai da yawa a cikin Laravel, gami da:

• Kyakkyawan aiki: Yin amfani da ma'ajin bayanai da yawa na iya inganta aikin aikace-aikacen ta hanyar rarraba bayanai na nau'ikan daban-daban. Misali, zaku iya adana bayanan mai amfani a cikin rumbun adana bayanai ɗaya da bayanan samfuri a cikin wata rumbun bayanai.
• Ingantaccen tsaro: Yin amfani da ma'ajin bayanai da yawa na iya inganta tsaro na aikace-aikace ta hanyar rarraba bayanai iri daban-daban. Misali, zaku iya adana bayanai masu mahimmanci a cikin rumbun adana bayanai guda ɗaya da kuma bayanan da ba su da mahimmanci a cikin wata rumbun adana bayanai.
• Girman haɓakawa: Yin amfani da bayanan bayanai da yawa na iya sa aikace-aikacenku ya fi girma ta hanyar ba ku damar rarraba bayanan ku a cikin sabar da yawa.

Mafi kyawun ayyuka don amfani da bayanai masu yawa a cikin Laravel

Anan akwai mafi kyawun ayyuka don amfani da bayanan bayanai da yawa a cikin Laravel:

• Yi amfani da sunaye na abokantaka don haɗin bayanai: Wannan zai sauƙaƙa ganowa da sarrafa haɗin bayanai.
• Yi amfani da hanyar Connection() zuwa daga daya DB zuwa wani - wannan zai taimake ka ka guje wa guje-guje da gangan tambaya sul database ba daidai ba.
• Yi amfani da tsarin ƙaura don sarrafa tsarin bayanan bayananku - wannan zai taimaka muku ci gaba da daidaita tsarin bayanan bayananku a duk faɗin ku. database.

ƙarshe

Yin amfani da bayanai masu yawa a cikin Laravel na iya zama babbar hanya don haɓaka aiki, tsaro, da haɓakar aikace-aikacen ku. Ta bin kyawawan ayyuka da aka kwatanta a cikin wannan labarin, zaku iya amfani da bayanan bayanai da yawa a cikin Laravel yadda ya kamata.

Karatun masu alaƙa

• Blockchain abin da ake nufi, wasu misalan aikace-aikacen fasaha a duniyar gaske
• Laravel Database Seeder
• Binciken Sophos Active Adversary Playbook 2022 ya nuna 'lokacin zama a cikin hanyoyin sadarwar wadanda abin ya shafa' ya karu da 36%
• Blockchain ma'ana da abin da yake, abun da ke ciki da fasahar fasaha
• JSP tare da damar SQL, Yadda ake sarrafa damar zuwa sql DB a cikin Shafin Sabar Java

Ercole Palmeri