eGenix Software user-discussion (developers of the mx modules for python)

eGenix Team: M.-A. Lemburg | 7 May 2013 10:00

ANN: eGenix mxODBC Zope/Plone Database Adapter 2.1.2

________________________________________________________________________

ANNOUNCEMENT

                  mxODBC Zope/Plone Database Adapter

                            Version 2.1.2

                     for Zope and the Plone CMS

                Available for Plone 4.0, 4.1 and 4.2,
                        Zope 2.12 and 2.13, on
        Windows, Linux, Mac OS X, FreeBSD and other platforms

This announcement is also available on our web-site for online reading:
http://www.egenix.com/company/news/eGenix-mxODBC-Zope-DA-2.1.2-GA.html

________________________________________________________________________

INTRODUCTION

The eGenix mxODBC Zope DA allows you to easily connect your Zope or
Plone CMS installation to just about any database backend on the
market today, giving you the reliability of the commercially supported
eGenix product mxODBC and the flexibility of the ODBC standard as
middle-tier architecture.

The mxODBC Zope Database Adapter is highly portable, just like Zope
itself and provides a high performance interface to all your ODBC data
sources, using a single well-supported interface on Windows, Linux,

(Continue reading)

headers

eGenix Team: M.-A. Lemburg | 6 May 2013 10:00

ANN: eGenix mxODBC 3.2.3 - Python ODBC Database Interface

________________________________________________________________________

ANNOUNCING

                         eGenix.com mxODBC

                   Python ODBC Database Interface

                           Version 3.2.3

    mxODBC is our commercially supported Python extension providing
         ODBC database connectivity to Python applications
            on Windows, Mac OS X, Unix and BSD platforms

This announcement is also available on our web-site for online reading:
http://www.egenix.com/company/news/eGenix-mxODBC-3.2.3-GA.html

________________________________________________________________________

INTRODUCTION

mxODBC provides an easy-to-use, high-performance, reliable and robust
Python interface to ODBC compatible databases such as MS SQL Server,
MS Access, Oracle Database, IBM DB2 and Informix , Sybase ASE and
Sybase Anywhere, MySQL, PostgreSQL, SAP MaxDB and many more:

    http://www.egenix.com/products/python/mxODBC/

The "eGenix mxODBC - Python ODBC Database Interface" product is a
commercial extension to our open-source eGenix mx Base Distribution:

(Continue reading)

headers

M.-A. Lemburg | 2 May 2013 10:58

mxODBC and mxODBC Zope DA with Python 2.7.4

Dear Users,

we have noticed that the problem which causes a segfault at
Python 2.7.4 finalization time when using mxURL from egenix-mx-base
also affects mxODBC and the Zope DA which uses mxODBC.

The regression was introduced in Python 2.7.4 and will be fixed
again in 2.7.5 (see http://bugs.python.org/issue17703).
Python 2.7.3 and all other earlier Python versions do not have
this problem.

We will issue patch level releases for both products next
week to address the issue by adding a work-around.

Please note that the segfault does not have any effect on the
application that is running in Python. The problem occurs in the
cleanup routine used by mxODBC during interpreter finalization,
i.e. after most of the Python has already been shut down.

Regards,
--

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, May 02 2013)
>>> Python Projects, Consulting and Support ...   http://www.egenix.com/
>>> mxODBC.Zope/Plone.Database.Adapter ...       http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2013-04-30: Released eGenix PyRun 1.2.0 ...       http://egenix.com/go44

(Continue reading)

headers

eGenix Team: M.-A. Lemburg | 30 Apr 2013 10:41

ANN: eGenix PyRun - One file Python Runtime 1.2.0

________________________________________________________________________

ANNOUNCING

                 eGenix PyRun - One file Python Runtime

                            Version 1.2.0

         An easy-to-use single file relocatable Python run-time -
           available for Windows, Mac OS X and Unix platforms

This announcement is also available on our web-site for online reading:
http://www.egenix.com/company/news/eGenix-PyRun-1.2.0.html

________________________________________________________________________

INTRODUCTION

Our new eGenix PyRun combines a Python interpreter with an almost
complete Python standard library into a single easy-to-use executable,
that does not require a system wide installation and is fully
relocatable.

eGenix PyRun's executable only needs 11MB, but still supports most
Python application and scripts - and it can be further compressed to
just 3-4MB using upx.

Compared to a regular Python installation of typically 100MB on disk,
this makes eGenix PyRun ideal for applications and scripts that need
to be distributed to many target machines, client installations or

(Continue reading)

headers

eGenix Team: M.-A. Lemburg | 17 Apr 2013 09:30

ANN: eGenix mx Base Distribution 3.2.6 (mxDateTime, mxTextTools, etc.)

________________________________________________________________________

