Otu esi etinye SQLite 3 na SQLite 3 Browser na Ubuntu 20.04

SQLite bụ n'efu, sistemu njikwa nchekwa data dị fechaa (RDBMS) n'ọbá akwụkwọ C. SQLite abụghị igwe nchekwa data nke ndị ahịa. Kama, etinyere ya na mmemme ngwụcha. N'ụzọ bụ isi, asụsụ mmemme niile na-akwado SQLite, nke otu asụsụ si etinye mmemme bụ faịlụ nwere ndọtị .sqlite3/.sqlite/.DB. Akụrụngwa bụ nhọrọ a ma ama maka nchekwa mpaghara/ndị ahịa dị ka ihe nchọgharị weebụ, ngwaọrụ gam akporo na ọtụtụ ndị ọzọ. Ndepụta a sara mbara nke ukwuu.

SQLite Browser bụ ihe eserese na sọftụwia efu maka ịzụlite na chepụta ọdụ data SQLite.

Ntuziaka na-esonụ ga-egosi gị otu esi etinye SQLite3 na ihe nchọgharị na Ubuntu 20.04.

Prerequisites

Ubuntu OS arụnyere, onye ndu na-etinye ngwanrọ na Ubuntu 20.04 Focal. Agbanyeghị, Ubuntu 20.10 na 21.04 ntuziaka ga-arụkwa ọrụ maka ya. Tupu ịwụnye, jide n'aka na ị na-emelite na sistemụ gị.

sudo apt update && sudo apt upgrade 

Advertisement


Wụnye SQLite3

Ọbá akwụkwọ ndabara nke Ubuntu na-abịa na SQLite. Tinye iwu a ka ịwụnye ngwugwu dabara adaba.

sudo apt install sqlite3

A ga-etinye ngwugwu ndị a.

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.

Wụnye ihe nchọgharị SQLite3

Mgbe ị wụnyechara ngwugwu nchekwa data SQLite3, ugbu a ị nwere ike iwunye ihe nchọgharị GUI. Nke a bụ mmemme dị mfe nke na-eme ka ọ dị mfe ịnyagharịa ọdụ data.

Wụnye ihe nchọgharị SQLite3 site na iji iwu a.

sudo apt install sqlitebrowser

A ga-eji ihe nchọgharị SQLite3 tinye ngwugwu ndị a.

~$ 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.

Advertisement


Mepee ihe nchọgharị SQLite3

Iji malite ihe nchọgharị nchekwa data, buru ụzọ gaa na ngwa ngwa Ubuntu gị wee chọta mmemme ahụ.

sqlite 3 menu ngwa ubuntu

N'ikpeazụ, ị ga-ahụ nsonaazụ ya na ihe nchọgharị ahụ. N'ebe a, ị nwere ike ịhazigharị, mepụta ma gbanwee ọdụ data SQL Lite gị.

sqlite 3 ihe nchọgharị ubuntu

Ị tinyela SQLite 3 na SQLite 3 Browser nke ọma.

Okwu na mmechi

Ntuziaka ahụ egosila gị nhazi maka ịwụnye ihe nchọgharị na nchekwa data. Maka ozi ndị ọzọ ka esi eji SQLite wuo ngwa, gaa na SQLite 3 Tutorial.net ndu. N'ozuzu, SQLite 3 bụ isi mana dị ike. Otú ọ dị, ọ dị mma maka obere weebụsaịtị maka nnukwu weebụsaịtị na-eto eto iji lelee MariaDB, MongoDB na PostgreSQL, n'etiti ọtụtụ nhọrọ ndị ọzọ.

Ahapụ a Comment