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

[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.

   Unless there is a black hole-type firewall like Win7's FW in stealth mode: 
https://technet.microsoft.com/en-us/library/dd448557%28WS.10%29

-- 
   WBR, SD.

--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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 simple: addresses for a host are tried one-by-one.

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.

Michal Kubecek


--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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
inspection (describe)

DBMS_LOB - avoid blob trashing


Adriano


--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[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.

[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: http://tracker.firebirdsql.org/browse/CORE-5213
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0.0
Reporter: Alexander Peshkov


For databases distributed in encrypted form it's necessary to avoid any ability 
to be decrypted by client including one mentioned in this issue.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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.

--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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 server listening on
> > (default) address :: accept only IPv6 connections (to any address).
> > To accept only IPv4 connections, you would rather want
> > "RemoteBindAddress 0.0.0.0" (or e.g. 127.0.0.1).
> 
> We're now talking about Fb3 servers, right? Wenn I connect to a Fb3
> server (using the Fb3 client and "localhost" as the host name), the
> connection is quick.
> 
> The problem is when I use the Fb3 client to connect to a Fb2.5
> database. Then there is this one second delay.

Yes, that's why I explained that the IPv6V6Only directive cannot help
you as it does only affect server so that it can't change the behaviour
of a 3.0 client (and a 2.5 server wouldn't recognize it at all).

> Connection time using the new Fb3 fbclient.dll:
> - 3.0 database using "localhost" - quick
> - 3.0 database using "127.0.0.1" - quick
> - 2.5 database using "localhost" - slow
> - 2.5 database using "127.0.0.1" - quick

This agrees with the theory: "localhost" resolves to both :: and
127.0.0.1 and according to your system's rules, :: is preferred. With
3.0 database listening to any IPv6 or IPv4 connection, both are quick.
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.

  Michal Kubecek


--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] User password for encryption

[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, database is a real target.

-- 
   WBR, SD.

--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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 any address). To accept only
> IPv4 connections, you would rather want "RemoteBindAddress 0.0.0.0" (or
> e.g. 127.0.0.1).

We're now talking about Fb3 servers, right? Wenn I connect to a Fb3
server (using the Fb3 client and "localhost" as the host name), the
connection is quick.

The problem is when I use the Fb3 client to connect to a Fb2.5
database. Then there is this one second delay.

To sum things up:

Connection time using the new Fb3 fbclient.dll:
- 3.0 database using "localhost" - quick
- 3.0 database using "127.0.0.1" - quick
- 2.5 database using "localhost" - slow
- 2.5 database using "127.0.0.1" - quick

Regards

Stefan



--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] User password for encryption

[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
>>
>> 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 to login to the server
>> (isc_dpb_password) Unfortunately question makes no sense - for embedded
>> connection password is not needed at all and no authentication plugin is
>> used (even when password is present in DPB it's just ignored). On the
>> other hand it's not too hard to add to firebird engine a code, passing
>> isc_dpb_password value to key holder plugin (as one of a keys for
>> example). But that hardly makes much sense on my mind.
> Then, how would you pass a key to the engine in the embedded case?

If the key to be passed from application the best way is to use callback.
Unlike other methods key in this case is not touched by open source code 
making possibility of stealing it much smaller.


--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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 performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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 think it should be possible now
>> * Index using a custom function
>> * Functions as column default
>>
>> Incorrect:
>> * Session local temporary tables : Firebird doesn't have this
> Also:
>
> Dynamic SQL in functions(*) - NO
> Dynamic SQL in triggers(*) - NO
>
> Why do they ignore EXECUTE STATEMENT?
>

Must say that when I first read it, I thought it was ok thinking in
something like Oracle's DBMS_SQL.

So:

1) We have dynamic SQL in functions/triggers

2) Something like DBMS_SQL (and DBMS_LOB too, BTW) would be very useful
to Firebird


Adriano


--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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 but I think it should be possible 
>> now
>> * Index using a custom function
>> * Functions as column default
>>
>> Incorrect:
>> * Session local temporary tables : Firebird doesn't have this
>
> Also:
>
> Dynamic SQL in functions(*) - NO
> Dynamic SQL in triggers(*) - NO
>
> Why do they ignore EXECUTE STATEMENT?

Probably because it is impossible to check everything (that is also why 
they have an e-mailaddress listed for corrections).

Mark

--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[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

[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)
-

 Key: CORE-5212
 URL: http://tracker.firebirdsql.org/browse/CORE-5212
 Project: Firebird Core
  Issue Type: Improvement
  Components: Engine
Affects Versions: 3.0.0, 4.0 Initial, 2.5.5
Reporter: Pavel Zotov


Consider script:
===
set echo on;
create or alter procedure sp_test as begin end;
recreate table test(
u int not null, v int not null, w int not null
);


alter table test add constraint test_pk primary key( u );
commit;

set term  ^;
create or alter procedure sp_test(a_u int, a_v int, a_w int) as 
begin 
update or insert into test( u, v, w ) values ( :a_u, :a_v, :a_w );
end ^
set term ;^
commit;

execute procedure sp_test( 1, 10, 20);
execute procedure sp_test( 2, 20, 40);
execute procedure sp_test( 1, 11, 22);

select * from test;
delete from test;
commit;

alter table test drop constraint test_pk;
commit;

-- //
alter table test add constraint test_pk primary key( v );
-- \\
commit;
show table test;

/*

set term  ^;
create or alter procedure sp_test(a_u int, a_v int, a_w int) as 
begin 
update or insert into test( u, v, w ) values ( :a_u, :a_v, :a_w );
end ^
set term ;^
commit;

*/

execute procedure sp_test( 1, 10, 20);
execute procedure sp_test( 2, 20, 40);
execute procedure sp_test( 1, 11, 22);

select * from test;
===

If you will NOT make recreation of SP_TEST after dropping PK (and assign it to 
another column), this SP will work wrong: it seems like OLD PK definition is 
stored somewhere.

With __NEW__ primary key (column'V') last three statements will produce content 
of table TEST like with __OLD__ PK = 'U':
===
execute procedure sp_test( 1, 10, 20);
execute procedure sp_test( 2, 20, 40);
execute procedure sp_test( 1, 11, 22);

select * from test;

   UVW
  
   1   11   22
   2   20   40
===

So, one need to empty bodies of all such procedures / triggers before this PK 
will be dropped, and later to fill them again + recompile.
It will be great if this job could be done in the single transaction by engine 
itself.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] User password for encryption

[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:
>> 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 to login to the server
> (isc_dpb_password) Unfortunately question makes no sense - for embedded
> connection password is not needed at all and no authentication plugin is
> used (even when password is present in DPB it's just ignored). On the
> other hand it's not too hard to add to firebird engine a code, passing
> isc_dpb_password value to key holder plugin (as one of a keys for
> example). But that hardly makes much sense on my mind.

Then, how would you pass a key to the engine in the embedded case?

> What about remote case - passing password in current state f code is
> close to impossible. Password NEVER travels over the wire (except of
> legacy authentication). Certainly one can write plugin which will send
> password from client to server but that's definitely very bad idea from
> security POV. Certainly a trick similar to embedded can help (and
> password will be sent over already encrypted line in that case) but I'm
> afraid that's a bit not what you were asking about.

OK. I fully agree. Let's forget about remote and stick to embedded.

>> If possible
>> at all, would this require new authentication plugin or  key holder
>> plugin or both?
>
> New key holder plugin and some changes in it's interfaces.
>
>> Applications using embedded connections would benefit most from
>> database encryption, and using the password (which can be supplied,
>> but is not used for authentication) for this seems to be an easy way
>> to seamlessly integrate it.
>
> Don't think so. Sending a key (password will be a key in this case,
> yes?) in DPB is the best way to help malicious user steal it.
>

There is no "sending" in the embedded case. Most current software has
the ability to collect a password from the user and pass it to the
provider. Why not use this to add database encryption almost
transparently? Do you see any problems with it?

Regards
Emil

--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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 of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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 a custom function
> * Functions as column default
>
> Incorrect:
> * Session local temporary tables : Firebird doesn't have this

Also:

Dynamic SQL in functions(*) - NO
Dynamic SQL in triggers(*) - NO

Why do they ignore EXECUTE STATEMENT?


Dmitry


--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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: 
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 a custom function
* Functions as column default

Incorrect:
* Session local temporary tables : Firebird doesn't have this

Mark

--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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  wrote:

> On 03/23/2016 06:39 PM, preeves wrote:
>> Firebird.pas is generated in the posix builds but it is not
>> generated in the windows builds. Posix builds generate it via this
>> target:
>>
>> $(API_PAS_FILE): $(IDL_FILE) $(PASCAL_SOURCES) $(TMP_FUNCS)
>> $(CLOOP) $(IDL_FILE) pascal $@ Firebird --uses SysUtils \
>> --interfaceFile $(PAS_ROOT)/Pascal.interface.pas \
>> --implementationFile $(PAS_ROOT)/Pascal.implementation.pas
>> \ --exceptionClass FbException \
>> --functionsFile $(TMP_FUNCS) \
>> --prefix I
>>
>> There seems to be more going on here than simple file
>> concatenation.
> Much more.
>
 AFAICT a
 git push will pick up a changed Firebird.pas each time it is rebuilt on
 a posix host, so it won't be too difficult to keep it up-to-date.
>>> Well, if nobody will provide strong arguments against this I will commit
>>> the generated file on Monday.
>>>
>> Added to B3_0, still hope on correct approach in fb4.
>>
> In Firebird 3.0 release under windows again absent Firebird.pas file. It
> is not available in the snapshot too.

Denis, unfortunately 'Added' means here that generated Firebird.pas was 
placed into git tree.
Please get it from linux binaries or source tarball (src/include/gen) or 
from github (B3_0_Release).



--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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 applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;zFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] User password for encryption

[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 to login to the server 
(isc_dpb_password) Unfortunately question makes no sense - for embedded 
connection password is not needed at all and no authentication plugin is 
used (even when password is present in DPB it's just ignored). On the 
other hand it's not too hard to add to firebird engine a code, passing 
isc_dpb_password value to key holder plugin (as one of a keys for 
example). But that hardly makes much sense on my mind.

What about remote case - passing password in current state f code is 
close to impossible. Password NEVER travels over the wire (except of 
legacy authentication). Certainly one can write plugin which will send 
password from client to server but that's definitely very bad idea from 
security POV. Certainly a trick similar to embedded can help (and 
password will be sent over already encrypted line in that case) but I'm 
afraid that's a bit not what you were asking about.

> If possible
> at all, would this require new authentication plugin or  key holder
> plugin or both?

New key holder plugin and some changes in it's interfaces.

> Applications using embedded connections would benefit most from
> database encryption, and using the password (which can be supplied,
> but is not used for authentication) for this seems to be an easy way
> to seamlessly integrate it.

Don't think so. Sending a key (password will be a key in this case, 
yes?) in DPB is the best way to help malicious user steal it.


--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[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.

[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
 URL: http://tracker.firebirdsql.org/browse/CORE-5211
 Project: Firebird Core
  Issue Type: Improvement
  Components: Engine
Affects Versions: 3.0.0, 4.0 Initial
Reporter: Pavel Zotov
Priority: Minor


Consider script which shoud raise compiler error (because of DOUBLE quotes in 
assignment):

set term ^;
execute block returns(o varchar(10)) as
begin
  o = "qwe";
end
^

If you run this script on 2.1, 2.5 and 3.0 you will get the same error: 
===
Statement failed, SQLSTATE = 42S22
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-qwe
===

But if we replace "qwe" with empty string ( o = ""; ) then we get:
===
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Zero length identifiers are not allowed
===
(I've checked on WI-V3.0.0.32490)

As for 2.1 and 2.5 - error will be the same, but without showing value empty 
string (though this could be clarified by something like ):
===
Statement failed, SQLSTATE = 42S22
Dynamic SQL Error
-SQL error code = -206
-Column unknown
===

Can the message "-Zero length identifiers are not allowed" be replaced with old 
one ? 


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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 guys doing manual editing of the generated file after API
> changes?
>

In principle, you can not include in Firebird.pas snapshots, if it is  
difficult to collect each time. But then
1. cloop tool must be compiled and included in the kit Firebird utilities.
2. It should be documented. At a minimum, the instrument itself must  
provide help for the options with the /? or --help. Now to find out you  
have to read the source code.
3. The release archives and distribution Firebird.pas file should be  
included. Release and subrelease comes not so often.

>
> Adriano
>
>
> --
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140
> Firebird-Devel mailing list, web interface at  
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>


-- 
Simonov Denis


--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] User password for encryption

[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 encryption, and using the password (which can be supplied,
but is not used for authentication) for this seems to be an easy way
to seamlessly integrate it.

Emil

--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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.
>
> R* Tree at https://en.wikipedia.org/wiki/R*_tree
> GiST at http://gist.cs.berkeley.edu/

Unfortunately, we don't have resources for this task. Only if some 3rd 
party is willing to develop the code and contribute it. I know that 
RedSoft is interested, but I don't know what is their roadmap on this.

> I think the support of spatial indexes can bring a lot of new users from
> SQLite (https://www.sqlite.org/rtree.html ) and PostgreSQL
> (http://www.postgresql.org/docs/8.1/static/indexes-types.html) to FireBird.

Probably for SQLite, unlikely for PGSQL.


Dmitry


--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[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 
GiST at http://gist.cs.berkeley.edu/ 

I think the support of spatial indexes can bring a lot of new users from
SQLite (https://www.sqlite.org/rtree.html ) and PostgreSQL
(http://www.postgresql.org/docs/8.1/static/indexes-types.html) to FireBird.

Christian Waldmann


--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel