firebird-devel — List for general discussion among IB developers

Re: [Firebird-devel] Improve release filenames

[Jiří Č. <ji...@ci...>]

I would unify the `pdb`, `debuginfo`, etc. into simple `debug` suffix. 

Probably Alex can clarify, but it really the ARM32/64 for Linux? And if so, do we even need ARM32?

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

Re: [Firebird-devel] Improve release filenames

[Adriano d. S. F. <adr...@gm...>]

On 24/08/2022 08:59, Mark Rotteveel wrote:
> On 24-08-2022 13:45, Adriano dos Santos Fernandes wrote:
>> This is our Firebird 4.0.2 released files:
>>
> [..]
>> It's difficult to understand, they do not mention OS and hardware
>> architectures are inconsistent.
>>
>> I propose this name convention starting with Firebird 5:
> [..]
>> Firebird-5.0.0.2816-0-linux-x64.tar.gz
>> Firebird-5.0.0.2816-0-linux-x64-debuginfo.tar.gz
>> Firebird-5.0.0.2816-0-linux-arm.tar.gz (armv7, other?)
>> Firebird-5.0.0.2816-0-linux-arm-debuginfo.tar.gz
>> Firebird-5.0.0.2816-0-linux-arm64.tar.gz
>> Firebird-5.0.0.2816-0-linux-arm64-debuginfo.tar.gz
> [..]
> 
> In general I'm OK with this, but currently our download page claims the
> ARM32 and ARM64 build are for Android, and not generically Linux.
> 
> So, are they actually generically Linux, or specifically for Android?
> 

You might be correct.

Alex can certainly explain better.

I'm also not sure about arm64 vs aarch64 differences.

Here
https://github.com/asfernandes/firebird/releases/tag/v4.0.0-aarch64-asfernandes
I built a Linux RaspBerry pi and named aarch64 but never published it as
official.


Adriano

Re: [Firebird-devel] Improve release filenames

[Mark R. <ma...@la...>]

On 24-08-2022 13:45, Adriano dos Santos Fernandes wrote:
> This is our Firebird 4.0.2 released files:
> 
[..]
> It's difficult to understand, they do not mention OS and hardware
> architectures are inconsistent.
> 
> I propose this name convention starting with Firebird 5:
[..]
> Firebird-5.0.0.2816-0-linux-x64.tar.gz
> Firebird-5.0.0.2816-0-linux-x64-debuginfo.tar.gz
> Firebird-5.0.0.2816-0-linux-arm.tar.gz (armv7, other?)
> Firebird-5.0.0.2816-0-linux-arm-debuginfo.tar.gz
> Firebird-5.0.0.2816-0-linux-arm64.tar.gz
> Firebird-5.0.0.2816-0-linux-arm64-debuginfo.tar.gz
[..]

In general I'm OK with this, but currently our download page claims the 
ARM32 and ARM64 build are for Android, and not generically Linux.

So, are they actually generically Linux, or specifically for Android?

Mark
-- 
Mark Rotteveel

[Firebird-devel] Improve release filenames

[Adriano d. S. F. <adr...@gm...>]

Hi!

This is our Firebird 4.0.2 released files:

Firebird-4.0.2.2816-0-Win32-pdb.exe
Firebird-4.0.2.2816-0-Win32-pdb.zip
Firebird-4.0.2.2816-0-Win32.exe
Firebird-4.0.2.2816-0-Win32.zip
Firebird-4.0.2.2816-0-x64-pdb.exe
Firebird-4.0.2.2816-0-x64-pdb.zip
Firebird-4.0.2.2816-0-x64.exe
Firebird-4.0.2.2816-0-x64.zip
Firebird-4.0.2.2816-0.amd64.tar.gz
Firebird-4.0.2.2816-0.arm.tar.gz
Firebird-4.0.2.2816-0.arm64.tar.gz
Firebird-4.0.2.2816-0.i686.tar.gz
Firebird-4.0.2.2816-0.tar.xz
Firebird-debuginfo-4.0.2.2816-0.amd64.tar.gz
Firebird-debuginfo-4.0.2.2816-0.i686.tar.gz
Firebird-withDebugInfo-4.0.2.2816-0.arm.tar.gz
Firebird-withDebugInfo-4.0.2.2816-0.arm64.tar.gz
(missing MacOS which would be: Firebird-4.0.2.2816-x86_64.pkg)

