[firebird-python] Firebird for Python driver FDB 1.4.1 released

2014-06-25 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi all, FDB release 1.4.1 is out: http://pypi.python.org/pypi/fdb This release fixes some issues found over last year and adds few enhancements. Check out the chamgelog at http://pythonhosted.org//fdb/changelog.html#version-1-4-1 best regards Pavel Cisar IBPhoenix

Re: [firebird-python] setting connection timeout

2014-07-01 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, Not in FDB, but in firebird.conf, see ConnectionTimeout parameter (default is 180 sec.) best regards Pavel Cisar IBPhoenix Hi, Is there a way to set the timeout on connect() in fdb, and later operations? It seems to take a very long time to timeout if connecting to an unreachable host

Re: [firebird-python] Python 3.4 and FDB - backup

2014-07-09 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, That's unfortunate problem. The API requires byte streams, while os.path.exists requires unicode. The obvious solution is to encode/decode at either place, but the key problem is which encoding we should use? Any ideas? best regards Pavel Cisar IBPhoenix Dne 9.7.2014 11:31, Werner

Re: [firebird-python] fdb - documentation typo

2014-07-10 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Fixed, thanks. Dne 10.7.2014 09:26, Werner werner...@gmx.ch [firebird-python] napsal(a): Document contents shows: Trasanction management should be: Transaction management

Re: [firebird-python] fdb - accented characters

2014-07-10 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, Yes, the connection charset is the key for automatic conversion. best regards Pavel Cisar IBPhoenix Dne 9.7.2014 18:29, Werner werner...@gmx.ch [firebird-python] napsal(a): I think I got this one, needed to add connect_args={'charset': 'utf8'} to the SA create_engine call.

Re: [firebird-python] Memory leak when using events

2014-11-07 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, This is definitely a bug in FDB event handling, but tricky one. It seems to me that root of this problem is that exception raised in EventBlock.__wait_for_events is not properly handled in upper levels, which in turn causes accumulation of blocks in queue. The circular reference you

Re: AW: [firebird-python] Memory leak when using events

2014-11-07 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, Well, the script is nice but I can't use it without the database it uses :) best regards Pavel Cisar IBPhoenix Dne 7.11.2014 v 12:19 Dominik Psenner dominik.psen...@topcontrol.it [firebird-python] napsal(a): Hi Pavel, Happy to read you. Sure thing, come up with a fix and I'll do my

Re: AW: AW: [firebird-python] Memory leak when using events

2014-11-07 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, thanks for the app, it helped to look into this issue. However, after deep look I start to think that this is actually not a bug, just pitfall. The problem is that when some problem arises while (re)registering interest in event notifications (isc_que_events API call), there is no good

Re: AW: AW: AW: [firebird-python] Memory leak when using events

2014-11-07 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, I have to think more about implementation details and consequences but I like your solution. If no problem arises I'm going to make a minor release with this fix next week. We're also working with Vlad on Unknown error issue which is most likely a bug in FB 2.5 engine. best regards Pavel

Re: AW: [firebird-python] FDB v1.4.2

2014-11-14 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, Fixed in 1.4.3, see PyPI. Thanks for pointing this out. best regards Pavel Cisar IBPhoenix Dne 14.11.2014 v 11:42 Dominik Psenner dominik.psen...@topcontrol.it [firebird-python] napsal(a): Hi Pavel, great to hear that you have got this release out of the door so quickly. However, I’m

Re: AW: AW: [firebird-python] FDB v1.4.2

2014-11-14 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Well, 1.4.3 is already out. Dne 14.11.2014 v 12:06 Dominik Psenner dominik.psen...@topcontrol.it [firebird-python] napsal(a): Awesome! Thanks for the fast responses, you’re doing a good job. ☺ If you feel like sending me a patch that I can apply before you push 1.4.3 out of the door, I’ll

Re: AW: AW: AW: [firebird-python] FDB v1.4.2

2014-11-14 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, Can you try to add a call to self.close() before exception is raised in __wait_for_events ? Does it helps? if db_api_error(self._isc_status): self.close() raise exception_from_status(DatabaseError, self._isc_status, Error while waiting for events:) best regards Pavel Dne 14.11.2014

