User:Alvonruff

Founder of the ISFDB.

Python3 Notes

General outline of steps to move to Python3:

Python3 does not tolerate mixed tabs and spaces. Convert tabs in all files to 8 spaces.
Use User:Alvonruff/Python2.7_Futurize to perform a mass conversion from python2.7 syntax to python3 syntax.
The next two items need to be done together, as there is no mysql-connector-python for python2:
- Update to the official MySQL User:Alvonruff/mysql.connector. There is no python3 support for MySQLdb, which is our current connector. Moving to a new connector is a prerequisite.
- Update to python3. This leverages the futurize work, by removing the "from __future__" lines.
Update all character sets. Final procedure still TBD.
- Change the default charset in MySQL
- Repair strings which have URL encodings in MySQL

Details on how to bring up a LAMP stack (on two different OSs), and how to setup https:

User:Alvonruff/ISFDB_Move - Our old hosting service was bought out by a larger hosting service, and they are pushing off our ancient server onto something up to date. We've already been staging such a move at isfdb2.org for a few months, and have most things operational on the new server. The actual move will start sometime after Labor Day.
User:Alvonruff/ISFDB On Ubuntu 20.04
User:Alvonruff/ISFDB2_Notes - Another Fedora Core variant.
User:Alvonruff/HTTPS Notes - Notes on moving to https on isfdb2
User:Alvonruff/Link Tests - Combinations of http/https www/no www links.