Otu esi etinye SQLite na SQLite Browser na Ubuntu

SQLite bụ RDBMS dị fechaa, obere na nke nwere onwe ya n'ọbá akwụkwọ C. Ebe nchekwa data a ma ama dị ka MySql, PostgreSQL, wdg na-arụ ọrụ na ụdị ihe nkesa ahịa na ha nwere usoro raara onwe ya nye na-agba ọsọ ma na-achịkwa akụkụ niile nke ọrụ nchekwa data.

Mana SQLite enweghị usoro na-agba ọsọ yana enweghị ụdị ihe nkesa ahịa. SQLite DB bụ naanị faịlụ nwere ndọtị .sqlite3/.sqlite/.db. Asụsụ mmemme ọ bụla nwere ọba akwụkwọ iji kwado SQLite.

Ị nwere ike ịhụ SQLite na-eji

Ihe nchọgharị weebụ (Chrome, Safari, Firefox).
Ndị egwuregwu MP3, igbe set-top, na ngwa eletrọnịkị.
Internet of Things (IoT).
Ngwaọrụ Android, Mac, Windows, iOS, na iPhone.

Enwere ọtụtụ mpaghara ebe a na-eji SQLite. Igwe ekwentị ọ bụla dị n'ụwa nwere ọtụtụ narị faịlụ nchekwa data SQLite yana enwere ihe karịrị otu puku ijeri ọdụ data na-arụ ọrụ. Nke ahụ buru oke ibu na ọnụọgụ.

Wụnye SQLite na Ubuntu

Ịtọlite SQLite dị mfe ma e jiri ya tụnyere ọdụ data ndị ọzọ na-ewu ewu dị ka MySql, Postgresql, wdg. Nke mbụ, melite apt-cache site n'ịgba iwu na-esonụ.

$ sudo apt update

Ugbu a lelee ma enwere ngwungwu SQLite ọ bụla dị na ebe nchekwa apt site na iji iwu na-esonụ.

$ sudo apt-cache search sqlite

Iji wụnye ngwugwu na-agba iwu na-esonụ.

$ sudo apt install sqlite3

Ị nwere ike kwado nrụnye ahụ site na ịmalite nnọkọ sqlite site na ịme iwu na-esonụ.

$ sqlite3

Ị nwere ike ịhụ site na foto dị n'elu SQLite3 arụnyere nke ọma ma na-agba ọsọ na ụdị 3.33.0.

Mepụta ọdụ data SQLite na tebụl

A na-echekwa nchekwa data dị ka faịlụ na sistemụ faịlụ mpaghara gị. Ị nwere ike ịmepụta nchekwa data mgbe ịmalite nnọkọ sqlite site n'ịkpọ aha nchekwa data dị ka arụmụka. Ọ bụrụ na nchekwa data dị, ọ ga-emepe nchekwa data ma ọ bụrụ na ọ bụghị, ọ na-emepụta nchekwa data ọhụrụ.

Ọ bụrụ na anyị anaghị agafe aha nchekwa data dị ka arụmụka mgbe ahụ, a na-emepụta nchekwa data nchekwa nchekwa nwa oge nke ga-ehichapụ ozugbo nnọkọ ahụ kwụsịrị. N'ebe a, enweghị m nchekwa data ọ bụla, m ga-emepụta DB ọhụrụ site n'ịkpọ aha DB dị ka arụmụka. Ozugbo ị jikọọ na nnọkọ ahụ, ị nwere ike ịme iwu .databases iji hụ faịlụ agbakwunyere na nchekwa data.

$ sqlite3 /home/tecmint/test     # creating test db in /home/tecmint
sqlite> .databases            # To see which database session is connected

Ugbu a, ka anyị mepụta tebụl ihe atụ site n'imezu ajụjụ ndị a.

# create table

sqlite> CREATE TABLE employee(  
             Name String,            
             age Int);       

# Insert records

sqlite> insert into employee(Name, age)
            VALUES ('Tom',25),             
            ('Mark',40),                   
            ('Steve',35);

Ị nwere ike ịme iwu .tables ka ịdepụta tebụl na nchekwa data.

sqlite> .tables                       # List tables in database
sqlite> .headers on                   # Turn on column for printing
sqlite> SELECT * FROM employee;       # Selecting record from table

Ịwụnye SQLite Browser na Ubuntu

Ugbu a anyị ahụla ka esi etinye na nhazi sqlite3 anyị ga-etinyekwa ihe nchọgharị sqlite, ngwa GUI dị mfe iji jikwaa ọdụ data sqlite gị.

$ sudo apt install sqlitebrowser -y

Ị nwere ike ịmalite ngwa site na mmalite menu ma ọ bụ site na ọnụ. Ka ịmalite site na ọnụ, gbanye iwu na-esonụ.

$ sqlitebrowser &

Wepu SQLite na SQLite Browser

Gbaa iwu a ka iwepu ma SQLite na SQLite nchọgharị.

$ sudo apt --purge remove sqlite3 sqlitebrowser

Nke ahụ bụ maka akụkọ a. Ọ bụrụ na ị nwere nzaghachi ma ọ bụ ndụmọdụ biko jiri ngalaba nkọwa bipute ya.