It's difficult to understand, they do not mention OS and hardware
architectures are inconsistent.

I propose this name convention starting with Firebird 5:

Firebird-5.0.0.2816-0-windows-x86-pdb.exe
Firebird-5.0.0.2816-0-windows-x86-pdb.zip
Firebird-5.0.0.2816-0-windows-x86.exe
Firebird-5.0.0.2816-0-windows-x86.zip
Firebird-5.0.0.2816-0-windows-x64-pdb.exe
Firebird-5.0.0.2816-0-windows-x64-pdb.zip
Firebird-5.0.0.2816-0-windows-x64.exe
Firebird-5.0.0.2816-0-windows-x64.zip
Firebird-5.0.0.2816-0-linux-x64.tar.gz
Firebird-5.0.0.2816-0-linux-x64-debuginfo.tar.gz
Firebird-5.0.0.2816-0-linux-arm.tar.gz (armv7, other?)
Firebird-5.0.0.2816-0-linux-arm-debuginfo.tar.gz
Firebird-5.0.0.2816-0-linux-arm64.tar.gz
Firebird-5.0.0.2816-0-linux-arm64-debuginfo.tar.gz
Firebird-5.0.0.2816-0-linux-x86.tar.gz
Firebird-5.0.0.2816-0-linux-x86-debuginfo.tar.gz
Firebird-5.0.0.2816-0-source.tar.xz
Firebird-5.0.0.2816-0-macos-x64.pkg


Adriano

Re: [Firebird-devel] Profiler plugin is not found. Windows snapshot Firebird-5.0.0.684-0-x64

[Adriano d. S. F. <adr...@gm...>]

On 23/08/2022 07:53, Simonov Denis via Firebird-devel wrote:
> 23.08.2022 13:38, Norbert Saint Georges пишет:
>> Simonov Denis via Firebird-devel a écrit :
>>> SQL> connect inet://localhost:3055/employee user SYSDBA password
>>> 'masterkey';
>>> Database: inet://localhost:3055/employee, User: SYSDBA
>>> SQL> select rdb$profiler.start_session('Profile Session 1') from
>>> rdb$database;
>>>
>>>          START_SESSION
>>> =====================
>>> Statement failed, SQLSTATE = HY000
>>> Profiler plugin  is not found
>>> -At function 'RDB$PROFILER.START_SESSION'
>>> SQL>
>>
>> Server Version: LI-T5.0.0.681 Firebird 5.0 Initial
>> this ok :-)
>>
> 
> This is because the Windows build does not have the
> plugins/Default_Profiler.dll dynamic library, while the Linux build does
> have the plugins/libDefault_Profiler.so library.
> 

Should be fixed in next snapshot.


Adriano

Re: [Firebird-devel] (possible) Database header

[Tommi P. <tom...@su...>]

Dang...

Try to use GStat instead.

-Tee-

-----Original Message-----
From: Dimitry Sibiryakov <sd...@ib...> 
Sent: Tuesday, August 23, 2022 1:11 PM
To: For discussion among Firebird Developers <fir...@li...>
Subject: Re: [Firebird-devel] (possible) Database header

Tommi Prami wrote 23.08.2022 5:40:
> I was thinking that if there is some kind of header (simple enough) in 
> Firebird Databases and/or backup files, maybe some one could point me 
> into the right direction.

   No. Of course Firebird database has header page described in ods.h but it has no signature and even "fixed" part is unstable between versions. The utility must read whole fist kilobyte and try to map that data to several expected header versions checking whether several fields has sane values.

-- 
   WBR, SD.


Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Profiler plugin is not found. Windows snapshot Firebird-5.0.0.684-0-x64

[Simonov D. <sim...@li...>]

