Difference between revisions of "User:Alvonruff"

From ISFDB
Jump to navigation Jump to search
 
(23 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
Founder of the ISFDB.  
 
Founder of the ISFDB.  
  
−
== Python3 Notes ==
+
== Large Projects ==
 +
* 2022: Update LAMP stack to latest version (except Python) and enable HTTPS. [https://isfdb.org/wiki/index.php/User:Alvonruff#System_Upgrade_Notes DONE]
 +
* 2023: Update site to Python3. [[User/Alvonruff/Python3_Conversion]]
 +
* 2024: Update charset to UTF-8.
  
−
The primary difficulty with a python3 conversion project is trying to avoid a massive rewrite of the website, and then checkin all those changes with a single big bang integration. That said, the primary function of the scripts is to read data from MySQL, and then organize and print that information to the browser. But the two things that change with python3 is the MySQL connector (which requires a rewrite of all code interfacing with MySQL), and the way print statements work (which requires a rewrite of all code outputting information). So the first goal is to find a way for the ISFDB to exist simultaneously in Python2 and Python3 format. General outline of steps to move to Python3:
+
== Python3 Status Trackers ==
−
 
+
* [[User:Alvonruff/Debugging_Remarks|Debugging Remarks]]
−
# Python3 does not tolerate mixed tabs and spaces. There needs to be a project to convert the tabs in all files to 8 spaces. This change works on either Python2 or Python3
+
* Per-File Status: [[User:Alvonruff/Python3_Files|Python3 File Status]]
−
# Introduce a MySQL connector class, which hides the differences between MySQLdb (which only works on Python2) and mysql.connector (which only works on Python3).
+
* ISFDB2 Status: [[User:Alvonruff/Python3_ISFDB2|ISFDB2 Per-Script Status]]
−
# Convert all MySQL code to use the new connector class. This is a large project in itself, with details listed [[User:Alvonruff/MySQLdb_Conversion|here]].
+
* Mod script test plans and status: [[User:Alvonruff/Python3 ModTests]]
−
# [[User:Alvonruff/Python2.7_Futurize|futurize]] all print statements. This can be done by running futurize, and then keeping only the print() syntax changes. These will run fine under python2.
+
* Formal Tests: [[User:Alvonruff/ISFDB_Tests|Formal ISFDB Test Status]]
−
# Perform the [[User/Alvonruff/2to3|Python3 Conversion]], and follow up on the numerous porting issues.
 
−
# Update all character sets. Final procedure still TBD.
 
−
# Change the default charset in MySQL
 
−
# Repair strings which have URL encodings in MySQL
 
−
 
 
−
* Per-File Status: [[User:Alvonruff/Python3_Files]]
 
−
* ISFDB2 Status: [[User:Alvonruff/Python3_ISFDB2]]
 
  
 
== System Upgrade Notes ==
 
== System Upgrade Notes ==
Line 34: Line 30:
 
* [[User:Alvonruff/Notes on MySQLdb]]
 
* [[User:Alvonruff/Notes on MySQLdb]]
 
* [[User:Alvonruff/Test_Pages]]
 
* [[User:Alvonruff/Test_Pages]]
 +
 +
== Articles Concerning Lee Mandelo ==
 +
* [[User:Alvonruff/A_Post-Mortem_on_the_Lee_Mandelo_Name_Change]]
 +
* [[User:Alvonruff/An_Open_Letter_To_The_SF_Community]]
  
 
== Obituary Sources ==
 
== Obituary Sources ==

Latest revision as of 11:02, 16 September 2023

Founder of the ISFDB.

Large Projects

Python3 Status Trackers

System Upgrade Notes

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

User:Alvonruff/Test Page

Other Loose Notes

Articles Concerning Lee Mandelo

Obituary Sources

Reading List

Retrieved from "https://isfdb.org/wiki/index.php?title=User:Alvonruff&oldid=671004"