wxPython and PyCharm IDE

Hello Mike

Thanks for your replay. This is exactly what I did and now it is working.

I came from the VB6 environment and would like to rebuild applications that I wrote on VB6.

I am still looking for a good easy to use IDE that will allow me to create GUI applications with wxPython and Python. They should read and write excel files and sqlite DB. later maybe accessing sql server and mysql DB.

Any recomandations ?

Thanks and regards

Shlomo

ב Sep 21, 2015 8:53, Steve (Gadget) Barnes כתב:

···

On 20/09/2015 20:21, levshlomo@walla.co.il wrote:

Hello Mike
I am trying to get a working environment on windows 64 bit.
I installed Python 2.7.10 for win64 directly from the Python org site.
the downloaded the wxPython 3.0.xx windows installer and install it.
When I open PyChamp and write import wx I get an error that the DLL can
not be laded.
I went to python shell directly and get the same error.
I uninstalled wxPython 3.0.xx and installed version 2.9.5 but the same
error sow again.
Can you or someone else write a set of versions that really work ?
Python version 2.7.x
wxPython version x.x
I need it to work on a windows 64bit. !

The versions of wxPython that you mention are all currently built for 32
bit python, they all work on Windows 32 & 64 with the 32 bit version of
python so your options are:

a) Switch to 32 bit python 2.7.10 and use the pre-built wxPython - this
is the easy option and has been very well tested.
b) Carry on using 64 bit python 2.7.10 and build wxPython for 64 bits
for yourself - you will need a suitable compiler and this is more work
and has had less testing.
c) Switch to 32 or 64 bit Python 3.5 and build the Phoenix port of
wxPython - you will need a suitable compiler and this is more work, has
had a lot less testing and is a work in progress that does not yet
support all of the wx components.
d) Use virtual environments to try all of the above.

Hope that helps,

Gadget/Steve


You received this message because you are subscribed to a topic in the Google Groups “wxPython-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/wxpython-users/9nC-YcQ4aOk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to wxpython-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Shlomo,

I have used Pycharm for several years and it is a great IDE.

For your database needs, you cannot go past SQLAlchemy. It will do what you have mentioned and more!

For your Excel R/W, it depends if you want to use XLS or XLSX. I have only used XLS, and about two years ago I used http://www.python-excel.org

Good luck!

MarkL

···

On 21 September 2015 at 17:08, שלמה לב levshlomo@walla.co.il wrote:

Hello Mike

Thanks for your replay. This is exactly what I did and now it is working.

I came from the VB6 environment and would like to rebuild applications that I wrote on VB6.

I am still looking for a good easy to use IDE that will allow me to create GUI applications with wxPython and Python. They should read and write excel files and sqlite DB. later maybe accessing sql server and mysql DB.

Any recomandations ?

Thanks and regards

Shlomo

ב Sep 21, 2015 8:53, Steve (Gadget) Barnes כתב:

On 20/09/2015 20:21, levshlomo@walla.co.il wrote:

Hello Mike
I am trying to get a working environment on windows 64 bit.
I installed Python 2.7.10 for win64 directly from the Python org site.
the downloaded the wxPython 3.0.xx windows installer and install it.
When I open PyChamp and write import wx I get an error that the DLL can
not be laded.
I went to python shell directly and get the same error.
I uninstalled wxPython 3.0.xx and installed version 2.9.5 but the same
error sow again.
Can you or someone else write a set of versions that really work ?
Python version 2.7.x
wxPython version x.x
I need it to work on a windows 64bit. !

The versions of wxPython that you mention are all currently built for 32
bit python, they all work on Windows 32 & 64 with the 32 bit version of
python so your options are:

a) Switch to 32 bit python 2.7.10 and use the pre-built wxPython - this
is the easy option and has been very well tested.
b) Carry on using 64 bit python 2.7.10 and build wxPython for 64 bits
for yourself - you will need a suitable compiler and this is more work
and has had less testing.
c) Switch to 32 or 64 bit Python 3.5 and build the Phoenix port of
wxPython - you will need a suitable compiler and this is more work, has
had a lot less testing and is a work in progress that does not yet
support all of the wx components.
d) Use virtual environments to try all of the above.

Hope that helps,

Gadget/Steve


You received this message because you are subscribed to a topic in the Google Groups “wxPython-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/wxpython-users/9nC-YcQ4aOk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to wxpython-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

You received this message because you are subscribed to the Google Groups “wxPython-users” group.

To unsubscribe from this group and stop receiving emails from it, send an email to wxpython-users+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Hi Shlomo,

Hello Mike

Thanks for your replay. This is exactly what I did and now it is working.

I came from the VB6 environment and would like to rebuild applications that I wrote on VB6.

I am still looking for a good easy to use IDE that will allow me to create GUI applications with wxPython and Python.

http://wiki.wxpython.org/wxPythonPit%20Apps

There are a few tools which allow you to generate your UI, e.g. Boa, wxGlade, wxFormBuilder. I used Boa in the past but a couple of years ago I switched to coding things by hand using the wx.lib.sized_controls extensively.

They should read and write excel files and sqlite DB. later maybe accessing sql server and mysql DB.

As Mark suggested I would say SQLAlchemy is the way to go. With it you can write applications DB independent, e.g. I use for my shareware Firebird SQL and am in the process to change the code so one could use either Firebird SQL or Postgresql, this is mostly handled transparently by SA. I also use triggers and stored procedures but that is a bit more involved as the DB's do not have a standard for these things.

Werner

···

On 9/21/2015 9:08, שלמה לב wrote: