Ki jan yo enstale SQLite 3 ak navigatè SQLite 3 sou Ubuntu 20.04

SQLite se yon sistèm jesyon baz done relasyon ki lejè gratis (RDBMS) nan yon bibliyotèk C. SQLite se pa yon motè baz done kliyan-sèvè. Olye de sa, li entegre nan pwogram nan fen. Prensipalman tout langaj pwogramasyon sipòte SQLite, ki jan lang entegre pwogram nan se ak yon fichye ak ekstansyon .sqlite3/.sqlite/.DB. Lojisyèl la se yon chwa popilè pou depo lokal/kliyan tankou navigatè entènèt, aparèy android, ak plis ankò. Lis la se byen vaste.

SQLite Browser se yon platfòm lojisyèl grafik ak gratis pou devlope ak konsepsyon baz done SQLite.

Gid sa a pral montre w kouman pou w enstale dènye SQLite3 ak navigatè a Ubentu 20.04.

Kondisyon

Ubuntu OS enstale, gid la ap enstale lojisyèl an sou Ubuntu 20.04 Focal. Sepandan, Ubuntu 20.10 ak 21.04 gid la ap travay pou tou. Anvan enstale, asire w ke ou se ajou sou sistèm ou an.

sudo apt update && sudo apt upgrade 

reklam


Enstale SQLite3

Bibliyotèk default Ubuntu a vini ak SQLite. Antre kòmandman sa a pou enstale pake apt la.

sudo apt install sqlite3

Pakè sa yo pral enstale.

Reading package lists… Done
 Building dependency tree       
 Reading state information… Done
 Suggested packages:
   sqlite3-doc
 The following NEW packages will be installed:
   sqlite3
 0 upgraded, 1 newly installed, 0 to remove and 3 not upgraded.
 Need to get 860 kB of archives.
 After this operation, 2,803 kB of additional disk space will be used.

Enstale navigatè SQLite3

Apre ou fin enstale pake baz done SQLite3 a, kounye a ou ka enstale Navigatè GUI la. Sa a se yon pwogram ki senp ki fè li pi fasil pou navige nan baz done yo.

Enstale navigatè SQLite3 ak lòd sa a.

sudo apt install sqlitebrowser

Pakè sa yo pral enstale ak navigatè SQLite3.

~$ sudo apt install sqlitebrowser -y
 Reading package lists… Done
 Building dependency tree       
 Reading state information… Done
 The following additional packages will be installed:
   libdouble-conversion3 libpcre2-16-0 libqscintilla2-qt5-15 libqscintilla2-qt5-l10n libqt5core5a libqt5dbus5 libqt5gui5 libqt5network5 libqt5printsupport5 libqt5svg5 libqt5widgets5 libqt5xml5
   libxcb-xinerama0 libxcb-xinput0 qt5-gtk-platformtheme qttranslations5-l10n
 Suggested packages:
   libqscintilla2-doc qt5-image-formats-plugins qtwayland5
 The following NEW packages will be installed:
   libdouble-conversion3 libpcre2-16-0 libqscintilla2-qt5-15 libqscintilla2-qt5-l10n libqt5core5a libqt5dbus5 libqt5gui5 libqt5network5 libqt5printsupport5 libqt5svg5 libqt5widgets5 libqt5xml5
   libxcb-xinerama0 libxcb-xinput0 qt5-gtk-platformtheme qttranslations5-l10n sqlitebrowser
 0 upgraded, 17 newly installed, 0 to remove and 3 not upgraded.
 Need to get 13.4 MB of archives.
 After this operation, 58.5 MB of additional disk space will be used.

reklam


Lanse navigatè SQLite3

Pou lanse navigatè baz done a, premyèman, ale nan meni aplikasyon Ubuntu ou a epi jwenn pwogram nan.

sqlite 3 meni aplikasyon ubuntu

Finalman, ou pral wè rezilta a ak navigatè a. Isit la ou ka ajiste, kreye ak modifye baz done SQL lite ou yo.

sqlite 3 navigatè ubuntu

Ou te enstale avèk siksè SQLite 3 ak navigatè SQLite 3.

Kòmantè ak konklizyon

Gid la te montre w konfigirasyon pou enstale navigatè a ak baz done a. Pou plis enfòmasyon sou fason pou konstwi aplikasyon ak SQLite, vizite sit la SQLite 3 Tutorial.net gid. An jeneral, SQLite 3 se debaz men pwisan. Sepandan, li bon pou ti sit entènèt mwayen pou gwo sit entènèt k ap grandi yo gade nan MariaDB, MongoDB ak PostgreSQL, pami anpil lòt opsyon.

Leave a Comment