Re: [firebird-python] fdb 1.4.3, SA 0.9.7 on Py2.7 conversion error

2015-02-04 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi Werner, Dne 4.2.2015 v 17:11 Werner werner...@gmx.ch [firebird-python] napsal(a): result = session.connection().execute(s, fk_authuser_id_1=1, maturityfirst_1='', maturityfirst_2='') for i in result: print(i) The two maturityfirst are integer columns and I inadvertently used a

Re: [firebird-python] FDB v1.4.2

2015-02-04 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi Dominik, Dne 17.11.2014 v 14:54 Dominik Psenner dominik.psen...@topcontrol.it [firebird-python] napsal(a): I believe that I have found a solution by shuffling the __wait_for_events() invoke. This is the patch (also available as attachment): Your solution is sound, change will appear in

[firebird-python] FDB v1.4.5

2015-04-01 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
FDB Python driver for Firebird v1.4.5 is available for download. This is pure bugfix release. Solves problems with memory and db resource leaks caused by Python GC due to circular references. https://pypi.python.org/pypi/fdb best regards Pavel Cisar IBPhoenix

Re: [firebird-python] fdb named parameters

2015-02-25 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, FDB doesn't support named parameters for SQL queries. However, it's nice idea so it's now in our tracker as feature request. I can't say when it will be implemented, but I'll get to it eventually. As it's now accepted feature request, any patch that implements it would be accepted if

Re: [firebird-python] Re: FDB v1.4.5

2015-04-02 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, Interesting, I'll investigate. Python GC could be a bitch when it's micromanaged. While this error message is annoying, it's harmless warning (object to be destroyed is already gone). best regards Pavel Dne 1.4.2015 v 21:27 Maximiliano Robaina maxi_roba...@yahoo.com.ar [firebird-python]

[firebird-python] FDB v1.4.6

2015-05-29 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
FDB Python driver for Firebird v1.4.6 is available for download. This is pure bugfix release. Solves 'weakly-referenced object no longer exists' problem. https://pypi.python.org/pypi/fdb best regards Pavel Cisar IBPhoenix

[firebird-python] FDB Python driver for Firebird v1.4.10 released

2015-08-31 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
FDB Python driver for Firebird v1.4.10 is available for download . This is pure bugfix release. https://pypi.python.org/pypi/fdb best regards Pavel Cisar IBPhoenix

[firebird-python] FDB Python driver for Firebird v1.5.1 released

2016-02-22 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
FDB Python driver for Firebird v1.5.1 is available for download. https://pypi.python.org/pypi/fdb best regards Pavel Cisar IBPhoenix Yahoo Groups Links <*> To visit your group

Re: [firebird-python] fdb smallint ranges fails

2016-04-11 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, Dne 11.4.2016 v 13:16 Maxi maxiroba...@gmail.com [firebird-python] napsal(a): > > BTW, Are you taking into consideration add fdb project into FirebirdSQL > github repos [1] ? > Would be great for a better contribution. Eventually yes, but not in next few months. best regards Pavel Cisar

Re: [firebird-python] fdb smallint ranges fails

2016-04-11 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, Dne 10.4.2016 v 17:01 Maximiliano Robaina maxi_roba...@yahoo.com.ar [firebird-python] napsal(a): > Why in fdb.ibase.py smaillint min range is defined as SHRT_MIN = -32767 ? It's a bug, sorry. Fix committed, will appear in next version. You can fix it manually for now. see

[firebird-python] FDB Python driver for Firebird v1.6 released

2016-03-30 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
FDB Python driver for Firebird v1.6 is available for download. https://pypi.python.org/pypi/fdb This version fixes few bugs and adds enhanced support for database_info and transaction_info. Now you can get almost all information in more convenient way (using properties and functions). best

Re: [firebird-python] fdb connect to non default port

2016-07-07 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, Yes, it's ignored for now. I'll fix that in some future version. best regards Pavel Cisar IBPhoenix Dne 1.7.2016 v 17:11 Maxi maxiroba...@gmail.com [firebird-python] napsal(a): > Hi, > > The connect function of fdb has a port parameter, but into function doc it > says: > > :param integer

[firebird-python] FDB Python driver for Firebird v1.6.1 released