ANNOUNCING

                   eGenix.com mx Base Distribution

             mxDateTime, mxTextTools, mxProxy, mxURL, mxUID,
                  mxBeeBase, mxStack, mxQueue, mxTools

                            Version 3.2.6

                Open Source Python extensions providing
                     important and useful services
                        for Python programmers.

This announcement is also available on our web-site for online reading:
http://www.egenix.com/company/news/eGenix-mx-Base-Distribution-3.2.6-GA.html

________________________________________________________________________

ABOUT

The eGenix.com mx Base Distribution for Python is a collection of
professional quality software tools which enhance Python's usability
in many important areas such as fast text searching, date/time
processing and high speed data types.

The tools have a proven record of being portable across many Unix and
Windows platforms. You can write applications which use the tools on
Windows and then run them on Unix platforms without change due to the

(Continue reading)

headers

Peter Loje | 9 Apr 2013 13:51

Python 2.7.4 generates SIGSEGV when cleaning up mx.URL

On two separate systems (i686 running Debian GNU/Linux 6.0.7 and x86_64 running Ubuntu 12.04.2 LTS) I'm getting segmentation fault when Python 2.7.4 exits after having loaded mx.URL.

I have compiled Python and mx.URL from sources. The latter using:

$ md5sum egenix-mx-base-3.2.5.tar.gz

2f982afa5ac70691965e9990df138186 egenix-mx-base-3.2.5.tar.gz

In the file egenix-mx-base-3.2.5/mx/URL/mxURL/mxURL.c the segmentation fault is generated in line 2789:

2776 void mxURLModule_Cleanup(void)

....

2789 Py_XDECREF(mxURL_MIMEDict);

GDB backtrace provided below.

BTW I wonder why the module reports version 3.2.4?

$ find egenix-mx-base-3.2.5 -type f | xargs egrep 'MX.*_VERSION "'

egenix-mx-base-3.2.5/mx/BeeBase/mxBeeBase/mxBeeBase.c:#define MXBEEBASE_VERSION "3.2.4"

egenix-mx-base-3.2.5/mx/DateTime/mxDateTime/mxDateTime.c:#define MXDATETIME_VERSION "3.2.4"

egenix-mx-base-3.2.5/mx/Proxy/mxProxy/mxProxy.c:#define MXPROXY_VERSION "3.2.4"

egenix-mx-base-3.2.5/mx/Queue/mxQueue/mxQueue.c:#define MXQUEUE_VERSION "3.2.4"

egenix-mx-base-3.2.5/mx/Stack/mxStack/mxStack.c:#define MXSTACK_VERSION "3.2.4"

egenix-mx-base-3.2.5/mx/TextTools/mxTextTools/mxTextTools.c:#define MXTEXTTOOLS_VERSION "3.2.4"

egenix-mx-base-3.2.5/mx/Tools/mxTools/mxTools.c:#define MXTOOLS_VERSION "3.2.4"

egenix-mx-base-3.2.5/mx/UID/mxUID/mxUID.c:#define MXUID_VERSION "3.2.4"

egenix-mx-base-3.2.5/mx/URL/mxURL/mxURL.c:#define MXURL_VERSION "3.2.4"

Did you forget to bump up the patch version from 4 to 5 when releasing mx-base-3.2.5?

Best regards

Peter Loje

$ gdb /usr/local/bin/python2.7

GNU gdb (GDB) 7.0.1-debian

License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>

This is free software: you are free to change and redistribute it.

There is NO WARRANTY, to the extent permitted by law. Type "show copying"

and "show warranty" for details.

This GDB was configured as "i486-linux-gnu".

For bug reporting instructions, please see:

<http://www.gnu.org/software/gdb/bugs/>...

Reading symbols from /usr/local/bin/python2.7...done.

(gdb) r

Starting program: /usr/local/bin/python2.7

[Thread debugging using libthread_db enabled]

Python 2.7.4 (default, Apr 8 2013, 15:51:19)

[GCC 4.4.5] on linux2

Type "help", "copyright", "credits" or "license" for more information.

>>> import mx.URL

>>> mx.URL.__version__

'3.2.4'

>>> import sys

>>> sys.exit()

Program received signal SIGSEGV, Segmentation fault.

0x08091201 in dict_dealloc (mp=0xb7b2813c) at Objects/dictobject.c:1005

1005 Py_TRASHCAN_SAFE_BEGIN(mp)

(gdb) bt

#0 0x08091201 in dict_dealloc (mp=0xb7b2813c) at Objects/dictobject.c:1005

#1 0xb7875928 in mxURLModule_Cleanup () at mx/URL/mxURL/mxURL.c:2789

#2 0x0810553f in call_ll_exitfuncs () at Python/pythonrun.c:1763

#3 Py_Finalize () at Python/pythonrun.c:554

#4 0x08104bac in Py_Exit () at Python/pythonrun.c:1772

#5 handle_system_exit () at Python/pythonrun.c:1146

