How to change Django's SQLite3 uploaded to python anywhere with GUI only

How to change Django data uploaded to python anywhere. A memorandum of how to change intuitively without using the command line.

What I wanted to do ・ I wanted to update the link and image of the app on my portfolio site, which I had left for a while.

Image before change

Step 1 Open the console screen of python anywhere and go to the folder where the sqllite3 file is located. Download the sqlite3 file.

スクリーンショット 2020-10-20 205239.png

Step 2 Use DB Browser (sqlite) to open the downloaded db.sqlite3 file.

sql3broser.png

Step 3 Change the link destination and the new image name. After making changes, press Apply.

editdatabase.png

Step 4 Upload a new image. From the console screen of python anywhere, move to the folder where the photo is placed (static is set). Upload a new image. (Make sure that it matches the image name changed in step 3.)

upload_pic.png

Step 5

Once again, go to the folder that contains the sqlite3.db file and upload and replace the locally rewritten sqlite3.db.

変更後.png

This completes the correction.

Recommended Posts

How to change Django's SQLite3 uploaded to python anywhere with GUI only
How to change Python version
Python: How to use async with
How to use SQLite in Python
How to get started with Python
How to use FTP with Python
How to calculate date with python
How to import CSV and TSV files into SQLite with Python
How to use ManyToManyField with Django's Admin
How to work with BigQuery in Python
How to do portmanteau test with python
How to display python Japanese with lolipop
Trying to handle SQLite3 with Python [Note]
How to enter Japanese with Python curses
[Python] How to deal with module errors
How to install python3 with docker centos
How to upload with Heroku, Flask, Python, Git (4)
How to read a CSV file with Python 2/3
How to enjoy programming with Minecraft (Ruby, Python)
[REAPER] How to play with Reascript in Python
How to do multi-core parallel processing with python
Strategy on how to monetize with Python Java
[Python] How to change the date format (display format)
[Python] How to draw multiple graphs with Matplotlib
[Python] How to read excel file with pandas
How to crop an image with Python + OpenCV
How to communicate asynchronously only with Touch Designer
How to specify attributes with Mock of python
How to measure execution time with Python Part 1
How to use tkinter with python in pyenv
[Python] How to handle Japanese characters with openCV
How to handle datetime type in python sqlite3
[Python] How to compare datetime with timezone added
How to measure execution time with Python Part 2
How to convert / restore a string with [] in python
How to add help to HDA (with Python script bonus)
How to install Python
[Python] How to draw a line graph with Matplotlib
How to scrape image data from flickr with python
How to do hash calculation with salt in Python
[Introduction to Python] How to iterate with the range function?
Explain in detail how to make sounds with python
Change IP settings to ACL of conoha with python
How to get a logged-in user with Django's forms.py
How to upload with Heroku, Flask, Python, Git (Part 3)
How to deal with Django's Template Does Not Exist
How to run tests in bulk with Python unittest
[Python] How to specify the download location with youtube-dl
How to install python
How to measure mp3 file playback time with python
How to use python interactive mode with git bash
How to convert JSON file to CSV file with Python Pandas
How to upload with Heroku, Flask, Python, Git (Part 1)
[Python] How to deal with pandas read_html read error
How to run setUp only once in python unittest
How to upload with Heroku, Flask, Python, Git (Part 2)
How to get mouse wheel verdict with Python curses
[Work efficiency] How to change file names in Python
[Python] How to rewrite the table style with python-pptx [python-pptx]
[Python] How to create a 2D histogram with Matplotlib
How to switch to smartphone mode with Python + Selenium + Chrome