cara Install SQLite3 & SQLite Browser di Ubuntu
Install SQLite3 & SQLite Browser di Ubuntu
Link Blog:
https://lebahcoding.blogspot.com/2023...
Update Repository
$ sudo apt update
Install sqlite3
$ sudo apt install sqlite3
Check sqlite3 version
$ sqlite3 --version
Create database
$ sqlite3 data.db
Check path database
.database
main: /home/tegar/data.db
Create tabel
create table users(id integer, name varchar, address text);
Insert data
insert into users(id,name,address) values (1,"Neymar","Brazil"),(2,"Messi","Argentina");
Check table
.tables
users
Show header tabel
.headers on
Show data tabel
select * from users;
id|name|version
1|Neymar|Brazil
2|Messi|Argentina
ctrl+d == quit
==================================================
Check database with GUI using sqlitebrowser
// add repo ppa
$ sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser
// update
$ sudo apt update
// Install sqlitebrowser
$ sudo apt install sqlitebrowser
y
//how to access app
in terminal
$ sqlitebrowser
//Access file
Open Database file name