#6 0x0810517d in PyErr_PrintEx (set_sys_last_vars=<value optimized out>) at Python/pythonrun.c:1156

#7 0x081058dd in PyRun_InteractiveOneFlags (fp=0xb7f8b420, filename=0x815f9c0 "<stdin>", flags=0xbffffc4c) at Python/pythonrun.c:855

#8 0x08105a68 in PyRun_InteractiveLoopFlags (fp=0xb7f8b420, filename=0x815f9c0 "<stdin>", flags=0xbffffc4c) at Python/pythonrun.c:772

#9 0x081062f2 in PyRun_AnyFileExFlags (fp=0xb7f8b420, filename=0x815f9c0 "<stdin>", closeit=0, flags=0xbffffc4c) at Python/pythonrun.c:741

#10 0x0805bb59 in Py_Main (argc=1, argv=0xbffffd34) at Modules/main.c:640

#11 0x0805abeb in main (argc=1, argv=0xbffffd34) at ./Modules/python.c:23

(gdb)


_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users

headers

eGenix Team: M.-A. Lemburg | 9 Apr 2013 10:25

ANN: eGenix mxODBC Connect - Python ODBC Database Interface 2.0.3

________________________________________________________________________

ANNOUNCING
                      eGenix.com mxODBC Connect

                    Python ODBC Database Interface

                            Version 2.0.3

 mxODBC Connect is our commercially supported client-server product for
       connecting Python applications to relational databases
                 in a truly platform independent way.

This announcement is also available on our web-site for online reading:
http://www.egenix.com/company/news/eGenix-mxODBC-Connect-2.0.3-GA.html

________________________________________________________________________

INTRODUCTION

The mxODBC Connect Database Interface for Python allows users to
easily connect Python applications to all major databases on the
market today in a highly portable, convenient and secure way.

Python Database Connectivity the Easy Way
-----------------------------------------

Unlike our mxODBC Python extension, mxODBC Connect is designed as
client-server application, so you no longer need to find production
quality ODBC drivers for all the platforms you target with your Python
application.

Instead you use an easy to install royalty-free Python client library
which connects directly to the mxODBC Connect database server over the
network.

This makes mxODBC Connect a great basis for writing cross-platform
multi-tier database applications and utilities in Python, especially
if you run applications that need to communicate with databases such
as MS SQL Server and MS Access, Oracle Database, IBM DB2 and Informix,
Sybase ASE and Sybase Anywhere, MySQL, PostgreSQL, SAP MaxDB and many
more, that run on Windows or Linux machines.

Ideal for Database Driven Client Applications
---------------------------------------------

By removing the need to install and configure ODBC drivers on the
client side and dealing with complicated network setups for each set
of drivers, mxODBC Connect greatly simplifies deployment of database
driven client applications, while at the same time making the network
communication between client and database server more efficient and
more secure.

For more information, please have a look at the mxODBC Connect product
page, in particular, the full list of available features.

For more information, please see the product page:

    http://www.egenix.com/products/python/mxODBCConnect/

________________________________________________________________________

NEWS

The 2.0.3 release of mxODBC Connect includes the following
enhancements and fixes:

Security Enhancements
---------------------

 * Upgraded client and server to the most recent eGenix
   pyOpenSSL 0.13.1.1.0.1.5.

Server Enhancements
-------------------

 * Updated the server to use mxODBC 3.2.2 for database connectivity.

Client Enhancements
-------------------

 * Added support for the new .cursortype attribute in mxODBC 3.2.2
   which is available on both connections and cursors to adjust the
   used ODBC cursor type.

Performance Enhancements
------------------------

 * MS SQL Server performance can now be much enhanced, and increased
   to levels beyond that of mxODBC Connect 2.0.2 and previous
   releases, by adjusting the default cursor type to forward-only
   cursors instead of static cursors:

    # Connect to the remote database
    from mx.ODBCConnect.Client import ServerSession
    session = ServerSession(...)
    ODBC = session.open()
    connection = ODBC.DriverConnect(...)
    # Use the faster forward-only cursors
    connection.cursortype = ODBC.SQL.CURSOR_FORWARD_ONLY
    # Cursors created on this connection will then default
    # to forward only cursors
    cursor = connection.cursor()

 * The performance increase compared to mxODBC Connect 2.0.2 is
   enormous: from 2-3x faster executes/fetches for average queries, up
   to 300x faster for simple cases.

   In mxODBC Connect 2.1, we will switch to using forward-only cursors
   per default for all database backends.

 * IBM DB2 can benefit from the same performance enhancements using
   forward-only cursors.

   The effect is a lot smaller compared to MS SQL Server, but still
   noticeable: up to 2x faster executes/fetches with forward-only
   cursors, compared to mxODBC Connect 2.0.2.

 * Added documentation to explain the different cursor types,
   compatibility with different database backends and effects on
   performance to the mxODBC documentation.

