Skip to content

Latest commit

 

History

History
52 lines (35 loc) · 1.2 KB

File metadata and controls

52 lines (35 loc) · 1.2 KB

SQLite-Python Quick Guide


  • 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_JupyterNotebook.png


  • SQLite DB Browser

INSERTOperation.png


References