Select Page

Setting up Django with Apache2

SSL Certificate Make Virtual Hosts, Lets Encrypt https://www.digitalocean.com/community/tutorials/how-to-secure-apache-with-let-s-encrypt-on-ubuntu-18-04 Setting.py with open(‘/etc/db_pass.txt’) as g: DB_PASS = g.read().strip() wkhtmltopad Make sure...

MySQL backups

Back up a database mysqldump -u [username] –p[password] [database_name] > [dump_file.sql] Restore a database mysql -u [username] –p[password] [database_name] < [dump_file.sql]

Search for programs or files in command prompt

Search Command: dir /s /b filename The /s command allows you to view all files of a certain type within all subsequent folders of your current path. You can search for a specific file, as in the example above, or use a wildcard ‘*’ to view all files of a...

Getting started with xlsxwriter and Django

Install xlsxwriter #pip install XlsxWriter Or follow instructions here: https://xlsxwriter.readthedocs.io/getting_started.html Imports import io from xlsxwriter.workbook import Workbook from django.http import HttpResponse views.py def download_excel_view(request,...