2016-11-30 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
FDB v1.6.1 is available for download. This version fixes few bugs. https://pypi.python.org/pypi/fdb best regards Pavel Cisar IBPhoenix Yahoo Groups Links <*> To visit your group

Re: [firebird-python] fdb performance

2017-07-11 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, Dne 10.7.2017 v 20:28 at2tce3bx6dxq2hngnxe5xv74qhlsmeghchit...@yahoo.com [firebird-python] napsal(a): > Hello, > > I am finding fdb is 3-5 times slower than kinterbasdb. (Try inserting > 100,000 rows into a simple table). Is there any fix for this? I've tried > both Windows and Linux

[firebird-python] FDB Python driver for Firebird v1.8 released

2017-09-21 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
FDB Python driver for Firebird v1.8 is available for download. https://pypi.python.org/pypi/fdb NOTE: Due to API and other changes at PyPI, the link to FDB documentation at PyPI project page still points to version 1.7. For details please refer to documentation bundled with FDB distribution.

Re: [firebird-python] Timeout for connection

2017-12-21 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, Dne 20.12.2017 v 11:41 Zbigniew Szmigiero zszmigi...@gmail.com [firebird-python] napsal(a): > > The current Connection string does not provide any parameter to define > timeout. > It is crucial to have possibility set up it when incorrect connection > parameters are provided > In most

Re: [firebird-python] Fwd: Python cannot find path to fbclient

2018-08-27 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, FDB uses ctypes.find_library() to locate the client library, see https://docs.python.org/3.6/library/ctypes.html for details how this works. If Firebird (or at least the Firebird client) is installed normally on your local computer, then fbclient.dll should be located just fine.

Re: [firebird-python] sql replace params

2018-04-15 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, This has nothing to do with FDB. Parameters (?) are implemented by Firebird engine itself, FDB just supports it. So you should ask such question in Firebird-support list, or check out

Re: [firebird-python] Passing an argument from python to firebird

2018-11-12 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi, I'm not sure that I understand what you are asking for, because getting data from files is elementary programming task. If you want to execute Firebird statements (that includes execution of stored procedures) with parameters that are not directly stored in python source code (as literals

[firebird-python] FDB Python driver for Firebird v2.0.1 released

2019-07-13 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
FDB Python driver for Firebird v2.0.1 is available for download. https://pypi.python.org/pypi/fdb Improvements: - Enhancements to BlobReader - protected data as properties (blob_id, is_text, blob_charset, charset) - Added support for utf8 database filenames and other string db connection

[firebird-python] New Firebird driver for Python

2020-04-30 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi all, As I promised at Firebird Conference in Berlin, the Firebird has brand new DB API 2.0 driver for Python. It's part of modernization campaign that shakes off the legacy that goes back to KInterbasDB and Firebird 2.0. Please note, that his new driver requires Firebird 3+ and Python 3.8+.

[firebird-python] This list is moving to googlegroups

2020-10-15 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi all, Yahoo Groups will go offline entirely on the 15th of December 2020. So we moved it to googlegroup (as other affected Firebird lists). If you want to continue your participation in this list, please sign up in new one: https://groups.google.com/g/firebird-python best regards Pavel

[firebird-python] Firebird-driver & Firebird-lib 1.0.0 released

2020-10-14 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
The firebird-driver package provides official Python Database API 2.0-compliant driver. In addition to the minimal feature set of the standard Python DB API, this driver also exposes the new (interface-based) client API introduced in Firebird 3, and number of additional extensions and

[firebird-python] New Firebird driver for Python - preview release

2020-05-31 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi all, There is now an official preview release - v0.5.0 - available on PyPI: https://pypi.org/project/firebird-driver/ All core driver functionality works, except handling of limbo transactions due to error discovered in Firebird (should be fixed in soon to be released Firebird 3.0.6). This

[firebird-python] New firebird-base and firebird-driver releases

2020-06-30 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-python]
Hi all, Official BETA releases of both packages are now available on PyPI: https://pypi.org/project/firebird-base/ and https://pypi.org/project/firebird-driver/ The documentation is at: https://firebird-base.rtfd.io/ and https://firebird-driver.rtfd.io/ This driver release also includes initial