23.08.2022 13:38, Norbert Saint Georges пишет:
> Simonov Denis via Firebird-devel a écrit :
>> SQL> connect inet://localhost:3055/employee user SYSDBA password 
>> 'masterkey';
>> Database: inet://localhost:3055/employee, User: SYSDBA
>> SQL> select rdb$profiler.start_session('Profile Session 1') from 
>> rdb$database;
>>
>>          START_SESSION
>> =====================
>> Statement failed, SQLSTATE = HY000
>> Profiler plugin  is not found
>> -At function 'RDB$PROFILER.START_SESSION'
>> SQL>
> 
> Server Version: LI-T5.0.0.681 Firebird 5.0 Initial
> this ok :-)
> 

This is because the Windows build does not have the 
plugins/Default_Profiler.dll dynamic library, while the Linux build does 
have the plugins/libDefault_Profiler.so library.

Re: [Firebird-devel] Profiler plugin is not found. Windows snapshot Firebird-5.0.0.684-0-x64

[Norbert S. G. <ns...@te...>]

Simonov Denis via Firebird-devel a écrit :
> SQL> connect inet://localhost:3055/employee user SYSDBA password 'masterkey';
> Database: inet://localhost:3055/employee, User: SYSDBA
> SQL> select rdb$profiler.start_session('Profile Session 1') from 
> rdb$database;
>
>          START_SESSION
> =====================
> Statement failed, SQLSTATE = HY000
> Profiler plugin  is not found
> -At function 'RDB$PROFILER.START_SESSION'
> SQL>

Server Version: LI-T5.0.0.681 Firebird 5.0 Initial
this ok :-)

-- 
Norbert Saint Georges
http://tetrasys.fi

Re: [Firebird-devel] (possible) Database header

[Dimitry S. <sd...@ib...>]

Tommi Prami wrote 23.08.2022 5:40:
> I was thinking that if there is some kind of header (simple enough) in Firebird 
> Databases and/or backup files, maybe some one could point me into the right 
> direction.

   No. Of course Firebird database has header page described in ods.h but it has 
no signature and even "fixed" part is unstable between versions. The utility 
must read whole fist kilobyte and try to map that data to several expected 
header versions checking whether several fields has sane values.

-- 
   WBR, SD.

[Firebird-devel] Profiler plugin is not found. Windows snapshot Firebird-5.0.0.684-0-x64

[Simonov D. <sim...@li...>]

SQL> connect inet://localhost:3055/employee user SYSDBA password 
'masterkey';
Database: inet://localhost:3055/employee, User: SYSDBA
SQL> select rdb$profiler.start_session('Profile Session 1') from 
rdb$database;

         START_SESSION
=====================
Statement failed, SQLSTATE = HY000
Profiler plugin  is not found
-At function 'RDB$PROFILER.START_SESSION'
SQL>

Re: [Firebird-devel] (possible) Database header

[Roman S. <rom...@gm...>]

gstat -h

вт, 23 авг. 2022 г. в 07:15, Tommi Prami <tom...@su...>:
>
> Hello,
>
>
>
> I was thinking that if there is some kind of header (simple enough) in Firebird Databases and/or backup files, maybe some one could point me into the right direction.
>
> I would preferably need (mainly for installer) small tool that would check the ODS version of the DB before I try to connect into it. And depending on that, do some preprocessing if needed or make some other choices based upon that.
>
> Currently I open the database and detect ODS version that way, but it makes life bit too complicated.
>
>
>
> -Tee-
>
> Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel



-- 
Роман Симаков

[Firebird-devel] (possible) Database header

[Tommi P. <tom...@su...>]

Hello,

I was thinking that if there is some kind of header (simple enough) in Firebird Databases and/or backup files, maybe some one could point me into the right direction.

I would preferably need (mainly for installer) small tool that would check the ODS version of the DB before I try to connect into it. And depending on that, do some preprocessing if needed or make some other choices based upon that.

Currently I open the database and detect ODS version that way, but it makes life bit too complicated.

-Tee-

Re: [Firebird-devel] Release build, snapshot, GitHub CI, AppVeyor

[Adriano d. S. F. <adr...@gm...>]

