Yadda ake Shigar da SQLite da kuma SQLite Browser a cikin Ubuntu

SQLite nauyi ne mai nauyi, karami kuma mai dauke da RDBMS a cikin dakin karatu na C. Shahararrun ɗakunan bayanai kamar MySQL, PostgreSQL, da dai sauransu suna aiki a cikin ƙirar uwar garken abokin ciniki kuma suna da tsarin sadaukarwa da ke gudana da kuma sarrafa dukkan ɓangarorin aikin bayanan.

Amma SQLite ba shi da wani tsari da yake gudana kuma ba shi da samfurin uwar garken abokin ciniki. SQLite DB shine kawai fayil tare da .sqlite3/.sqlite/.db tsawo. Kowane yare na shirye-shirye yana da laburare don tallafawa SQLite.

Kuna iya samun amfani da SQLite a ciki

Masu binciken yanar gizo (Chrome, Safari, Firefox).
MP3 players, akwatunan da aka saita, da kayan aikin lantarki.
Intanit na Abubuwa (IoT).
Android, Mac, Windows, iOS, da kuma na'urorin iPhone.

Akwai ƙarin ƙarin wuraren da ake amfani da SQLite. Kowane wayo a duniya yana da ɗaruruwan fayilolin bayanan SQLite kuma akwai sama da tiriliyan tarin bayanai cikin aiki mai amfani. Wannan yana da yawa a cikin lambobi.

Shigar da SQLite a Ubuntu

Kafa SQLite yana da sauki idan aka kwatanta shi da sauran sanannun rumbunan adana bayanai kamar MySQL, Postgresql, da sauransu. Da farko, sabunta apt-cache ta hanyar bin umarnin nan mai zuwa.

$ sudo apt update

Yanzu bincika idan akwai wasu fakitin SQLite da ke cikin madaidaicin wurin adanawa ta hanyar bin umarnin nan mai zuwa.

$ sudo apt-cache search sqlite

Don shigar da kunshin gudu umarni mai zuwa.

$ sudo apt install sqlite3

Kuna iya inganta shigarwar ta fara zaman sqlite ta hanyar aiwatar da umarni mai zuwa.

$ sqlite3

Kuna iya gani daga hoton da ke sama SQLite3 an sami nasarar shigar da aiki tare da sigar 3.33.0 ..

Irƙiri Database na SQLite da Tebur

Ana adana bayanan kawai azaman fayil a cikin tsarin fayil na gida. Kuna iya ƙirƙirar ɗakunan ajiya lokacin ƙaddamar da zaman sqlite ta ambaton sunan bayanan a matsayin hujja. Idan tarin bayanan yana nan zai bude bayanan in ba haka ba zai kirkiri sabon rumbun adana bayanai.

Idan ba zamu wuce sunan bayanan ba a matsayin hujja to sai a ƙirƙiri ɗakunan ajiya na wucin gadi na wucin gadi wanda za'a share shi da zarar an gama zaman. Anan bani da wani rumbun adana bayanai don haka zan kirkiro sabon DB ta hanyar ambaton sunan DB a matsayin hujja. Da zarar an haɗa ku da zaman za ku iya gudanar da umarnin .databases don ganin wane fayil ɗin da aka haɗe a cikin bayanan.

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

Yanzu bari mu kirkiro tebur samfurin ta aiwatar da waɗannan tambayoyin.

# 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);

Kuna iya gudanar da umarnin .tables don jera tebur a cikin bayanan.

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

Shigar da Binciken SQLite a cikin Ubuntu

Yanzu tunda munga yadda ake girka da saita sqlite3 zamu kuma girka mai binciken sqlite, kayan aikin GUI ne mai sauki don sarrafa rumbun adana bayananku na sqlite.

$ sudo apt install sqlitebrowser -y

Kuna iya ƙaddamar da aikace-aikacen daga menu na farawa ko daga m. Don farawa daga tashar gudu umarni mai zuwa.

$ sqlitebrowser &

Cire SQLite da SQLite Browser

Gudun umarni mai zuwa don cire duka mai binciken SQLite da SQLite.

$ sudo apt --purge remove sqlite3 sqlitebrowser

Shi ke nan ga wannan labarin. Idan kuna da wata amsa ko nasiha da fatan za ayi amfani da sashin sharhi don sanya shi.