Kwinqaku elilandelayo siza kujonga ukuba singayifaka njani i-SQLite 3 kunye neSqliteBrowser kwi-Ubuntu. Ukuqala, kufuneka kuthiwe I-SQLite yi I-RDBMS kukhanya kwaye kuncinci. Ngelixa i-DB Browser yeSQLite (DB4S) okanye I-SQLiteBrowser, ngumgangatho ophezulu, isixhobo esibonakalayo kunye nesisiseko esivulekileyo sokwenza, ukuyila kunye nokuhlela iifayile zedatha ehambelana neSQLite.
Olunye ugcino lwedatha, njengeMySql okanye iPostgreSQL, isebenza kwimodeli yomncedisi kwaye ube nenkqubo yokuzinikela eqhuba kwaye ilawula yonke imiba yokusebenza kwiziko ledatha. Kodwa i-SQLite ayinayo nayiphi na inkqubo eqhubayo kwaye ayinayo imodeli yomncedisi wabathengi. I-SQLite DB yifayile nje enolwandiso .sqlite3 / .sqlite / .db. Ikhowudi ye-SQLite ihanjiswa ukuze isetyenziswe ngaphandle kwezithintelo kwaye ngaphandle kwentlawulo ngayo nayiphi na injongo.
I-DB4S okanye i-SQLiteBrowser isebenza kakhulu kubo bobabini abasebenzisi kunye nabaphuhlisi abafuna ukwenza, ukukhangela kunye nokuhlela iziseko sedatha. I-DB4S isebenzisa ujongano oluqhelekileyo lwespredishithi, Kwaye yenza ukuba kungafuneki ukuba ufunde imiyalelo enzima ngakumbi ye-SQL.
Ulawulo lwe-SQLiteBrowser kunye neewizard ziyafumaneka ukuze umsebenzisi a:
- Yenza kunye nokudibanisa iifayile zedatha.
- Chaza, wenze, uguqule kwaye ucime iitafile.
- Yenza, uchaze kwaye ucime izalathiso.
- Bhrawuza, uhlele, ungeze kwaye ucime iirekhodi.
- Yenza uphando.
- Ukungenisa kunye nokuthumela ngaphandle iirekhodi njengombhalo okanye iitafile ukusuka / ukuya kwiifayile ze-CSV.
- Ukungenisa kunye nokuthumela iziko ledatha ukusuka / ukuya kwiifayile zokulahla i-SQL.
- Khupha imibuzo ye-SQL kwaye ujonge iziphumo.
- Vavanya ilog yayo yonke imiyalelo ye-SQL ekhutshwe sisicelo.
- Cwangcisa iigrafu ezilula, esekwe kwitafile okanye kwidatha yombuzo.
Faka i-SQLite 3 kunye ne-SQLiteBrowser kwi-Ubuntu
Faka iSQLite 3
Ukuqala siza kuthi faka le RDBMS. Ukuseta i-SQLite kulula xa kuthelekiswa nolunye ugcino lwedatha njengeMySql, Postgresql, njl. Ngaphambi kokuqhubeka nofakelo, kuya kufuneka sihlaziye uluhlu lwesoftware ekhoyo. Ukwenza oku siza kuvula i-terminal (Ctrl + Alt + T) kwaye siya kwenza lo myalelo:
sudo apt update
ukuba faka iphakheji Kuyimfuneko, umyalelo olandelayo esiza kuwenza ulandelayo:
sudo apt install sqlite3
Emva kofakelo, sinako Qinisekisa ufakelo ngokuqala ngeseshoni ye-sqlite 3. Ukwenza oku, kwisiphelo esinye kufuneka ubhale:
sqlite3
Njengoko kunokubonwa kumfanekiso ongentla, i-SQLite 3 ifakwe ngempumelelo kwaye isebenza ngohlobo 3.31.1. Nangona namhlanje kukho iinguqulelo ezingaphezulu ngoku, yile iye yafakwa kwikhompyuter yam kwindawo yokugcina ubuntu
Yenza isiseko sedatha kunye netafile
Isiseko sedatha se-SQLite 3 siza kugcinwa njengefayile kwinkqubo yethu yefayile yendawo. Siza kuba nakho ukwenza isiseko sedatha xa siqala iseshoni ye-sqlite, sikhankanya igama ledatha njengempikiswano.
Ekusunguleni umyalelo, ukuba isiseko sedatha sikhona, iya kuvula isiseko sedatha. Ukuba asilibandakanyi igama ledatha njengempikiswano, kuya kwenziwa isiseko sedatha esikwiimemori esiza kucinywa kwakuphela iseshoni.
Kulo mzekelo siza kuwo Yenza isiseko sedatha ekuthiwa yifayile kwikhaya / kwikhaya / kwi-entreunosyceros (eligama lolawulo lomsebenzisi wasekhaya)
sqlite3 /home/nombre-usuario/prueba
Nje ukuba senziwe, sinako jonga ukuba yeyiphi na iseshoni yedatha odityaniswe kuyo ngalo myalelo:
.databases
Ukuqhubeka nomzekelo, masenze yenza itafile yesampulu ukuqhuba le mibuzo ilandelayo:
CREATE TABLE sistemas(Nombre String,version Real);
insert into sistemas(Nombre, version) VALUES ('Ubuntu',16.04), ('Ubuntu',18.04),('Ubuntu',20.04);
Ngoku sinako sebenzisa umyalelo iitafile ukudwelisa iitafile ezikhoyo kwiziko ledatha apho sinxibelelene khona:
.tables
Okwangoku sinako phrinta imixholo yetafile eyenzelwe lo mzekelo:
.headers on SELECT * FROM sistemas;
Faka iSQLiteBrowser
Nje ukuba sifake kwaye senze isiseko sedatha ngesqlite3, siza kuya faka iSQLiteBrowser. Ku malunga isixhobo esilula se-GUI sokulawula indawo yolwazi yethu. Ukwenza oku, siya kwenza kwisiphelo sendlela (Ctrl + Alt + T):
sudo apt install sqlitebrowser
Emva kofakelo, sinako qala isicelo ukusuka kwimenyu yokuqala. Singayivula ngokuvula i-terminal (Ctrl + Alt + T) kunye nokwenza lo myalelo:
sqlitebrowser
Emva kokumiliselwa kwenkqubo, i-GUI iya kuvula apho sinakho khona khetha isiseko sedatha esiyenzileyo ngaphambili kwisiphelo:
Khipha i-SQLite 3 kunye ne-SQLiteBrowser
ukuba susa zombini i-SQLite kunye ne-SQLiteBrowser, kufuneka sivule kuphela i-terminal (Ctrl + Alt + T) kwaye senze umthetho kuyo:
sudo apt --purge remove sqlite3 sqlitebrowser; sudo apt autoremove
Ku nokuba njalo funda ngakumbi nge-SQLite kwiphepha Amaxwebhu eprojekthi, kwaye Ukuba unomdla wokufunda ngakumbi nge-SQLiteBrowser, unokufumana ulwazi kwi iwebhusayithi yale nkqubo.