On 22/08/2022 08:24, Gabor Boros wrote:
> Hi All,
> 
> Isn't that too much?
> In Gabor's ideal world..., GitHub CI "from a branch"=snapshot, "from a
> tag"=release. :-)
> 
> It's just a technical question from me, not more not less.
> For example if release and snapshot use the same build infrastructure
> (compiler, etc.) is good. Or not? :-) (Now the actual/snapshot builds
> come from / available at three different places.)
> 

It's about build tools versions, needed work, resistance to changes, etc.

You can consider AppVeyor as just another place doing builds with
different tools versions, which is good for portability.

GitHub Actions is currently considered as a way to validate our builds
with different tools versions. A downside is that github login is
necessary for download and URLs are not stable - this is bad for automation.

Now you have one more place to look:
https://github.com/FirebirdSQL/snapshots/releases/tag/snapshot-master

It stores (unofficial - until/if the team decides it's official) daily
snapshots for the master branch with stable URL without a need to login.


Adriano

[Firebird-devel] Release build, snapshot, GitHub CI, AppVeyor

[Gabor B. <mln...@bg...>]

Hi All,

Isn't that too much?
In Gabor's ideal world..., GitHub CI "from a branch"=snapshot, "from a 
tag"=release. :-)

It's just a technical question from me, not more not less.
For example if release and snapshot use the same build infrastructure 
(compiler, etc.) is good. Or not? :-) (Now the actual/snapshot builds 
come from / available at three different places.)

Gabor

Re: [Firebird-devel] Named parameters in client libraries

[Jiří Č. <ji...@ci...>]

> Does it have something like JDBC's ParameterMetaData?

No. Only https://docs.microsoft.com/en-us/dotnet/api/system.data.common.dbparameter?view=net-6.0#properties. But this is purely in hands of developer, no connection to what's in database. 

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

Re: [Firebird-devel] Purpose of op_batch_sync

[Alex P. <pes...@ma...>]

On 8/19/22 19:02, Mark Rotteveel wrote:
> On 19-08-2022 17:30, Alex Peshkoff via Firebird-devel wrote:
>> On 8/19/22 18:24, Mark Rotteveel wrote:
>>> It looks like op_batch_sync is just used to force the client to send 
>>> the deferred messages to the server, and the server to send the 
>>> deferred responses. Is that correct?
>>>
>>
>> exactly
>
> So, just for confirmation, using op_ping (which I found earlier as a 
> trick to get the server to send deferred messages) is a similar solution?
>

May be - never tried :)

Re: [Firebird-devel] Purpose of op_batch_sync

[Mark R. <ma...@la...>]

On 19-08-2022 17:30, Alex Peshkoff via Firebird-devel wrote:
> On 8/19/22 18:24, Mark Rotteveel wrote:
>> It looks like op_batch_sync is just used to force the client to send 
>> the deferred messages to the server, and the server to send the 
>> deferred responses. Is that correct?
>>
> 
> exactly

So, just for confirmation, using op_ping (which I found earlier as a 
trick to get the server to send deferred messages) is a similar solution?

Mark
-- 
Mark Rotteveel

Re: [Firebird-devel] Purpose of op_batch_sync

[Alex P. <pes...@ma...>]

On 8/19/22 18:24, Mark Rotteveel wrote:
> It looks like op_batch_sync is just used to force the client to send 
> the deferred messages to the server, and the server to send the 
> deferred responses. Is that correct?
>

exactly

[Firebird-devel] Purpose of op_batch_sync

[Mark R. <ma...@la...>]

It looks like op_batch_sync is just used to force the client to send the 
deferred messages to the server, and the server to send the deferred 
responses. Is that correct?

Mark
-- 
Mark Rotteveel

Re: [Firebird-devel] Build master branch with VS 2019

[Vlad K. <hv...@op...>]

19.08.2022 15:04, Gabor Boros wrote:
> 2022.08.19. 12:31 keltezéssel, Vlad Khorsun írta:
...
>>    At last, ensure your .bat files contains Windows-style EOL's (crlf), not Unix style.
> 
> 
> (I used "Code/Download ZIP" at GitHub to fetch the source.)
> 
> Build works after bought an unix2dos lifetime license. :-) Thank You!

   Happy testing ;)

