SQLite Forum

OT: APSW on Python 3.9
Login

OT: APSW on Python 3.9

(1) By Keith Medcalf (kmedcalf) on 2020-12-18 21:45:39 [link] [source]

I had to make the following patch to get APSW to build with the embedded quotes for the amalgamation version on Windows with Python 3.9.1 -- apparently however python is calling the compiler (I use gcc, so it uses the cygwinccompiler.py in distutils) no longer eats unescaped double-quotes:

Index: setup.py
==================================================================
--- setup.py
+++ setup.py
@@ -615,11 +615,11 @@
         # SQLite 3
         # Look for amalgamation in our directory or in sqlite3 subdirectory

         path = findamalgamation()
         if path:
-            if sys.platform == "win32":
+            if sys.platform == "win32" and sys.version_info[:2] < (3, 9):
                 # double quotes get consumed by windows arg processing
                 ext.define_macros.append(('APSW_USE_SQLITE_AMALGAMATION', '\\"' + path + '\\"'))
             else:
                 ext.define_macros.append(('APSW_USE_SQLITE_AMALGAMATION', '"' + path + '"'))
             ext.depends.append(path)

I already posted this to Rogers GitHub tracker.

(2) By ddevienne on 2020-12-21 14:30:20 in reply to 1 [source]

One could then conclude that it's not Windows the culprit,
as the comment suggests, if only the Python version changed :)