New License Structure
---------------------

Due to popular demand, we have added an unlimited connections server
license, so now you can choose between:

 * the entry-level 20-connections server license,
 * an average use 50-connections server license.
 * and the unlimited connections server license for our
   high-end users.

For the full set of changes, please check the mxODBC Connect change
log.

    http://www.egenix.com/products/python/mxODBCConnect/changelog.html

mxODBC Connect 2.0 Highlights
-----------------------------

mxODBC Connect 2.0 was released on 2012-08-20. These are the most
important highlights:

 * mxODBC Connect Server now uses mxODBC 3.2 internally and makes its
   API available in the mxODBC Connect Client. This is a major step
   forward from the mxODBC 3.0 version used in mxODBC Connect Server
   1.0.

 * We've added native Windows x64 builds.

 * mxODBC Connect Client now integrates directly with gevent, allowing
   client applications to run asynchronous tasks while performing
   remote database queries.

Please see the release announcement for full details:
http://www.egenix.com/company/news/eGenix-mxODBC-Connect-2.0.0-GA.html

________________________________________________________________________

UPGRADING

You are encouraged to upgrade to this latest mxODBC Connect release.
When upgrading, please always upgrade both the server and the client
installations to the same version - even for patch level releases.

Customers who have purchased mxODBC Connect 2.0 licenses can continue
to use their licenses with this patch level release.

Customers who have purchased mxODBC Connect 1.x licenses can request
20% discount coupons for upgrade purchases. Please contact the
eGenix.com Sales Team (sales@...) with your existing license
serials for details.

Users of our stand-alone mxODBC product will have to purchase new
licenses from our online shop in order to use mxODBC Connect.

You can request 30-day evaluation licenses by visiting our web-site
or writing to sales@..., stating your name (or the name of the
company) and the number of eval licenses that you need.

    http://www.egenix.com/products/python/mxODBCConnect/#Evaluation

________________________________________________________________________

DOWNLOADS

The download archives as well as instructions for installation and
configuration of the product can be found on the product page:

    http://www.egenix.com/products/python/mxODBCConnect/

If you want to try the package, jump straight to the download
instructions:

    https://cms.egenix.com/products/python/mxODBCConnect/#Download

Fully functional evaluation licenses for the mxODBC Connect Server are
available free of charge:

    http://www.egenix.com/products/python/mxODBCConnect/#Evaluation

mxODBC Connect Client is always free of charge.

_______________________________________________________________________

SUPPORT

Commercial support for this product is available from eGenix.com.

Please see

    http://www.egenix.com/services/support/

for details about our support offerings.

_______________________________________________________________________

INFORMATION

