pysqlite is not supported on Python 3

[jielab]

Hi, there:

I thought that postGAP is a pretty cool idea.

However, I tried many times but still could not successfully install it.

Please see the message below.

Can you please instruct me how to install? I simply want to try it out.

Best regards,
jie

[dzerbino]

Dear @jielab

This boils down to a Python version issue: PostGAP is still on Python2, while I am guessing your copy of pip points to pip3.

I'm afraid that for the moment we are staying on Python2.

Hope this helps,

Daniel

[jielab]

Dear Daniel:

Thanks. I now installed Pyton2 and set it as the defalt. I now got it successfully installed.

Please see the screenshot below. Somehow it still reports error.

Best regadrs,
Jie

[dzerbino]

Hello @jielab ,

This is because you need to set your Python path environment variable, as explained in the Manual.

In your case, assuming you are using Bash, it would look like:

export PYTHONPATH=$PYTHONPATH:/mnt/d/software_lin/postgap/lib

Hope this helps,

Daniel

[jielab]

Thanks, Daniel!

I did add that to both PYTHONPATH and PATH.
I created an alias of "python" for "python2". However, when I type "which python", it still points to python3.
I don't know if that is the cause of error. If so, how to set it correctly?

Thank!

Jie

[dzerbino]

Hello Jie,

You can circumvent the python alias mapping entirely by calling python2 directly:

python2 POSTGAP.py etc etc

Cheers,

Daniel

[jielab]

Dear Daniel:

Thank you very much! But it still does not work.

Best regards,
Jie

[dzerbino]

Dear Jie,

This is very odd because normally Python paths are case-sensitive. Are you working on a Windows machine?

The solution would be to rename your POSTGAP script, e.g.:

mv POSTGAP.py POSTGAP-script.py

Then call that one:

python2 POSTGAP-script.py etc etc

Hope this helps,

Daniel

[jielab]

Dear Daniel:

Yes, I am running on the Ubuntu Linux coming with Windows 11. I changed the name of the script. But still it does not work.

Best regards,
Jie

[dzerbino]

This is starting to get very odd, what do you get when you do:

ls -l /mnt/d/software_lin/postgap/postgap.py
ls -l /mnt/d/software_lin/postgap1/

Daniel

[jielab]

Dear Daniel:

Here it is. It seems that Windows Ubuntu Linux is case insensitive.

Best regards,
Jie

[dzerbino]

Hello Jie,

I'm confused, in your previous message, I saw:

...
/mnt/d/software_lin# mv postgap/ postgap1
...

How come when you are doing ls now, there still appears /mnt/software_lin/postgap/ ?

Daniel

[jielab]

Sorry for the confusion. I moved postgap1 back to postgap, since renaming the folder to postgap1 does not solve the error.

I now renamed to postgap1 again, and typed the two commands that you showed:

Best regards,
jie

[dzerbino]

I think I found it, could you please delete /mnt/software_lin/postgap1/postgap.pyc and try again?

[jielab]

Dear Daniel;

It still does not work...

[jielab]

I just removed python.pyc and run it again. Please see below. This time, the error message is different.

My student said that this might have to do with the possibility that postgap is installed in some environment, while currently I am in the "(base)" mode. As shown in the following screenshot.

Best regards,
Jie