loutility development process documentation
latest
Contents:
CentOS LAMP Server Create
Create Droplet
Some Upkeep [root]
Additional repos
sudo user
Create non-root user and give sudo access [root]
Set sudo timeout (minutes)
Set up digitalocean agent for monitoring [root]
history should display date/time
Set local time and keep in sync
Turn off cron information to /var/log/messages
Set /usr/local/lib in library path
LAMP and Security Stack
Set up LAMP stack
install additional PHP versions
Create a2ensite, a2dissite
Set up VHOST
Backups
Create backup volume
Set up backup
Resize backup volume (only if necessary)
Set up swap volume
Security
Set up server level security
Linux User Account Creation
Add to digitalocean team
Linux Virtual Host Setup
Create user for VHOST update
Update DNS (optional)
Create VHOST
Enable VHOST
Set up VHOST SSL
MySQL Database Management
Install and access phpMyAdmin
Create MySQL Database
Create MySQL Database User
Give MySQL User Access to MySQL Database
database dump / restore
Database Migration Handling
Getting Started with alembic
Database Migration
Column update during upgrade
Export Database from MAMP Server
Database Migration (obsolete - bare alembic - early apps)
python Package Release Procedures
release to github
sync your fork
release to PyPi
test release with editable install
create .pypirc
release
Initial deploy to server
Ongoing Development
PyCharm Licencing
HTTPS Support Notes
Prepare for SSL Certificate
Get certificates from letsencrypt.com
Notes
admin vs. apache user
steps
Security Tips
Python 3
Install on Centos
Convert production project from python 2 to python 3
Install on Windows
Convert development project from python 2 to python 3
Upgrade to newer version of python 3
Development Environment
Target Environment
Linux - Random Procedures
Set Script as Service
Development Environment
Required Software
Required account access
Development System Configuration
Shell file permissions
Docker files
vscode launch.json
Development vs Production via docker compose
Build and start app in development, no debugging
Build and start app in development, with debugging
Build and start app in Production
Development Workflow
Docker Development
Installation
Useful Links
Network Troubleshooting
MySQL
CI/CD Workflow
Compose repository
strconv.Atoi: parsing “”: invalid syntax
secrets management
security
deploy compose application
Debugging a Docker Service Locally
Some Required Files
Launch Debugger from vscode
Debug pypi Package Stored Locally
Restart Service
Apache Configuration
flask db migrations
Initial Deploy of Docker Web App to Server
Patterns
loutilities.tables-assets
loutilities.user single sign-on
interests task with single sign-on
optimistic concurrency control for edit window
show popup after edit update
spoof id for database behavior on composite records
button icon for table action on row
standalone Editor popup for datatables button handler
datatable child row
without embedded table(s)
with embedded table(s)
data dependent columns
data dependent select options
row reorder control
add filters to table view
Definitions
loutility development process documentation
Index
Edit on GitHub
Index
F
|
G
|
O
|
R
|
U
F
fork
G
git
O
origin
R
remote
repository
U
upstream
Read the Docs
v: latest
Versions
latest
Downloads
On Read the Docs
Project Home
Builds