Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

2016-04-25 Thread Dimitry Sibiryakov
25.04.2016 22:34, Michal Kubecek wrote: > No, that's not the reason. If everything works the way it's supposed to, > the connection fails within one roundtrip and client doesn't have to > wait for a full second. For :: address, there is even less reason for > having to wait for a timeout.

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

2016-04-25 Thread Michal Kubecek
On Mon, Apr 25, 2016 at 05:46:24PM +0200, Dimitry Sibiryakov wrote: > 25.04.2016 17:42, Michal Kubecek wrote: > > A 2.5 server, however, does only listen to IPv4 connections and for > > some reason, client has to wait for timeout of the connection to :: > > which is tried first. > > Reason is

Re: [Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases

2016-04-25 Thread Adriano dos Santos Fernandes
On 25/04/2016 11:29, Dimitry Sibiryakov wrote: > 25.04.2016 16:23, Adriano dos Santos Fernandes wrote: >> Something like DBMS_SQL (and DBMS_LOB too, BTW) would be very useful >> to Firebird >What value they can add? > DBMS_SQL - allow dynamic (count, types) usage of parameters; query

[Firebird-devel] [FB-Tracker] Created: (CORE-5213) Database may get decrypted after changing couple of bytes in database header w/o 'agreement' from crypt plugin.

2016-04-25 Thread Alexander Peshkov (JIRA)
Database may get decrypted after changing couple of bytes in database header w/o 'agreement' from crypt plugin. --- Key: CORE-5213 URL:

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

2016-04-25 Thread Dimitry Sibiryakov
25.04.2016 17:42, Michal Kubecek wrote: > A 2.5 server, however, does only listen to IPv4 connections and for some > reason, client has to wait for timeout of the connection to :: which is > tried first. Reason is simple: addresses for a host are tried one-by-one. -- WBR, SD.

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

2016-04-25 Thread Michal Kubecek
On Mon, Apr 25, 2016 at 05:07:13PM +0200, Stefan Heymann wrote: > >>Try to set option IPv6V6Only to true in firebird.conf and see if > >>it makes any difference. > > > This directive affects only listening sockets (i.e. a server) and > > would actually do the exact opposite: make the

Re: [Firebird-devel] User password for encryption

2016-04-25 Thread Dimitry Sibiryakov
25.04.2016 17:03, Alex Peshkoff wrote: > Unlike other methods key in this case is not touched by open source code > making possibility of stealing it much smaller. It doesn't matter if engine will decrypt whole database for you after changing couple of bytes in header. Key is pointless,

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

2016-04-25 Thread Stefan Heymann
>>Try to set option IPv6V6Only to true in firebird.conf and see if it >>makes any difference. > This directive affects only listening sockets (i.e. a server) and would > actually do the exact opposite: make the server listening on (default) > address :: accept only IPv6 connections (to

Re: [Firebird-devel] User password for encryption

2016-04-25 Thread Alex Peshkoff
On 04/25/2016 03:51 PM, Emil Totev wrote: >> From: Alex Peshkoff >> Subject: Re: [Firebird-devel] User password for encryption >> To: firebird-devel@lists.sourceforge.net >> Message-ID: <571e0924.3010...@mail.ru> >> Content-Type: text/plain; charset=windows-1252; format=flowed

Re: [Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases

2016-04-25 Thread Dimitry Sibiryakov
25.04.2016 16:23, Adriano dos Santos Fernandes wrote: > Something like DBMS_SQL (and DBMS_LOB too, BTW) would be very useful > to Firebird What value they can add? -- WBR, SD. -- Find and fix application

Re: [Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases

2016-04-25 Thread Adriano dos Santos Fernandes
On 25/04/2016 09:32, Dmitry Yemanov wrote: > 25.04.2016 15:28, Mark Rotteveel wrote: >> Still missing from the list: >> * Substring with regex: >> http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/bk01ch09s05.html#rnfb30-dml-substring >> >> Might work; haven't tried it yet but I

Re: [Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases

2016-04-25 Thread Mark Rotteveel
On 2016-04-25 13:32, Dmitry Yemanov wrote: > 25.04.2016 15:28, Mark Rotteveel wrote: >> >> Still missing from the list: >> * Substring with regex: >> >> http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/bk01ch09s05.html#rnfb30-dml-substring >> >> Might work; haven't tried it yet

[Firebird-devel] [FB-Tracker] Created: (CORE-5212) PK constraint should be prevented from dropping if there is procedure/trigger which uses it in UPDATE OR INSERT statement (otherwise such SP will wor

2016-04-25 Thread Pavel Zotov (JIRA)
PK constraint should be prevented from dropping if there is procedure/trigger which uses it in UPDATE OR INSERT statement (otherwise such SP will work incorrect)

Re: [Firebird-devel] User password for encryption

2016-04-25 Thread Emil Totev
> From: Alex Peshkoff > Subject: Re: [Firebird-devel] User password for encryption > To: firebird-devel@lists.sourceforge.net > Message-ID: <571e0924.3010...@mail.ru> > Content-Type: text/plain; charset=windows-1252; format=flowed > > On 04/25/2016 11:28 AM, Emil Totev wrote: >>

Re: [Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases

2016-04-25 Thread Dmitry Yemanov
And our DDL is not so transactional as they think ;-) Dmitry -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers

Re: [Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases

2016-04-25 Thread Dmitry Yemanov
25.04.2016 15:28, Mark Rotteveel wrote: > > Still missing from the list: > * Substring with regex: > http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/bk01ch09s05.html#rnfb30-dml-substring > > Might work; haven't tried it yet but I think it should be possible now > * Index using

Re: [Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases

2016-04-25 Thread Mark Rotteveel
On 2016-04-25 13:11, marius adrian popa wrote: > http://www.sql-workbench.net/dbms_comparison.html [1] > > > Links: > -- > [1] http://www.sql-workbench.net/dbms_comparison.html Still missing from the list: * Substring with regex:

Re: [Firebird-devel] Firebird.pas for the windows build

2016-04-25 Thread Alex Peshkoff
On 04/25/2016 01:57 PM, Simonov Denis wrote: > Alex Peshkoff писал(а) в своём письме Mon, 28 Mar 2016 > 12:46:02 +0300: > >> On 03/25/2016 03:51 PM, Alex Peshkoff wrote: >>> On 03/25/2016 12:48 PM, preeves wrote: On Thu, 24 Mar 2016 12:35:25 +0300 Alex Peshkoff

[Firebird-devel] Updated Comparison of many standard (and non-standard) SQL features amongst 10 databases

2016-04-25 Thread marius adrian popa
http://www.sql-workbench.net/dbms_comparison.html -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business

Re: [Firebird-devel] User password for encryption

2016-04-25 Thread Alex Peshkoff
On 04/25/2016 11:28 AM, Emil Totev wrote: > How difficult would it be to get the user password to the encryption / > key holder plugin, especially for an embedded connection? I will start from the most simple part - embedded connection. As far as I understand you ask about password which is used

[Firebird-devel] [FB-Tracker] Created: (CORE-5211) Compiler error for assignment variable to empty string which is enclosed in DOUBLE QUOTES differ in 3.0 vs previous versions.

2016-04-25 Thread Pavel Zotov (JIRA)
Compiler error for assignment variable to empty string which is enclosed in DOUBLE QUOTES differ in 3.0 vs previous versions. - Key: CORE-5211

Re: [Firebird-devel] Firebird.pas for the windows build

2016-04-25 Thread Simonov Denis
Adriano dos Santos Fernandes wrote Thu, 24 Mar 2016 13:36:27 +0300: > On 24/03/2016 06:35, Alex Peshkoff wrote: >> How are we meant to do this in the windows build? >> Paul, I see 2 alternatives. >> 1. (correct) Build cloop and execute same command. >> > > Is the Windows

[Firebird-devel] User password for encryption

2016-04-25 Thread Emil Totev
How difficult would it be to get the user password to the encryption / key holder plugin, especially for an embedded connection? If possible at all, would this require new authentication plugin or key holder plugin or both? Applications using embedded connections would benefit most from database

Re: [Firebird-devel] Feature request & discussion for V4 (same as for V3)

2016-04-25 Thread Dmitry Yemanov
25.04.2016 10:35, Christian Waldmann wrote: > In Firebird CORE-659 (http://tracker.firebirdsql.org/browse/CORE-659) there > is a collection of requests for spatial index, e.g. R*Tree or GiST, for GIS > applications and other. Spatial indexes are also fine to find events in a > interval of time. >

[Firebird-devel] Feature request & discussion for V4 (same as for V3)

2016-04-25 Thread Christian Waldmann
In Firebird CORE-659 (http://tracker.firebirdsql.org/browse/CORE-659) there is a collection of requests for spatial index, e.g. R*Tree or GiST, for GIS applications and other. Spatial indexes are also fine to find events in a interval of time. R* Tree at https://en.wikipedia.org/wiki/R*_tree