About Python (http://www.python.org/):

    Python is an object-oriented Open Source programming language
    which runs on all modern platforms. By integrating ease-of-use,
    clarity in coding, enterprise application connectivity and rapid
    application design, Python establishes an ideal programming
    platform for today's IT challenges.

About eGenix (http://www.egenix.com/):

    eGenix is a software project, consulting and product company
    focusing on expert project services and professional quality
    products for companies, Python users and developers.

Enjoy,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Apr 09 2013)
>>> Python Projects, Consulting and Support ...   http://www.egenix.com/
>>> mxODBC.Zope/Plone.Database.Adapter ...       http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2013-04-02: Released mxODBC Zope DA 2.1.1 ...     http://egenix.com/go41
2013-04-10: Python Meeting Duesseldorf ...                      tomorrow

::::: Try our mxODBC.Connect Python Database Interface for free ! ::::::

   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611
               http://www.egenix.com/company/contact/

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users

headers

eGenix Team: M.-A. Lemburg | 2 Apr 2013 10:15

ANN: eGenix mxODBC Zope/Plone Database Adapter 2.1.1

________________________________________________________________________

ANNOUNCEMENT

                  mxODBC Zope/Plone Database Adapter

                            Version 2.1.1

                     for Zope and the Plone CMS

                Available for Plone 4.0, 4.1 and 4.2,
                        Zope 2.12 and 2.13, on
        Windows, Linux, Mac OS X, FreeBSD and other platforms

This announcement is also available on our web-site for online reading:
http://www.egenix.com/company/news/eGenix-mxODBC-Zope-DA-2.1.1-GA.html

________________________________________________________________________

INTRODUCTION

The eGenix mxODBC Zope DA allows you to easily connect your Zope or
Plone CMS installation to just about any database backend on the
market today, giving you the reliability of the commercially supported
eGenix product mxODBC and the flexibility of the ODBC standard as
middle-tier architecture.

The mxODBC Zope Database Adapter is highly portable, just like Zope
itself and provides a high performance interface to all your ODBC data
sources, using a single well-supported interface on Windows, Linux,
Mac OS X, FreeBSD and other platforms.

This makes it ideal for deployment in ZEO Clusters and Zope hosting
environments where stability and high performance are a top priority,
establishing an excellent basis and scalable solution for your Plone
CMS.

Product page:

    http://www.egenix.com/products/zope/mxODBCZopeDA/

________________________________________________________________________

NEWS

We are pleased to announce the new version 2.1.1 of our mxODBC
Zope/Plone Database Adapter product.

Feature Enhancements
--------------------

 * Added a new connection property "ODBC cursor type" which allows
   easily adjusting the ODBC cursor type to be used for mxODBC Zope DA
   connection objects.

   This new property allows enhancing the performance of the adapter
   significantly, when using it with MS SQL Server or IBM DB2 database
   backends. Please see below for details.

Driver Compatibility
--------------------

 * MS SQL Server performance can now be much enhanced, and increased
   to levels beyond that of previous mxODBC Zope DA releases, by
   adjusting the connection ODBC cursor type to "Forward only
   cursors".

   The performance increase compared to mxODBC Zope DA 2.1.0 is
   enormous: from 2-3x faster executes/fetches for average queries, up
   to 300x faster for simple cases.

   In mxODBC Zope DA 2.2, we will switch to using "Forward only
   cursors" per default for all database backends.

 * IBM DB2 can benefit from the same performance enhancements using
   "Forward only cursors".

   The effect is a lot smaller, but still noticeable: up to 2x faster
   executes/fetches with forward-only cursors, compared to mxODBC Zope
   DA 2.1.0.

 * Added documentation to explain the different cursor types,
   compatibility with different database backends and effects on
   performance.

Fixes
-----

 * Fixed the installation instructions to be more generic and easily
   adaptable to Plone and Zope installations on both Windows and Unix
   platforms.

For the full set of changes please check the change log:

    http://www.egenix.com/products/zope/mxODBCZopeDA/changelog.html

________________________________________________________________________

FEATURES

Version 2.1.0 of our mxODBC Zope/Plone Database Adapter product
was released on 2012-09-18. Please see the full
announcement for highlights of the 2.1 release:

    http://www.egenix.com/company/news/eGenix-mxODBC-Zope-DA-2.1.0-GA.html

For the full set of features mxODBC has to offer, please see:

    http://www.egenix.com/products/zope/mxODBCZopeDA/#Features

________________________________________________________________________

UPGRADING

Users are encouraged to upgrade to this latest mxODBC Zope/Plone DA
release to benefit from the new features and updated ODBC driver
support.

We have taken special care not to introduce backwards incompatible
changes, making the upgrade experience as smooth as possible.

As always, patch level upgrades (e.g. from 2.1.0 to 2.1.1) are free of
charge. The licenses you have purchased for 2.1 will continue to work
with this new release.

For major and minor upgrade purchases, we will give out 20% discount
coupons going from mxODBC Zope DA 1.x to 2.1 and 50% coupons for
upgrades from mxODBC 2.x to 2.1. After upgrade, use of the original
license from which you upgraded is no longer permitted.

Please contact the eGenix.com Sales Team with your existing license
serials for details for an upgrade discount coupon.

If you want to try the new release before purchace, you can request
30-day evaluation licenses by visiting our web-site or writing to
sales@..., stating your name (or the name of the company) and
the number of eval licenses that you need.

_______________________________________________________________________

SUPPORT

Commercial support for this product is available from eGenix.com.
Please see

    http://www.egenix.com/services/support/

for details about our support offerings.

________________________________________________________________________

MORE INFORMATION

For more information on the mxODBC Zope Database Adapter, licensing
and download instructions, please visit our web-site:

    http://www.egenix.com/products/zope/mxODBCZopeDA/

You can buy mxODBC Zope DA licenses online from the eGenix.com shop at:

    http://shop.egenix.com/

About Python (http://www.python.org/):

    Python is an object-oriented Open Source programming language
    which runs on all modern platforms. By integrating ease-of-use,
    clarity in coding, enterprise application connectivity and rapid
    application design, Python establishes an ideal programming
    platform for today's IT challenges.

About eGenix (http://www.egenix.com/):

    eGenix is a software project, consulting and product company
    focusing on expert project services and professional quality
    products for companies, Python users and developers.

Enjoy,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Apr 02 2013)
>>> Python Projects, Consulting and Support ...   http://www.egenix.com/
>>> mxODBC.Zope/Plone.Database.Adapter ...       http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2013-03-25: Released mxODBC 3.2.2 ...             http://egenix.com/go40
2013-04-10: Python Meeting Duesseldorf ...                  8 days to go

::::: Try our mxODBC.Connect Python Database Interface for free ! ::::::

   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611
               http://www.egenix.com/company/contact/

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users

headers

eGenix Team: M.-A. Lemburg | 25 Mar 2013 11:10

ANN: eGenix mxODBC 3.2.2 - Python ODBC Database Interface

________________________________________________________________________

ANNOUNCING

                         eGenix.com mxODBC

                   Python ODBC Database Interface

                           Version 3.2.2

    mxODBC is our commercially supported Python extension providing
         ODBC database connectivity to Python applications
            on Windows, Mac OS X, Unix and BSD platforms

This announcement is also available on our web-site for online reading:
http://www.egenix.com/company/news/eGenix-mxODBC-3.2.2-GA.html

________________________________________________________________________

INTRODUCTION

mxODBC provides an easy-to-use, high-performance, reliable and robust
Python interface to ODBC compatible databases such as MS SQL Server,
MS Access, Oracle Database, IBM DB2 and Informix , Sybase ASE and
Sybase Anywhere, MySQL, PostgreSQL, SAP MaxDB and many more:

    http://www.egenix.com/products/python/mxODBC/

The "eGenix mxODBC - Python ODBC Database Interface" product is a
commercial extension to our open-source eGenix mx Base Distribution:

    http://www.egenix.com/products/python/mxBase/

________________________________________________________________________

NEWS

The 3.2.2 release of our mxODBC is the latest patch level release of
our popular Python ODBC Interface. In this release, we've included the
following the following enhancements and fixes:

Feature Enhancements
--------------------

 * Backported the new .cursortype attribute from the upcoming
   mxODBC 3.3.

   The new attribute allows easily adjusting and inspecting the ODBC
   cursor type to be used for an mxODBC cursor object.

   The reason for this unusual backport and inclusion in a patch level
   release is that we found a serious performance issue with MS SQL
   Server when using it with mxODBC 3.2 (see below). This needed to be
   addressed immediately.

Driver Compatibility
--------------------

 * MS SQL Server performance can now be much enhanced, and increased
   to levels beyond that of mxODBC 3.1 and previous releases, by
   adjusting the default cursor type to forward-only cursors:

    connection = mx.ODBC.Windows.DriverConnect(...)
    connection.cursortype = mx.ODBC.Windows.SQL.CURSOR_FORWARD_ONLY
    # Cursors created on this connection will then default to forward
    # only cursors, instead of the mxODBC 3.2 default for SQL Server
    # of using static cursors
    cursor = connection.cursor()

   The performance increase compared to mxODBC 3.2.1 is enormous:
   from 2-3x faster executes/fetches for average queries, up to 300x
   faster for simple cases.

   In mxODBC 3.3, we will switch to using forward-only cursors per
   default for all database backends.

 * IBM DB2 can benefit from the same performance enhancements using
   forward-only cursors.

   The effect is a lot smaller, but still noticeable: up to 2x faster
   executes/fetches with forward-only cursors, compared to mxODBC
   3.2.1.

 * Added documentation to explain the different cursor types,
   compatibility with different database backends and effects on
   performance.

Fixes
-----

 * Fixed a problem with using mxODBC cursors as context managers:
   these worked fine in Python 2.6, but had stopped working in Python
   2.7 due to changes in the Python internals.

For the full set of changes please check the mxODBC change log:

    http://www.egenix.com/products/python/mxODBC/changelog.html

________________________________________________________________________

FEATURES

mxODBC 3.2 was released on 2012-08-28. Please see the full
announcement for highlights of the 3.2 release:

    http://www.egenix.com/company/news/eGenix-mxODBC-3.2.2-GA.html

For the full set of features mxODBC has to offer, please see:

    http://www.egenix.com/products/python/mxODBC/#Features

________________________________________________________________________

EDITIONS

mxODBC is available in these three editions:

 * The low-cost Standard Edition which provides data connectivity to a
   single database type, e.g. just MS SQL Server.

 * The Professional Edition, which gives full access to all mxODBC
   features.

 * The Product Development Edition, which allows including mxODBC in
   applications you develop.

Compared to mxODBC 3.0, we have simplified our license terms to
clarify the situation on multi-core and virtual machines. In most
cases, you no longer need to purchase more than one license per
processor or virtual machine, scaling down the overall license costs
significantly compared to earlier mxODBC releases.

For a complete overview of the new editions, please see the product page.

    http://www.egenix.com/products/python/mxODBC/#mxODBCEditions

________________________________________________________________________

DOWNLOADS

The download archives and instructions for installing the package can
be found at:

    http://www.egenix.com/products/python/mxODBC/

In order to use the eGenix mxODBC package you will first need to
install the eGenix mx Base package:

    http://www.egenix.com/products/python/mxBase/

________________________________________________________________________

UPGRADING

Users are encouraged to upgrade to this latest mxODBC release to
benefit from the new features and updated ODBC driver support.

We have taken special care, not to introduce backwards incompatible
changes, making the upgrade experience as smooth as possible.

Customers who have purchased mxODBC 3.2 license can continue to use
their licenses with this patch level release.

Customers who have purchased mxODBC 2.x, 3.0 or 3.1 licenses, can
benefit from upgrade discounts. We will give out 20% discount coupons
going from mxODBC 2.x to 3.2 and 50% coupons for upgrades from mxODBC
3.x to 3.2. After upgrade, use of the original license from which you
upgraded is no longer permitted.

Please contact the eGenix.com Sales Team at sales@... with your
existing license serials for details for an upgrade discount coupon.

If you want to try the new release before purchace, you can request
30-day evaluation licenses by visiting our web-site

    http://www.egenix.com/products/python/mxODBC/#Evaluation

or by writing to sales@..., stating your name (or the name of
the company) and the number of eval licenses that you need.

_______________________________________________________________________

SUPPORT

Commercial support for this product is available from eGenix.com.
Please see

    http://www.egenix.com/services/support/

for details about our support offerings.

_______________________________________________________________________

INFORMATION

About Python (http://www.python.org/):

    Python is an object-oriented Open Source programming language
    which runs on all modern platforms. By integrating ease-of-use,
    clarity in coding, enterprise application connectivity and rapid
    application design, Python establishes an ideal programming
    platform for today's IT challenges.

About eGenix (http://www.egenix.com/):

    eGenix is a software project, consulting and product company
    focusing on expert services and professional quality products for
    companies, Python users and developers.

Enjoy,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Mar 25 2013)
>>> Python Projects, Consulting and Support ...   http://www.egenix.com/
>>> mxODBC.Zope/Plone.Database.Adapter ...       http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2013-03-13: Released eGenix pyOpenSSL 0.13 ...    http://egenix.com/go39

::::: Try our mxODBC.Connect Python Database Interface for free ! ::::::

   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611
               http://www.egenix.com/company/contact/

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users

headers

eGenix Team: M.-A. Lemburg | 13 Mar 2013 19:32

ANN: eGenix pyOpenSSL Distribution 0.13.1.1.0.1.5

________________________________________________________________________
ANNOUNCING

                   eGenix.com pyOpenSSL Distribution

                         Version 0.13.1.1.0.1.5

             An easy-to-install and easy-to-use distribution
             of the pyOpenSSL Python interface for OpenSSL -
            available for Windows, Mac OS X and Unix platforms

This announcement is also available on our web-site for online reading:
http://www.egenix.com/company/news/eGenix-pyOpenSSL-Distribution-0.13.1.1.0.1.5.html

________________________________________________________________________
INTRODUCTION

The eGenix.com pyOpenSSL Distribution includes everything you need to
get started with SSL in Python.

It comes with an easy-to-use installer that includes the most recent
OpenSSL library versions in pre-compiled form, making your application
independent of OS provided OpenSSL libraries:

    http://www.egenix.com/products/python/pyOpenSSL/

pyOpenSSL is an open-source Python add-on that allows writing SSL/TLS-
aware network applications as well as certificate management tools:

    https://launchpad.net/pyopenssl/

OpenSSL is an open-source implementation of the SSL/TLS protocol:

    http://www.openssl.org/

________________________________________________________________________
NEWS

This new release of the eGenix.com pyOpenSSL Distribution updates the
included OpenSSL version to 1.0.1c.

New in OpenSSL 1.0.1e since our last release for OpenSSL 1.0.1c
---------------------------------------------------------------

OpenSSL 1.0.1e includes several important fixes:

 * OpenSSL security advisory: http://www.openssl.org/news/secadv_20130204.txt
   - also known as "Lucky 13"
   http://www.h-online.com/security/news/item/TLS-tripped-up-by-Lucky-13-1798423.html

 * OpenSSL security advisory: http://www.openssl.org/news/secadv_20130205.txt

 * corrected fix for CVE-2013-0169 in 1.0.1e:
   http://www.mail-archive.com/openssl-users-MCmKBN63+BlAfugRpC6u6w <at> public.gmane.org/msg70100.html

 * fixes the SSL3_GET_RECORD:wrong version number problem:

http://openssl.6102.n7.nabble.com/error-1408F10B-SSL-routines-SSL3-GET-RECORD-wrong-version-number-td22477.html

as well as several other new features compared to 1.0.0:

    http://lwn.net/Articles/486426/

fixes vulnerabilities relative to 1.0.1c:

    http://openssl.org/news/vulnerabilities.html

and includes a number of stability enhancements as well as extra
protection against attacks:

    http://openssl.org/news/changelog.html

New in the eGenix pyOpenSSL Distribution
----------------------------------------

 * Changed the package version scheme to be PEP 386 compatible. The
   new scheme no longer contains underscores or patch level letters.

 * Added a CA root certificate bundle file ca-bundle.crt, which is
   created from the current Mozilla root CA certificate list.

   This allows verifying server certificates without having to rely on the
   system root CA certificate list. The bundle file will be updated with
   each new release of eGenix pyOpenSSL. We also make the file available
   as separate download. Please see the product page for details.

 * Added pyOpenSSL examples/ directory to the source distribution.

 * Added a new OpenSSL.ca_bundle module which provides easy to use
   access to the embedded ca-bundle.crt file.

 * Added new example https_client.py to the examples/ directory, which
   demonstrates setting up an SSL connection and using the new
   OpenSSL.ca_bundle module.

 * Windows x64 builds now have assembler code turned back on again,
   after a problem with OpenSSL 1.0.1c.

As always, we provide binaries that include both pyOpenSSL and the
necessary OpenSSL libraries for all supported platforms:
Windows x86 and x64, Linux x86 and x64, Mac OS X PPC, x86 and x64.

We've also added egg-file distribution versions of our eGenix.com
pyOpenSSL Distribution for Windows, Linux and Mac OS X to the
available download options. These make setups using e.g. zc.buildout
and other egg-file based installers a lot easier.

________________________________________________________________________
DOWNLOADS

The download archives and instructions for installing the package can
be found at:

    http://www.egenix.com/products/python/pyOpenSSL/

________________________________________________________________________
UPGRADING

Before installing this version of pyOpenSSL, please make sure that
you uninstall any previously installed pyOpenSSL version. Otherwise,
you could end up not using the included OpenSSL libs.

_______________________________________________________________________
SUPPORT

Commercial support for these packages is available from eGenix.com.
Please see

    http://www.egenix.com/services/support/

for details about our support offerings.

________________________________________________________________________
MORE INFORMATION

For more information about the eGenix pyOpenSSL Distribution, licensing
and download instructions, please visit our web-site or write to
sales@...

Enjoy,
-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Mar 13 2013)
>>> Python Projects, Consulting and Support ...   http://www.egenix.com/
>>> mxODBC.Zope/Plone.Database.Adapter ...       http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::::: Try our mxODBC.Connect Python Database Interface for free ! ::::::

   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611
               http://www.egenix.com/company/contact/

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users

headers

Paul A. Giannaros | 5 Mar 2013 19:45

pyrunning zip files

CPython >= 2.6 lets you run a script __main__.py within a zip archive
foo.zip with:

    $ python foo.zip

This doesn't work with pyrun:

    $ pyrun foo.zip
    ...
    SyntaxError: Non-ASCII character '\xf1' in file foo.zip on line 2,
but no encoding declared; see http://www.python.org/peps/pep-0263.html
for details

It's a useful feature (it's how we deploy code in the company that I
work). Would you please consider adding it?

Thanks, Paul

_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
https://www.egenix.com/mailman/listinfo/egenix-users

3	May 2013
9	April 2013
6	March 2013
6	February 2013
2	December 2012
6	November 2012
2	October 2012
4	September 2012
28	August 2012
1	July 2012
3	June 2012
3	May 2012
10	April 2012
4	March 2012
6	February 2012
14	January 2012
13	December 2011
2	November 2011
2	September 2011
10	August 2011
3	July 2011
1	June 2011
13	May 2011
3	April 2011
3	March 2011
3	February 2011
8	January 2011
4	December 2010
3	November 2010
3	September 2010
9	August 2010
1	July 2010
12	June 2010
7	May 2010
30	April 2010
10	March 2010
16	February 2010
7	January 2010
8	December 2009
8	November 2009
7	September 2009
16	August 2009
19	July 2009
13	June 2009
10	May 2009
12	April 2009
20	March 2009
26	February 2009
22	January 2009
13	December 2008
12	November 2008
5	October 2008
26	September 2008
1	August 2008
11	July 2008
15	June 2008
36	May 2008
12	April 2008
4	February 2008
4	January 2008
21	November 2007
39	October 2007
9	September 2007
48	August 2007
13	July 2007
5	June 2007
16	May 2007
14	April 2007
27	March 2007
8	February 2007
21	January 2007
13	December 2006
5	November 2006
18	October 2006
7	September 2006
4	August 2006
13	July 2006
11	June 2006
5	May 2006
8	April 2006
1	March 2006
2	February 2006
17	January 2006
17	December 2005
13	November 2005
21	October 2005
12	September 2005
17	August 2005
2	July 2005
10	June 2005
21	May 2005
9	April 2005
24	March 2005
34	February 2005
46	January 2005
17	December 2004
21	November 2004
59	October 2004
6	September 2004
13	August 2004
11	July 2004
18	June 2004
22	May 2004
23	April 2004
22	March 2004
14	February 2004
23	January 2004
5	December 2003
11	November 2003
26	October 2003
15	September 2003
22	August 2003
22	July 2003
9	June 2003
8	May 2003
7	April 2003
6	March 2003
7	February 2003
10	January 2003
19	December 2002
9	November 2002
18	October 2002
41	September 2002
28	August 2002
17	July 2002
15	June 2002
4	May 2002
21	April 2002
1	March 2002
8	February 2002
3	January 2002

Mon	Tue	Wed	Thu	Fri	Sat	Sun

		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31