SQLite-Python Quick Guide

• Source Code : How_To_Use_SQLITE3_Python_Ubuntu.ipynb

---

• How to install SQLite3 for Ubuntu:

  sudo apt-get install sqlite3 libsqlite3-dev
  

• How to Install sqlitebrowser for Ubunt:

  sudo apt-get install sqlitebrowser  
  

• How to use:

  • To start: ubuntu@ubuntu:~$ sqlite3

  • To quit: sqlite> .quit

  • To creat: ubuntu@ubuntu:~$ sqlite3 database_name.db

  • To check: sqlite> .databases

---

• Jupyter-notebook

sudo su -
apt-get update
apt-get install python-matplotlib
apt-get install python-scipy
pip install --upgrade pip
reboot
sudo pip install jupyter

---

• SQLite DB Browser

---

References

• SQLite Tutorial: https://www.tutorialspoint.com/sqlite/

• SQLite Quick Guide: https://www.tutorialspoint.com/sqlite/sqlite_quick_guide.htm