> In output_x64_release directory I have common_test.exe and engine_test.exe. Is it normal? I cannot check the snapshot build because 
> "Connection timed out" (http://web.firebirdsql.org/download/snapshot_builds/win/5.0).

   Yes, it is normal.

Regards,
Vlad

Re: [Firebird-devel] Build master branch with VS 2019

[Gabor B. <mln...@bg...>]

2022.08.19. 14:24 keltezéssel, Mark Rotteveel írta:
> 
> You can also download snapshots from 
> https://github.com/FirebirdSQL/firebird/actions/workflows/main.yml (e.g. 
> use one built from master)


https://github.com/FirebirdSQL/firebird/actions/runs/2889248978#artifacts

"firebird-windows-vs-2019-x64-zip" not have *_test.exe.
In the artifact "README.intl.txt" etc. and the self-made build have 
"README.intl" etc. (Some "README." have the txt extension some not in 
the self-made build.) Not big problems for me, just try to compare the 
official and the self-made...

Gabor

Re: [Firebird-devel] Build master branch with VS 2019

[Mark R. <ma...@la...>]

On 19-08-2022 14:04, Gabor Boros wrote:
> In output_x64_release directory I have common_test.exe and 
> engine_test.exe. Is it normal? I cannot check the snapshot build because 
> "Connection timed out" 
> (http://web.firebirdsql.org/download/snapshot_builds/win/5.0).

You can also download snapshots from 
https://github.com/FirebirdSQL/firebird/actions/workflows/main.yml (e.g. 
use one built from master)

Mark
-- 
Mark Rotteveel

Re: [Firebird-devel] Build master branch with VS 2019

[Gabor B. <mln...@bg...>]

2022.08.19. 12:31 keltezéssel, Vlad Khorsun írta:
> 
>    Here is missed lines about preprocessing of dsql/metd.epp, 
> dsql/DdlNodes.epp and dsql/PackageNodes.epp
> Check, please, presence of src/dsql/*.epp files


r:\firebird-master\src\dsql\DdlNodes.epp
r:\firebird-master\src\dsql\metd.epp
r:\firebird-master\src\dsql\PackageNodes.epp

> 
>    Also, ensure your preprocess.bat contains following line:
> 
> @for %%i in (metd, DdlNodes, PackageNodes) do @call :PREPROCESS dsql %%i 
> -gds_cxx    <<< HERE


I have it.

>    At last, ensure your .bat files contains Windows-style EOL's (crlf), 
> not Unix style.


(I used "Code/Download ZIP" at GitHub to fetch the source.)

Build works after bought an unix2dos lifetime license. :-) Thank You!

In output_x64_release directory I have common_test.exe and 
engine_test.exe. Is it normal? I cannot check the snapshot build because 
"Connection timed out" 
(http://web.firebirdsql.org/download/snapshot_builds/win/5.0).

Gabor

Re: [Firebird-devel] Build master branch with VS 2019

[Vlad K. <hv...@op...>]

19.08.2022 13:36, Mark Rotteveel wrote:
> On 19-08-2022 12:31, Vlad Khorsun wrote:
>>    At last, ensure your .bat files contains Windows-style EOL's (crlf), not Unix style.
> 
> The repository should contain a .gitattributes file that configures this. I was a bit surprised to see use of unix2dos in the GitHub 
> actions workflow to ensure this for the batch files.

   Me too ;)

Regards,
Vlad

Re: [Firebird-devel] Build master branch with VS 2019

[Mark R. <ma...@la...>]

On 19-08-2022 12:31, Vlad Khorsun wrote:
>    At last, ensure your .bat files contains Windows-style EOL's (crlf), 
> not Unix style.

The repository should contain a .gitattributes file that configures 
this. I was a bit surprised to see use of unix2dos in the GitHub actions 
workflow to ensure this for the batch files.

Mark
-- 
Mark Rotteveel