Difference between revisions of "User:Alvonruff"

From ISFDB
Jump to navigation Jump to search
 
(31 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.
  
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. Convert tabs in all files to 8 spaces.
+
* Per-File Status: [[User:Alvonruff/Python3_Files|Python3 File Status]]
* Use [[User:Alvonruff/Python2.7_Futurize]] to perform a mass conversion from python2.7 syntax to python3 syntax. This allows for locating potential unicode issues. This produces a result suitable for python2.
+
* ISFDB2 Status: [[User:Alvonruff/Python3_ISFDB2|ISFDB2 Per-Script Status]]
* Use 2to3 in a manner the same as futurize. This produces results suitable for python3.
+
* Mod script test plans and status: [[User:Alvonruff/Python3 ModTests]]
* The next two items need to be done together, as there is no mysql-connector-python for python2:
+
* Formal Tests: [[User:Alvonruff/ISFDB_Tests|Formal ISFDB Test Status]]
** 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.
 
* Python3 specific changes:
 
** Use of md5 needs to be replaced with hashlib
 
** Records that return DATETIME fields cannot simply be indexed - they must use built-in datetime methods:
 
*** year = field.year
 
*** month = field.month
 
*** day = field.day
 
** string.replace() must be changed to str.replace()
 
* Update all character sets. Final procedure still TBD.
 
** Change the default charset in MySQL
 
** Repair strings which have URL encodings in MySQL
 
  
 
== System Upgrade Notes ==
 
== System Upgrade Notes ==
Line 39: 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