On Thu, 27 May 2021 08:39:58 -0300, Adriano dos Santos Fernandes
wrote:
> On 27/05/2021 04:29, Virgo Pärna via Firebird-devel wrote:
>>
>> At same time UDF is still faster than UDR/function. I did some
>
> UDR will always be slower than UDF, after all UDF is insecure (does not
> validate
On 27/05/2021 08:48, Omacht András wrote:
> Adriano,
>
> can you tell me what are the extra jobs that make calling through a function
> such a significant slowdown in other cases?
>
> It will be difficult to change from UDF to function if the runtime is doubled
> in such a simple case as it
PM
To: firebird-devel@lists.sourceforge.net
Subject: Re: [Firebird-devel] Deprecations
On 27/05/2021 07:49, Omacht András wrote:
> Hi Virgo and all!
>
>
>
> I also did some tests on 3.0.8.33468
>
>
>
> I had a table with 2.8 million records. I tested
On 27/05/2021 04:29, Virgo Pärna via Firebird-devel wrote:
> On Thu, 20 May 2021 11:45:22 +, Omacht András
> wrote:
>> UDF has been a compromise for us from the beginning (since IB 6.0 or maybe
>> 5.5). If it is possible, we don’t want to depend on things outside of the
>> database because
On 27/05/2021 07:49, Omacht András wrote:
> Hi Virgo and all!
>
>
>
> I also did some tests on 3.0.8.33468
>
>
>
> I had a table with 2.8 million records. I tested with its one of the
> date (not timestamp) fields.
>
>
>
> Case 1.: UDF call
>
> DECLARE EXTERNAL FUNCTION TO_CHAR
>
>
Pärna
Subject: Re: [Firebird-devel] Deprecations
On Thu, 20 May 2021 11:45:22 +, Omacht András
mailto:omacht.and...@libra.hu>> wrote:
> UDF has been a compromise for us from the beginning (since IB 6.0 or maybe
> 5.5). If it is possible, we don’t want to depend on th
On Thu, 20 May 2021 11:45:22 +, Omacht András
wrote:
> UDF has been a compromise for us from the beginning (since IB 6.0 or maybe
> 5.5). If it is possible, we don’t want to depend on things outside of the
> database because it is only a problem to have to ask the customers for any
>
-
From: Mark Rotteveel [mailto:m...@lawinegevaar.nl]
Sent: Thursday, May 20, 2021 10:29 AM
To: firebird-devel@lists.sourceforge.net
Subject: Re: [Firebird-devel] Deprecations
On 2021-05-20 08:28, Omacht András wrote:
> Mark: Yes, that could be good, but it’s not even in 4.0, so (one day)
&
On 2021-05-20 08:28, Omacht András wrote:
Mark: Yes, that could be good, but it’s not even in 4.0, so (one day)
we wouldn’t be able to switch to 5.0 by rewriting these calls first.
For the time being, the original plan remains: writing a function,
replacing udf calls with it ...
Or rewrite
...@lawinegevaar.nl]
Sent: Wednesday, May 19, 2021 8:04 PM
To: firebird-devel@lists.sourceforge.net
Subject: Re: [Firebird-devel] Deprecations
On 2021-05-19 19:40, Omacht András wrote:
> Hi!
>
> Since Firebird 2.5, we have been able to replace almost all UDFs with
> built-
On 19/05/2021 16:00, Dmitry Yemanov wrote:
> 19.05.2021 13:32, Adriano dos Santos Fernandes wrote:
>>
>> v4 is not yet released. We may deprecate QLI in v4 already and remove in
>> master.
>
> If it's just a matter of adding a paragraph to the release notes, then I
> may agree to deprecate QLI in
On 19/05/2021 16:02, Dmitry Yemanov wrote:
> 19.05.2021 14:40, Mark Rotteveel wrote:
>>
>> Dialect 1 was already deprecated with InterBase 6.0. I think people
>> will continue to use dialect 1 as long as Firebird supports it, though
>> to be honest, I would guess that most users of dialect 1
19.05.2021 19:40, Omacht András wrote:
If anyone has an idea of what can be used instead, I would greatly appreciate
it.
You can rewrite the UDF into UDR function.
but please, this should not be the suggestion:
select extract(year from cast('NOW' as timestamp)) || '.' ||
19.05.2021 14:40, Mark Rotteveel wrote:
Dialect 1 was already deprecated with InterBase 6.0. I think people will
continue to use dialect 1 as long as Firebird supports it, though to be
honest, I would guess that most users of dialect 1 aren't even on recent
versions of Firebird. We should
19.05.2021 13:32, Adriano dos Santos Fernandes wrote:
v4 is not yet released. We may deprecate QLI in v4 already and remove in
master.
If it's just a matter of adding a paragraph to the release notes, then I
may agree to deprecate QLI in v4.
Dmitry
Firebird-Devel mailing list, web
On 2021-05-19 18:33, Nils Bödeker wrote:
Hello
as user opinion (sorry)
We still using UDFs.
Own written and external like this one
http://freeadhocudf.org [1]
For us, UDF support should be still in FB 5.
I'd recommend rewriting your own UDFs to UDRs, the replacement feature
for UDFs. As
On 2021-05-19 19:40, Omacht András wrote:
Hi!
Since Firebird 2.5, we have been able to replace almost all UDFs with
built-in functions.
There is only one left (it’s the Highlander :)) : formatting dates
and timestamps to readable format for hungarian people:
-- Hungarian format
select
:34 PM
To: For discussion among Firebird Developers
Subject: Re: [Firebird-devel] Deprecations
Hello
as user opinion (sorry)
We still using UDFs.
Own written and external like this one
http://freeadhocudf.org<http://freeadhocudf.org/>
For us, UDF support should be still i
Hello
as user opinion (sorry)
We still using UDFs.
Own written and external like this one
http://freeadhocudf.org
For us, UDF support should be still in FB 5.
With best regards
Nils Bödeker
>
> Am 18.05.2021 um 23:44 schrieb Adriano dos Santos Fernandes
> :
>
> Hi!
>
> UDF was been
On 2021-05-19 11:49, Dmitry Yemanov wrote:
19.05.2021 12:27, Alex Peshkoff via Firebird-devel wrote:
I have the same question about dialect 1
A few years ago it was discussed but people continued (at least
continued that time) to use it...
Same as item 1 above. We can do it now, but
On 2021-05-19 12:35, Adriano dos Santos Fernandes wrote:
On 19/05/2021 06:27, Alex Peshkoff via Firebird-devel wrote:
Let me also add suggest gsec and related services - was deprecated in
fb3.
I'll not be strongly against, as I (and TCS) could probably adapt, but
I
always used it to add
On 19/05/2021 07:38, Dimitry Sibiryakov wrote:
> 19.05.2021 12:36, Adriano dos Santos Fernandes wrote:
>>> Most likely no because of differences in BLR.
>>>
>> What differences?
>
> Whichever will be introduced in v5.
>
QLI already is unmaintained, it does not even support v4 BLR
19.05.2021 12:36, Adriano dos Santos Fernandes wrote:
Most likely no because of differences in BLR.
What differences?
Whichever will be introduced in v5.
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
19.05.2021 12:35, Adriano dos Santos Fernandes wrote:
Connect to employee database and create an user?
Connect to the security database and create user. You cannot create users without
security database (with gsec as well).
--
WBR, SD.
Firebird-Devel mailing list, web interface at
On 19/05/2021 07:35, Dimitry Sibiryakov wrote:
> 19.05.2021 12:32, Adriano dos Santos Fernandes wrote:
>> in the worst
>> cases, people could get it from v4 and use with v5.
>
> Most likely no because of differences in BLR.
>
What differences?
Adriano
Firebird-Devel mailing list, web
On 19/05/2021 06:27, Alex Peshkoff via Firebird-devel wrote:
>
> Let me also add suggest gsec and related services - was deprecated in fb3.
>
I'll not be strongly against, as I (and TCS) could probably adapt, but I
always used it to add SYSDBA to security database before run TCS.
What's the
19.05.2021 12:32, Adriano dos Santos Fernandes wrote:
in the worst
cases, people could get it from v4 and use with v5.
Most likely no because of differences in BLR.
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 19/05/2021 06:49, Dmitry Yemanov wrote:
> 19.05.2021 12:27, Alex Peshkoff via Firebird-devel wrote:
>>>
>>> UDF was been deprecated in FB 4.
>>>
>>> Could we remove them from master for v5?
>>
>> Doubt that. UDF is too actively used feature, lot of users will not be
>> happy.
>
> Generally,
19.05.2021 12:53, Dimitry Sibiryakov пишет:
It is what SET BIND is for.
Not really. It's OK to replace DECFLOAT with DOUBLE, but what to do with
simple arithmetics where 1/1 returns INT instead of DOUBLE? Do you want
to replace all returned INTs?
Dmitry
Firebird-Devel mailing list, web
19.05.2021 11:50, Dmitry Yemanov wrote:
so we can "support" dialect 1 by silent ignore.
Returned data types will be different, this may break existing applications.
It is what SET BIND is for. It can be used in "on connect" triggers on per-application
basis, right?
--
WBR, SD.
19.05.2021 12:34, Dimitry Sibiryakov wrote:
AFAIR these discussions, people wanted new features in it (such as
BIGINT) and the only named advantage was double precision arithmetic.
This is covered by INT128/DECFLOAT arithmetic in v4 if I'm not mistaken
Correct.
so we can "support"
19.05.2021 12:27, Alex Peshkoff via Firebird-devel wrote:
UDF was been deprecated in FB 4.
Could we remove them from master for v5?
Doubt that. UDF is too actively used feature, lot of users will not be
happy.
Generally, it's OK to remove already deprecated features in the next
major
19.05.2021 11:27, Alex Peshkoff via Firebird-devel wrote:
I have the same question about dialect 1
A few years ago it was discussed but people continued (at least continued that time) to
use it...
AFAIR these discussions, people wanted new features in it (such as BIGINT) and the only
On 5/19/21 12:42 AM, Adriano dos Santos Fernandes wrote:
Hi!
UDF was been deprecated in FB 4.
Could we remove them from master for v5?
Doubt that. UDF is too actively used feature, lot of users will not be
happy.
Also QLI, I believe nobody uses it and there should be no good reason to
18.05.2021 23:42, Adriano dos Santos Fernandes wrote:
UDF was been deprecated in FB 4.
Could we remove them from master for v5?
I have the same question about dialect 1 and multi-file databases (which already were
supposed to be removed in 4.0).
--
WBR, SD.
Firebird-Devel mailing
35 matches
Mail list logo