[Firebird-devel] Building Firebird Sql is now easy with Github Codespaces

[marius adrian popa]

Building Firebird Sql is now easy with Github Codespaces (default is ubuntu
lts + vscode)
choose a branch
click Code
create code space
sudo apt-get update
sudo apt-get install libtommath-dev libtomcrypt-dev
./autogen.sh --prefix=/opt/firebird4 or 5
make
make install

https://github.com/features/codespaces

Also there is prebuild for open source organizations
https://github.surveymonkey.com/r/2X56RCW
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Builds for ARM64

[marius adrian popa]

Also macos arm builds would be nice :)

On Tue, Jul 12, 2022 at 3:47 PM Jiří Činčura  wrote:

> Hi *,
>
> Is there an ongoing effort to have ARM64 (I'm asking primarily for ARM64
> on Windows, but Linux would be welcome as well) builds available for
> download?
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Amorphous White Paper

[marius adrian popa]

Related post from Jim
https://www.linkedin.com/pulse/amorphousdb-rethinking-relational-database-jim-starkey/

On Sat, Apr 2, 2022 at 10:22 PM Jim Starkey  wrote:

> With due recognition that it is not strictly Firebird related, Ann and I
> finally put together a white paper on what I've been working on for
> close to the last decade.  It's less of an attack on the relational data
> model than the sowing possibilities of relaxing the various dogmas of
> the relational data model. So take it as a collection of seriously
> heretical ideas that may -- or may not -- have influence on Firebird
> going forward.  Things that might be particularly interesting are the
> API and security model. Sublists would be a huge boon, but probably
> impossible to shoehorn into SQL.
>
> It's quite interesting comparing the advances in computing platforms --
> a Raspberry Pi is well more than 5,000 times the performance of the VAX
> 780 on which I wrote the original JRD to advances in thinking about data
> and database systems -- basically none.
>
> I'm be more than happy to discuss the ideas, maybe even some issues
> around implementation.  Just don't ask what I plan to do with, 'cause at
> the moment I haven't a clue.
>
> Enjoy -- or not.
>
> --
> Jim Starkey, AmorphousDB, LLC
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Fw: [firebird-support] ARM64 Support

[marius adrian popa]

One example for firebird 3.0 requirements
sudo apt-get build-dep firebird3.0
./configure
make
you can study the dev dependencies here
https://packages.ubuntu.com/source/focal/firebird3.0


for 4.0 see the above dependencies

git clone https://github.com/FirebirdSQL/firebird.git
git checkout v4.0-release
./autogen --with-builtin-tomcrypt
make
make install




On Wed, Apr 20, 2022 at 5:55 PM Alex Peshkoff via Firebird-devel <
firebird-devel@lists.sourceforge.net> wrote:

> On 19.04.2022 20:06, Hugo Larson via Firebird-devel wrote:
> > Hi,
> >
> > I want to build FB4 for Linux (Ubuntu) arm64 and wonder if there is
> > documentation with instructions?
> >
>
> Nothing special. I've tried that build a year or so ago, it builds w/o
> any special measures.
>
> ./configure
> make
>
> Certainly required dev (important for ubuntu) packages should be installed.
>
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Build for WASM

[marius adrian popa]

Also discussion on HackerNews https://news.ycombinator.com/item?id=30356020

On Wed, Feb 23, 2022 at 5:21 PM marius adrian popa  wrote:

> There are some patches to run Libreoffice on WASM
> https://wiki.documentfoundation.org/Development/WASM
>
> Still experimental but somehow works in the browser
> https://www.theregister.com/2022/02/19/webassembly_port_libreoffice/
>
> On Wed, Feb 23, 2022 at 11:41 AM Jiří Činčura  wrote:
>
>> > You mean, running in the browser?
>>
>> Yes. Or any other place where WASM is/will be supported.
>>
>> --
>> Mgr. Jiří Činčura
>> https://www.tabsoverspaces.com/
>>
>>
>>
>> Firebird-Devel mailing list, web interface at
>> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>>
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Build for WASM

[marius adrian popa]

There are some patches to run Libreoffice on WASM
https://wiki.documentfoundation.org/Development/WASM

Still experimental but somehow works in the browser
https://www.theregister.com/2022/02/19/webassembly_port_libreoffice/

On Wed, Feb 23, 2022 at 11:41 AM Jiří Činčura  wrote:

> > You mean, running in the browser?
>
> Yes. Or any other place where WASM is/will be supported.
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Visual Studio 2022 now available

[marius adrian popa]

https://devblogs.microsoft.com/visualstudio/visual-studio-2022-now-available/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] SRP Is Now Deprecated

[marius adrian popa]

https://news.ycombinator.com/item?id=28802559
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Better JSON in Postgres with PostgreSQL 14

[marius adrian popa]

Better JSON in Postgres with PostgreSQL 14

https://blog.crunchydata.com/blog/better-json-in-postgres-with-postgresql-14
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] 64 bit arm buildx/qemu issues for docker

[marius adrian popa]

Seems that there are still issues with ubuntu 20.04 on arm64
https://github.com/jacobalberty/firebird-docker/issues/67#issuecomment-875220239

On Sat, Jul 3, 2021 at 3:56 AM Adriano dos Santos Fernandes <
adrian...@gmail.com> wrote:

> On 02/07/2021 16:14, marius adrian popa wrote:
> > We try to build / push docker images for arm64 on linux
> >
> >
> https://docs.docker.com/desktop/multi-arch/#build-multi-arch-images-with-buildx
> > <
> https://docs.docker.com/desktop/multi-arch/#build-multi-arch-images-with-buildx
> >
> >
> > And we get one error
> >
> https://github.com/jacobalberty/firebird-docker/issues/67#issuecomment-872701094
> > <
> https://github.com/jacobalberty/firebird-docker/issues/67#issuecomment-872701094
> >
> >
> > 32bit version seems to be fine already pushed to docker hub
> >
>
> I had recently build v4.0.0 in a Raspberry Pi 4 hardware.
>
> My first try was with Raspbian 32 bit and it failed (AFAIR) here:
> fb_assert(header->data->is_lock_free());
>
> With Ubuntu 20.04 64 bit everything seems to work fine.
>
>
> Adriano
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] 64 bit arm buildx/qemu issues for docker

[marius adrian popa]

We try to build / push docker images for arm64 on linux

https://docs.docker.com/desktop/multi-arch/#build-multi-arch-images-with-buildx

And we get one error
https://github.com/jacobalberty/firebird-docker/issues/67#issuecomment-872701094

32bit version seems to be fine already pushed to docker hub
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Setting up Github cpp code scanning for a repository

[marius adrian popa]

https://docs.github.com/en/code-security/secure-coding/automatically-scanning-your-code-for-vulnerabilities-and-errors/setting-up-code-scanning-for-a-repository

Here is how is setup for flamerobin

https://github.com/mariuz/flamerobin/blob/master/.github/workflows/codeql-analysis.yml
via

https://github.com/CollaboraOnline/online/blob/master/.github/workflows/codeql-analysis.yml
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] The issue tracker for the Firebird core move is done ?

[marius adrian popa]

The issue tracker for the Firebird documentation has moved to github issues
Also i see the Firebird CORE and the other projects are moved Web/QA...
It's done ? :)
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] firebird.msg missing in Firebird 4.0 Android builds

[marius adrian popa]

The Android Firebird 4.0 download comes without this file (spotted in this
article)

https://sourceforge.net/p/zeoslib/wiki/How%20to%20use%20Firebird%204.0%20RC1%20with%20Zeos%20on%20Android/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] LibreOffice Patch : Can't use System V semaphores in a sandboxed macOS process

[marius adrian popa]

Interesting patch for LibreOffice

https://git.libreoffice.org/core/+/22e89d2ccd3ad3ee1b5ee00aebadd3d5a38fd5dd%5E%21
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Browse GitHub FirebirdSQL code with VS Code read only

[marius adrian popa]

One way to browse GitHub FirebirdSQL code is using this url to read GitHub
code with VS Code (read only)

https://github1s.com/firebirdsql/firebird

via HackerNews

https://news.ycombinator.com/item?id=26083919
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Usage of 32b version of Firebird

[marius adrian popa]

Current Ubuntu LTS  is 64 bit , only with selected packages for 32 bit apps
(Thanks to Steam and Wine apps)
https://www.omgubuntu.co.uk/2019/06/ubuntu-is-dropping-all-32-bit-support-going-forward
Even FreeBSD moved i386 to Tier 2 for FreeBSD 13.x
https://lists.freebsd.org/pipermail/freebsd-announce/2021-January/002006.html

So in the end my guess 32 bit is only for legacy apps (Think Delphi apps
without source code ... )


On Tue, Feb 2, 2021 at 11:17 AM Paul Reeves  wrote:

> On Tue, 2 Feb 2021 11:32:42 +0300
> Alex Peshkoff via Firebird-devel 
> wrote:
>
> > On 2/1/21 10:24 PM, marius adrian popa wrote:
> > > My guess old cpus or installs
> > >
> > > Example got laptop with Windows 10 32 that is still supported by >
> > > Microsoft also have an old laptop with Ubuntu 32bit also another old >
> > > raspberry pi that is 32 bit only
> >
> > I doubt all that list is worth having _new_ versions 32 bit.
> >
> >
> >
> > Firebird-Devel mailing list, web interface at
> > https://lists.sourceforge.net/lists/listinfo/firebird-devel
> >
>
> Presumably the original question implied x86 rather than 32-bit in general.
>
> I doubt that our user base for 32-bit ARM is really very significant but
> 32-bit ARM chips probably have a good future ahead of them. 32-bit x86
> chips
> seem to largely have gone the way of 16-bit x86.
>
> I certainly ask myself the question about x86 quite frequently. I can see a
> reason for maintaining support in the code base but I find it hard to
> justify
> producing official x86 binaries for new versions of Firebird.
>
>
> Paul
> --
>
> Paul Reeves
> http://www.ibphoenix.com
> Supporting users of Firebird
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Usage of 32b version of Firebird

[marius adrian popa]

https://www.backblaze.com/blog/64-bit-os-vs-32-bit-os/

I like this quote :
"You might be asking -> why do I care? Why does Brian want Microsoft to
stop shipping an Operating System that is likely only chosen by mistake? My
problem is this: Backblaze, like any good technology vendor, wants to be
easy to use and friendly. In this case, that means we need to quietly,
invisibly, continue to support BOTH the 32-bit and the 64-bit versions of
every Microsoft OS they release. And we’ll probably need to do this for at
least 5 years AFTER Microsoft officially retires the 32-bit only version of
their operating system."

Also Microsoft stopped shipping windows 32 bit to OEM but you can still
install on your own workstations

https://www.engadget.com/windows-10-32-bit-oem-173055990.html

On Tue, Feb 2, 2021 at 10:33 AM Alex Peshkoff via Firebird-devel <
firebird-devel@lists.sourceforge.net> wrote:

> On 2/1/21 10:24 PM, marius adrian popa wrote:
> > My guess old cpus or installs
> >
> > Example got laptop with Windows 10 32 that is still supported by
> > Microsoft also have an old laptop with Ubuntu 32bit also another old
> > raspberry pi that is 32 bit only
> >
>
> I doubt all that list is worth having _new_ versions 32 bit.
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] SIO_LOOPBACK_FAST_PATH deprecated

[marius adrian popa]

Seems that is just a warning , googling about it and they offer no
alternative to replace it

https://stackoverflow.com/questions/57610475/sio-loopback-fast-path-replacement


On Mon, Feb 1, 2021 at 21:47 Vlad Khorsun  wrote:

> 26.01.2021 19:48, Jiří Činčura wrote:
> > Hi *,
> >
> > I'm reading the docs for SIO_LOOPBACK_FAST_PATH (
> https://docs.microsoft.com/en-us/windows/win32/winsock/sio-loopback-fast-path)
> and I see it's deprecated (even in WDK
> https://docs.microsoft.com/en-us/windows-hardware/drivers/network/sio-loopback-fast-path).
>
>
>Good joke, Microsoft...
>
> > Would it make sense to remove this feature from FB4?
>
>I don't think so. It is too late, imho, and we already have setting to
> disable it.
> But we can change default value to false, if it is required. And I don't
> remember
> any complains about it.
>
> Regards,
> Vlad
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Usage of 32b version of Firebird

[marius adrian popa]

My guess old cpus or installs

Example got laptop with Windows 10 32 that is still supported by Microsoft
also have an old laptop with Ubuntu 32bit also another old raspberry pi
that is 32 bit only



For new inst

On Mon, Feb 1, 2021 at 11:57 Jiří Činčura  wrote:

> Hi *,
>
> if you're using 32b version of Firebird can you respond what's the reason
> (just researching, not judging)?
>
> --
> Mgr. Jiří Činčura
> https://www.tabsoverspaces.com/
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Visual Studio Faster C++ Iteration Builds

[marius adrian popa]

Visual Studio Faster C++ Iteration Builds

https://devblogs.microsoft.com/cppblog/faster-c-iteration-builds/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] How to build for Android 64 bit

[marius adrian popa]

@Henri Gourvest   mentioned that

Currently, the ARMv5 build is not suitable because Google requires to
package the APK for 4 architectures (ArmV7, ArmV8, x86 & x86_64) on the
Play Store.

https://developer.android.com/ndk/guides/abis

On Fri, Dec 11, 2020 at 8:17 PM marius adrian popa  wrote:

> Hello Alex ,
> For android i see that firebird 3.0.7 builds ok (there are arm binaries on
> firebirdsql)
> What ndk do you recommend?
>
> On Tue, Aug 25, 2020 at 10:36 AM Alex Peshkoff via Firebird-devel <
> firebird-devel@lists.sourceforge.net> wrote:
>
>> On 2020-08-24 23:34, marius adrian popa wrote:
>> > Tested with 3.0 branch and fails at one moment
>> > export NDK=$HOME/android-ndk-r17c
>> > ./autogen.sh --prefix=/opt/firebird --enable-binreloc
>> > --with-cross-build=android.arm64 --without-editline
>> >  --with-builtin-tommath
>> >
>> > make yvalve
>> > make[4]: Entering directory '/home/ubuntu/firebird/gen'
>> >
>> /home/ubuntu/android-ndk-r17c/toolchains/aarch64-linux-android-4.9/prebuilt/linux-x86_64/bin/aarch64-linux-android-g++
>>
>> > -I/home/ubuntu/firebird/src/include/gen
>> > -I/home/ubuntu/firebird/src/include  -ggdb
>> > -DFB_SEND_FLAGS=MSG_NOSIGNAL -DLINUX -DANDROID -DARM64 -pipe -MMD
>> > -fPIC -fmessage-length=0 -I/home/ubuntu/firebird/extern/libtommath
>> > --sysroot=/home/ubuntu/android-ndk-r17c/platforms/android-24/arch-arm64
>> >
>> -I/home/ubuntu/android-ndk-r17c/platforms/android-24/arch-arm64/usr/include
>> > -I/home/ubuntu/firebird/gen/cross -fsigned-char
>> > -fno-omit-frame-pointer -I/home/ubuntu/firebird/extern/libtommath
>> > -pthread -fno-rtti -c
>> > /home/ubuntu/firebird/src/yvalve/MasterImplementation.cpp -o
>> > /home/ubuntu/firebird/temp/Release/yvalve/MasterImplementation.o
>> > In file included from /home/ubuntu/firebird/src/include/firebird.h:70:0,
>> >  from
>> > /home/ubuntu/firebird/src/yvalve/MasterImplementation.cpp:29:
>> > /home/ubuntu/firebird/src/include/../common/common.h:53:20: fatal
>> > error: string.h: No such file or directory
>> >  #include 
>> > ^
>> > compilation terminated.
>>
>> Yes - unfortunately we have problems with android port. Last for sure
>> buildable trio was fb305 + arme + ndk-r10d.
>>
>> We can not use that ndk any more cause some support of c++ was broken in
>> it. I plan to resolve issues with android, but can't provide time frames.
>>
>>
>>
>>
>> Firebird-Devel mailing list, web interface at
>> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>>
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] How to build for Android 64 bit

[marius adrian popa]

Hello Alex ,
For android i see that firebird 3.0.7 builds ok (there are arm binaries on
firebirdsql)
What ndk do you recommend?

On Tue, Aug 25, 2020 at 10:36 AM Alex Peshkoff via Firebird-devel <
firebird-devel@lists.sourceforge.net> wrote:

> On 2020-08-24 23:34, marius adrian popa wrote:
> > Tested with 3.0 branch and fails at one moment
> > export NDK=$HOME/android-ndk-r17c
> > ./autogen.sh --prefix=/opt/firebird --enable-binreloc
> > --with-cross-build=android.arm64 --without-editline
> >  --with-builtin-tommath
> >
> > make yvalve
> > make[4]: Entering directory '/home/ubuntu/firebird/gen'
> >
> /home/ubuntu/android-ndk-r17c/toolchains/aarch64-linux-android-4.9/prebuilt/linux-x86_64/bin/aarch64-linux-android-g++
>
> > -I/home/ubuntu/firebird/src/include/gen
> > -I/home/ubuntu/firebird/src/include  -ggdb
> > -DFB_SEND_FLAGS=MSG_NOSIGNAL -DLINUX -DANDROID -DARM64 -pipe -MMD
> > -fPIC -fmessage-length=0 -I/home/ubuntu/firebird/extern/libtommath
> > --sysroot=/home/ubuntu/android-ndk-r17c/platforms/android-24/arch-arm64
> >
> -I/home/ubuntu/android-ndk-r17c/platforms/android-24/arch-arm64/usr/include
> > -I/home/ubuntu/firebird/gen/cross -fsigned-char
> > -fno-omit-frame-pointer -I/home/ubuntu/firebird/extern/libtommath
> > -pthread -fno-rtti -c
> > /home/ubuntu/firebird/src/yvalve/MasterImplementation.cpp -o
> > /home/ubuntu/firebird/temp/Release/yvalve/MasterImplementation.o
> > In file included from /home/ubuntu/firebird/src/include/firebird.h:70:0,
> >  from
> > /home/ubuntu/firebird/src/yvalve/MasterImplementation.cpp:29:
> > /home/ubuntu/firebird/src/include/../common/common.h:53:20: fatal
> > error: string.h: No such file or directory
> >  #include 
> > ^
> > compilation terminated.
>
> Yes - unfortunately we have problems with android port. Last for sure
> buildable trio was fb305 + arme + ndk-r10d.
>
> We can not use that ndk any more cause some support of c++ was broken in
> it. I plan to resolve issues with android, but can't provide time frames.
>
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Fix Firebird build on macOS on arm64

[marius adrian popa]

Interesting fix for Libreoffice on macOS on arm64
https://cgit.freedesktop.org/libreoffice/core/commit/external/firebird?id=a470932949c3e8ee28aaf77a71a90a957bbfe1ce

via Firebird patches for LibreOffice

https://cgit.freedesktop.org/libreoffice/core/log/external/firebird
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] use applications with new firebird server

[marius adrian popa]

Also you can read more in this paper  : Authentication in Firebird 3
https://www.firebirdsql.org/en/news/read-authentication-in-firebird-3/

On Tue, Nov 24, 2020 at 4:20 PM Alex Peshkoff via Firebird-devel <
firebird-devel@lists.sourceforge.net> wrote:

> On 11/24/20 5:13 PM, Ismael L. Donis Garcia wrote:
> > Are those adjustments documented somewhere?
> >
>
> Yes, mostly in FB3 release notes - there is no big difference between
> FB3 & 4 from this POV. But read also about backwards compatibility in
> FB4 release notes too.
>
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] JSONB in PostgreSQL

[marius adrian popa]

Interesting presentation from pgcon

https://www.pgcon.org/events/pgcon_2020/schedule/session/139-jsonb-roadmap/

related to this feature
http://tracker.firebirdsql.org/browse/CORE-5148
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Jira 3-13 is EOL

[marius adrian popa]

https://confluence.atlassian.com/jirakb/blog/2011/08/jira-3-13-end-of-life

Maybe is time to migrate to github issues
https://spring.io/blog/2019/01/15/spring-framework-s-migration-from-jira-to-github-issues
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] OT : Postgres Observability Diagram

[marius adrian popa]

https://news.ycombinator.com/item?id=25058045

via twitter
https://twitter.com/samokhvalov/status/1326579896244527104
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] PostgreSQL 13 can efficiently handle duplicate data in B-tree indexes, the standard database index.

[marius adrian popa]

>From pg release notes
https://www.postgresql.org/about/news/postgresql-13-released-2077/
https://www.postgresql.org/docs/13/btree-implementation.html#BTREE-DEDUPLICATION

ps: I don't know if Firebird can be optimized in a similar
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Official Docker Images of Firebird

[marius adrian popa]

cmake is kind of standard for cross platform builds win/lin/mac
flamerobin switched to cmake
also microsoft seems that is pushing it
https://docs.microsoft.com/en-us/cpp/build/cmake-projects-in-visual-studio


Usually as user i prefer official blessed docker image , I give as example
postgresql
https://hub.docker.com/_/postgres


On Wed, Oct 14, 2020 at 7:40 PM Alex Peshkoff via Firebird-devel <
firebird-devel@lists.sourceforge.net> wrote:

> On 2020-10-11 00:16, Adriano dos Santos Fernandes wrote:
> > On 08/10/2020 08:18, Dev HrOokami wrote:
> >> Hello! I saw a talk here about official Firebird Docker Images and I am
> >> interested in. As my PR merged, there is already automated build for
> >> Alpine in GitHub Actions, both for FB 3 & 4 (but exclude 2.5). I can
> >> configure GH Actions to build Firebird Image and push it to DockerHub or
> >> GitHub Registry.
> >>
> > You may start discussing:
> > - Why Alpine and not Debian or Ubuntu?
> > - How would it be configured?
>
> I see another problem with docker images - who will support them? I do
> not want to have one more 'cmake build'-like feature., which is almost
> unsupported.
>
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] How to build for Android 64 bit

[marius adrian popa]

Tested with 3.0 branch and fails at one moment
export NDK=$HOME/android-ndk-r17c
./autogen.sh --prefix=/opt/firebird --enable-binreloc
--with-cross-build=android.arm64 --without-editline  --with-builtin-tommath

make yvalve
make[4]: Entering directory '/home/ubuntu/firebird/gen'
/home/ubuntu/android-ndk-r17c/toolchains/aarch64-linux-android-4.9/prebuilt/linux-x86_64/bin/aarch64-linux-android-g++
-I/home/ubuntu/firebird/src/include/gen -I/home/ubuntu/firebird/src/include
 -ggdb -DFB_SEND_FLAGS=MSG_NOSIGNAL -DLINUX -DANDROID -DARM64 -pipe -MMD
-fPIC -fmessage-length=0 -I/home/ubuntu/firebird/extern/libtommath
--sysroot=/home/ubuntu/android-ndk-r17c/platforms/android-24/arch-arm64
-I/home/ubuntu/android-ndk-r17c/platforms/android-24/arch-arm64/usr/include
-I/home/ubuntu/firebird/gen/cross -fsigned-char -fno-omit-frame-pointer
-I/home/ubuntu/firebird/extern/libtommath -pthread -fno-rtti   -c
/home/ubuntu/firebird/src/yvalve/MasterImplementation.cpp -o
/home/ubuntu/firebird/temp/Release/yvalve/MasterImplementation.o
In file included from /home/ubuntu/firebird/src/include/firebird.h:70:0,
 from
/home/ubuntu/firebird/src/yvalve/MasterImplementation.cpp:29:
/home/ubuntu/firebird/src/include/../common/common.h:53:20: fatal error:
string.h: No such file or directory
 #include 
^
compilation terminated.

On Mon, Aug 24, 2020 at 1:29 PM Alex Peshkoff via Firebird-devel <
firebird-devel@lists.sourceforge.net> wrote:

> On 2020-08-18 22:06, Karel Rys via Firebird-devel wrote:
> > Hello,
> >
> > I have an application for Android (runs on mobile phones and barcode
> > mobile scanners). Application is written in Delphi, uses Embedded
> > Firebird 3.0.6 and is build for 32 bit.
> > I would like to publish the application in Google Play, so I have to
> > build it for 64 bit Android, too.
> >
> > Please is there a binary build of Firebird 3 for Android 64 bit? Or
> > are there instructions so that I can build it myself? Unfortunatelly,
> > I have almost zero experience with builds of C++ and no tools for it
> > on my Windows machine, so binary version would be much easier to use,
> > but I am able to compile from source on linux (but never tried
> > cross-platform compilation there).
> >
>
> Time to try :-)
> Approximately this way:
>
> ./autogen.sh --prefix=/opt/firebird --enable-binreloc
> --with-cross-build=android.arm64 --without-editline && make
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] How to build for Android 64 bit

[marius adrian popa]

Thank you

>From ndk r18 gcc has been removed
(/home/ubuntu/android-ndk-r21d/toolchains//prebuilt/linux-x86_64/bin/aarch64-linux-android-gcc:
Command not found)

https://github.com/android/ndk/wiki/Changelog-r18

Here is the path for new llvm/clang binaries
https://developer.android.com/ndk/guides/other_build_systems
/home/ubuntu/android-ndk-r21d/toolchains/llvm/prebuilt/linux-x86_64/bin/





On Mon, Aug 24, 2020 at 2:50 PM Alex Peshkoff via Firebird-devel <
firebird-devel@lists.sourceforge.net> wrote:

> On 2020-08-24 14:28, marius adrian popa wrote:
> > Alex could you publish arm64 version on Firebird 3.0 download page ?
>
> I do not work with FB3 download page myself, I can just prepare binary
> and put into prerelease place.
>
>
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] How to build for Android 64 bit

[marius adrian popa]

Alex could you publish arm64 version on Firebird 3.0 download page ?

seems that 64bit is a requirement in google app store
https://developer.android.com/distribute/best-practices/develop/64-bit

On Mon, Aug 24, 2020 at 1:29 PM Alex Peshkoff via Firebird-devel <
firebird-devel@lists.sourceforge.net> wrote:

> On 2020-08-18 22:06, Karel Rys via Firebird-devel wrote:
> > Hello,
> >
> > I have an application for Android (runs on mobile phones and barcode
> > mobile scanners). Application is written in Delphi, uses Embedded
> > Firebird 3.0.6 and is build for 32 bit.
> > I would like to publish the application in Google Play, so I have to
> > build it for 64 bit Android, too.
> >
> > Please is there a binary build of Firebird 3 for Android 64 bit? Or
> > are there instructions so that I can build it myself? Unfortunatelly,
> > I have almost zero experience with builds of C++ and no tools for it
> > on my Windows machine, so binary version would be much easier to use,
> > but I am able to compile from source on linux (but never tried
> > cross-platform compilation there).
> >
>
> Time to try :-)
> Approximately this way:
>
> ./autogen.sh --prefix=/opt/firebird --enable-binreloc
> --with-cross-build=android.arm64 --without-editline && make
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] OO API examples for Object Pascal

[marius adrian popa]

I agree with Paul on this one , it would be nice for other languages
translation for the base api examples (JavaScript/Typescript)

and maybe some documentation so we can compare them


For full drivers you can use a packaged driver from npm , maven ...

ps: There is Firebird SQL Low Level api
https://github.com/asfernandes/node-firebird-drivers/tree/master/packages/node-firebird-native-api
also is recommended to use the High Level api wrapper
https://github.com/asfernandes/node-firebird-drivers/tree/master/packages/node-firebird-driver-native


pps: someone asked for JavaScript examples
https://twitter.com/swedenappz/status/1295918989944684546

On Tue, Aug 18, 2020 at 1:46 PM Paul Reeves 
wrote:

> On Mon, 17 Aug 2020 14:07:25 -0300
> Adriano dos Santos Fernandes  wrote:
>
> >
> > I'd say its correct place would be a new project under the FirebirdSQL
> > organization.
>
> I agree and disagree. Yes - if we create what essentially would be a driver
> written in object pascal. That should certainly be in a separate project.
>
> But for now all I want to do is just create object pascal based copies of
> the
> c++ examples. They belong in the kits with the other examples.
>
> I'm certainly not interested in creating a driver - at least, not at this
> stage. My interest at the moment is in improving the examples that we ship
> in
> the kits.
>
> > There is no Java, .Net, etc in core, so should not be Pascal examples
> > there, specially, as you have figured out, the API is not easy to be
> > directly used by application developers.
>
> I'm not sure that this logic is sound. Personally I'd like to see java
> and .Net examples distributed. And any others languages that can connect to
> Firebird. Why not, for example, have 03.select.java that demonstrates the
> minimum required to do a select in java AND produces identical results
> to 03.select.cpp?
>
>
> Paul
> --
>
> Paul Reeves
> http://www.ibphoenix.com
> Supporting users of Firebird
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Visual Studio Code C++ Extension July 2020 Update: Doxygen comments and Logpoints

[marius adrian popa]

https://devblogs.microsoft.com/cppblog/visual-studio-code-c-extension-july-2020-update-doxygen-comments-and-logpoints/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Optimizing 128-bit Division

[marius adrian popa]

https://news.ycombinator.com/item?id=23888177
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] How SHA-2 works step-by-step (SHA-256)

[marius adrian popa]

https://qvault.io/2020/07/08/how-sha-2-works-step-by-step-sha-256/

via HN
https://news.ycombinator.com/item?id=23839895
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Improving performance with SIMD intrinsics in three use cases

[marius adrian popa]

https://stackoverflow.blog/2020/07/08/improving-performance-with-simd-intrinsics-in-three-use-cases/


and hackernews

https://news.ycombinator.com/item?id=23772302
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Asci-doc language submitted to the Eclipse fundation

[marius adrian popa]

https://news.ycombinator.com/item?id=23711607
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] int128 datatype

[marius adrian popa]

so now we have int128 with this commit

https://github.com/FirebirdSQL/firebird/commit/c2692c6ceec2a434a23be920afc2d430a85e27cb?
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] CLOOP on Windows

[marius adrian popa]

with git submodules it could be included in the build system
https://github.blog/2016-02-01-working-with-submodules/

On Thu, Jun 11, 2020 at 4:54 PM Dimitry Sibiryakov  wrote:

>Hello All.
>
>Why compilation of CLOOP and generation of headers is not included in
> Windows build
> routine?
>
>
> --
>WBR, SD.
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Appveyor build

[marius adrian popa]

seems to be an temporary issue

master builds are ok for now
https://ci.appveyor.com/project/FirebirdSQL/firebird/history



On Fri, Jun 5, 2020 at 6:26 PM Dimitry Sibiryakov  wrote:

> 05.06.2020 17:22, Alex Peshkoff via Firebird-devel wrote:
> > Unavailable host:
> > 504  Gateway Time-out [IP: 52.38.12.101 443]
>
>I see following log there:
>
> > Build started
> > Fetching GitHub repository commit (c8dc3ee)...OK (59,793,710 bytes in
> 3090 files)
> > Running "install" scripts
> > export APT_PACKAGES="libtool-bin"
> > if [ $PLATFORM = "x64" ]; then export APT_PACKAGES="$APT_PACKAGES
> libtommath1 libtommath-dev libicu-dev zlib1g-dev"; fi
> > if [ $PLATFORM = "x86" ]; then export APT_PACKAGES="$APT_PACKAGES
> gcc-multilib g++-multilib libncurses5-dev:i386 libtommath-dev:i386
> libicu-dev:i386 zlib1g-dev:i386"; fi
> > if [ $PLATFORM = "x64" ]; then export CC="gcc" CXX="g++"; fi
> > if [ $PLATFORM = "x86" ]; then export CC="gcc -m32" CXX="g++ -m32"; fi
> > if [ $PLATFORM = "x86" ]; then export
> BUILD_FLAG=--build=i386-pc-linux-gnu; fi
> > sudo apt-get -y update
> > Hit:1 http://us.archive.ubuntu.com/ubuntu bionic InRelease
> > Get:2 https://download.docker.com/linux/ubuntu bionic InRelease [64.4
> kB]
> > Get:3 http://us.archive.ubuntu.com/ubuntu bionic-updates InRelease
> [88.7 kB]
> > Get:4 http://dl.google.com/linux/chrome/deb stable InRelease [1811 B]
> > Hit:5 http://download.virtualbox.org/virtualbox/debian bionic InRelease
> > Hit:6 http://download.mono-project.com/repo/ubuntu stable-bionic
> InRelease
> > Get:7 https://packages.cloud.google.com/apt cloud-sdk InRelease [6346 B]
> > Get:8 http://ppa.launchpad.net/ubuntu-mozilla-security/ppa/ubuntu
> bionic InRelease [15.4 kB]
> > Hit:9 https://dl.yarnpkg.com/debian stable InRelease
> > Get:10 http://us.archive.ubuntu.com/ubuntu bionic-backports InRelease
> [74.6 kB]
> > Get:13 https://packages.microsoft.com/ubuntu/18.04/prod bionic
> InRelease [4002 B]
> > Hit:14 https://packages.microsoft.com/ubuntu/16.04/mssql-server-2019
> xenial InRelease
> > Get:15 http://us.archive.ubuntu.com/ubuntu bionic-security InRelease
> [88.7 kB]
> > Get:16 https://packages.microsoft.com/repos/azure-cli bionic InRelease
> [3964 B]
> > Get:18 http://apt.postgresql.org/pub/repos/apt bionic-pgdg InRelease
> [84.6 kB]
> > Hit:11 https://apt.llvm.org/bionic llvm-toolchain-bionic-9 InRelease
> > Get:12 https://apt.llvm.org/bionic llvm-toolchain-bionic-10 InRelease
> [4232 B]
> > Get:19 https://download.docker.com/linux/ubuntu bionic/stable amd64
> Packages [12.1 kB]
> > Get:20 http://ppa.launchpad.net/git-core/ppa/ubuntu bionic InRelease
> [20.7 kB]
> > Get:21 http://dl.google.com/linux/chrome/deb stable/main amd64 Packages
> [1127 B]
> > Ign:22 https://dl.bintray.com/rabbitmq-erlang/debian bionic InRelease
> > Ign:23 https://dl.bintray.com/rabbitmq/debian bionic InRelease
> > Hit:17 https://packagecloud.io/github/git-lfs/ubuntu bionic InRelease
> > Hit:24 http://ppa.launchpad.net/openjdk-r/ppa/ubuntu bionic InRelease
> > Get:25 https://dl.bintray.com/rabbitmq-erlang/debian bionic Release
> [14.4 kB]
> > Get:26 http://us.archive.ubuntu.com/ubuntu bionic-updates/main i386
> Packages [685 kB]
> > Get:27 https://packages.cloud.google.com/apt cloud-sdk/main i386
> Packages [105 kB]
> > Get:28 http://ppa.launchpad.net/ubuntu-toolchain-r/test/ubuntu bionic
> InRelease [15.4 kB]
> > Get:29 https://packages.cloud.google.com/apt cloud-sdk/main amd64
> Packages [111 kB]
> > Get:30 http://us.archive.ubuntu.com/ubuntu bionic-updates/main amd64
> Packages [951 kB]
> > Get:31 http://us.archive.ubuntu.com/ubuntu bionic-updates/main
> Translation-en [324 kB]
> > Get:32 http://us.archive.ubuntu.com/ubuntu bionic-updates/restricted
> amd64 Packages [55.3 kB]
> > Get:33 http://us.archive.ubuntu.com/ubuntu bionic-updates/restricted
> Translation-en [13.8 kB]
> > Get:34 http://us.archive.ubuntu.com/ubuntu bionic-updates/universe i386
> Packages [1018 kB]
> > Get:35 http://us.archive.ubuntu.com/ubuntu bionic-updates/universe
> amd64 Packages [1077 kB]
> > Get:36 http://us.archive.ubuntu.com/ubuntu bionic-updates/universe
> Translation-en [335 kB]
> > Get:37 http://ppa.launchpad.net/ubuntu-mozilla-security/ppa/ubuntu
> bionic/main amd64 Packages [22.9 kB]
> > Get:38 https://packages.microsoft.com/ubuntu/18.04/prod bionic/main
> amd64 Packages [113 kB]
> > Get:39 https://packages.microsoft.com/repos/azure-cli bionic/main amd64
> Packages [9448 B]
> > Get:40 http://ppa.launchpad.net/ubuntu-mozilla-security/ppa/ubuntu
> bionic/main Translation-en [6696 B]
> > Get:41 http://us.archive.ubuntu.com/ubuntu bionic-security/main amd64
> Packages [727 kB]
> > Get:42 http://us.archive.ubuntu.com/ubuntu bionic-security/main i386
> Packages [474 kB]
> > Get:43 http://us.archive.ubuntu.com/ubuntu bionic-security/main
> Translation-en [230 kB]
> > Get:44 http://us.archive.ubuntu.com/ubuntu bionic-security/restricted
> amd64 Packages [45.7 kB]
> > Get:45 http://us.archive.ubuntu.com/ubuntu 

[Firebird-devel] Welcome back to C++ - Modern C++

[marius adrian popa]

https://docs.microsoft.com/en-us/cpp/cpp/welcome-back-to-cpp-modern-cpp?view=vs-2019
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] FB 3 & 4, new API and the ARRAY type

[marius adrian popa]

Why to remove the Array type ? , I see that Postgresql still provides it
https://www.postgresql.org/docs/current/arrays.html

On Wed, Apr 22, 2020 at 2:49 PM Pavel Cisar  wrote:

> Hi all,
>
> I'm writing new Python driver built using new FB3 API (mainly to get
> support for new features not available through old API). I was surprised
> that ARRAY type support in new API is incomplete and thus it's not
> possible to handle this data type in drivers/applications. Specifically,
> the API provides getSlice & putSlice methods on IAttachment, but there
> isn't any equivalent for very important isc_array_lookup_bounds function
> (isc_array_lookup_desc and isc_array_set_desc are also missing, but they
> are not important for driver developers).
>
> Alex explained to me, that array support is not functional in new API,
> because core developers are considering to deprecate & remove ARRAY type
> support from future Firebird versions. And because the final decision
> was not made yet, the arrays support in new API get stuck in incomplete
> state.
>
> Personally, I have no problem with deprecation of the ARRAY type, as
> this type is mostly not used (if at all) by Firebird users. Also, I
> understand the reasoning for missing methods that would pollute the
> interfaces with methods that would become eventually obsolete. However,
> I'm really stunned how this issue was handled.
>
> While it's ok to provide only new API for new features (like scrollable
> cursors), the NEW API SHOULD support all old Firebird features present
> in given version and available through old API. And ARRAY type is such a
> feature. Although it's probably not used much by Firebird users, it's
> still used in example EMPLOYEE database that's used a lot in books,
> articles etc., and support for it is available to end users via some
> drivers (like FDB Python driver) for many years. So it's definitely
> POSSIBLE, that users will run into situations when lack of ARRAY support
> will be at least awkward (missing output), if not straight fatal.
>
> Argument that one could always use old API to access ARRAYs will not
> stand, because some new features are not available through it, and they
> could not be used together. Users should NOT be forced to choose between
> two API's with distinct features, at least one should be the superset
> (preferably the new one).
>
> Also, if ARRAY type should be ever removed from Firebird, it should be
> done via proper deprecation process (that also includes creation of new
> example database without it). Hence I consider the lack of (at least)
> isc_array_lookup_bounds equivalent in new API as a serious BUG, that
> should be fixed in Firebird 3 & 4. As driver developer I would really
> appreciate if it would be fixed for 3.0.6 due in June.
>
> While ARRAY support is the pressing matter here, there are other old API
> functions that does not have new API replacements (for example
> isc_blob_lookup_desc, and many others). I think that it's the good time
> to compare old and new API's, and create a document that will contain
> table listing the Old API functions with their New API counterparts, or
> explanation why it was decided to not provide such equivalent in new
> API. Such document should be first discussed here (so we could decide
> whether to fix more new API bugs asap), and then become a part of
> Firebird documentation set (as driver developer, I was really surprised
> that such document does not exists yet, as it's invaluable for porting
> from old to new API).
>
> best regards
> Pavel Cisar
>
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Classic Semaphores Error 2.1

[marius adrian popa]

Yes it is possible to increase

LockSemCount

https://pmakowski.ibphoenix.fr/from-the-firebird-support-list-semaphores-exhausted.html

http://paulbeachsblog.blogspot.com/2009/06/some-positive-feedback-for-firebird.html


I recommend Firebird 2.5/3.0 with SuperClassic
https://firebirdsql.org/en/firebird-2-5/
https://firebirdsql.org/en/firebird-3-0/


Also you might check optimized configurations file options
https://firebirdsql.org/en/news/optimized-firebird-configuration-files-2nd-edition/



On Tue, Apr 14, 2020 at 7:57 PM Willian do Amor  wrote:

> OK thank you. @Alex
>
> Em ter., 14 de abr. de 2020 às 11:46, Alex Peshkoff via Firebird-devel <
> firebird-devel@lists.sourceforge.net> escreveu:
>
>> On 2020-04-14 16:45, Willian do Amor wrote:
>> > I have the dedicated database server running inside Hyper-V. This VM
>> > is running Ubuntu 18.04, with 32 GB of RAM, 8 virtual processor cores
>> > and 1 TB HD.
>> >
>> > The Firebird that runs on that server is Classic Server 2.1. I have
>> > only 4 databases on that machine. The number of users reaches a
>> > maximum of 100 at its peak.
>> >
>>
>> Willian, version 2.1 (and moreover - 2.5 too) is not supported by
>> community any more.
>>
>> > It so happened that over the course of a few days, the systems started
>> > to slow down and connections dropped. The firebird log stated that
>> > there were no more Semaphores available.
>> >
>> > Searching on google I found that I should increase the number of
>> > Semaphores for firebird according to what is available in the Linux
>> > kernel.
>> >
>> > I performed several tests and research, on a certain page that I don't
>> > remember now, a user said he had set 1024 Semaphores for firebird and
>> > that he also increased the maximum number in the kernel.
>> >
>> > I tried to use 1024 in my firebird settings and it showed an error in
>> > the logs stating that the number was not available on my system and
>> > that it was to set the value 64.
>> >
>> > I found through oracle database documentation that oracle uses the
>> > following configuration for its database in the Rad Hat Linux kernel
>> > (it's an example configuration)
>> >
>> > sysctl -w kernel.sem = "5010 641280 5010 128"
>> > I made this configuration on my server and set the Semaphores from
>> > firebird to 128. I realized that I got a much better performance
>> already.
>>
>> You should upgrade to at least 2.5 and forget about SystemV semaphores.
>> But if you really need for some reason keep using 2.1 please search for
>> paid support. Some companies provide it
>>
>>
>>
>>
>> Firebird-Devel mailing list, web interface at
>> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Format of sources download improvement

[marius adrian popa]

Postgresql also provides source code in bz2/gz format
https://www.postgresql.org/ftp/source/v12.2/

On windows i usually use 7zip so i guess an alternative can be provided if
needed

On Mon, Mar 23, 2020 at 9:44 AM marius adrian popa  wrote:

>
>
> bunzip2 comes by default in Ubuntu
>
> bunzip2: I won't read compressed data from a terminal.
> bunzip2: For help, type: `bunzip2 --help'.
>
> On Mon, Mar 23, 2020 at 9:31 AM Mark Rotteveel 
> wrote:
>
>> On 22-03-2020 20:13, Jiří Činčura wrote:
>> > Hi,
>> >
>> > is there a reason to keep providing sources in bz2 compression? I did a
>> quick comparison with 7z compression:
>> > Firebird-3.0.5.33220-0.7z: 8 230 662
>> > Firebird-3.0.5.33220-0.tar.bz2: 9 789 316
>> >
>> > Sure, it's not a huge file either way, but still the improvement is not
>> insignificant. And given the sources are expected to be used by experienced
>> users/developers, I don't think using 7z is adding any difficulty.
>> >
>>
>> As far as I know, use of tar and bz2 (bzip2) is relatively standard on
>> Linux environments, and even the most basic environments usually come
>> with the necessary tools to extract them. The same cannot be said for
>> 7zip as far as I'm aware.
>>
>> Mark
>> --
>> Mark Rotteveel
>>
>>
>> Firebird-Devel mailing list, web interface at
>> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>>
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Format of sources download improvement

[marius adrian popa]

bunzip2 comes by default in Ubuntu

bunzip2: I won't read compressed data from a terminal.
bunzip2: For help, type: `bunzip2 --help'.

On Mon, Mar 23, 2020 at 9:31 AM Mark Rotteveel  wrote:

> On 22-03-2020 20:13, Jiří Činčura wrote:
> > Hi,
> >
> > is there a reason to keep providing sources in bz2 compression? I did a
> quick comparison with 7z compression:
> > Firebird-3.0.5.33220-0.7z: 8 230 662
> > Firebird-3.0.5.33220-0.tar.bz2: 9 789 316
> >
> > Sure, it's not a huge file either way, but still the improvement is not
> insignificant. And given the sources are expected to be used by experienced
> users/developers, I don't think using 7z is adding any difficulty.
> >
>
> As far as I know, use of tar and bz2 (bzip2) is relatively standard on
> Linux environments, and even the most basic environments usually come
> with the necessary tools to extract them. The same cannot be said for
> 7zip as far as I'm aware.
>
> Mark
> --
> Mark Rotteveel
>
>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] AVX-512 Auto-Vectorization in MSVC

[marius adrian popa]

https://devblogs.microsoft.com/cppblog/avx-512-auto-vectorization-in-msvc/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] AWS credits for oss projects

[marius adrian popa]

https://mobile.twitter.com/mjasay/status/1225876580448096258

https://aws.amazon.com/blogs/opensource/aws-promotional-credits-open-source-projects/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Web site cert issue

[marius adrian popa]

Could you tweak the nginx config to be more secure
https://www.ssllabs.com/ssltest/analyze.html?d=firebirdsql.org

On Fri, Feb 14, 2020 at 8:11 PM Sergey Mereutsa  wrote:

> Hi!
>
> I solved this issue by adding a certificate with longer lifetime - just
> need to put reminder to reissue it next year :)
>
>
>
> --
> Best regards,
>  Sergeymailto:s...@dqteam.com
>
>
>
> On Fri, 14 Feb 2020 at 19:33, Adriano dos Santos Fernandes <
> adrian...@gmail.com> wrote:
>
>> On 14/02/2020 13:13, Lester Caine wrote:
>> >
>> >
>> > That said, letsencrypt can't be relied on to complete a renewal cycle
>> > ... I've just had manually clean up some certs myself so you have to
>> > keep on top of every one :(
>> >
>>
>> It always worked where I setup automatically renew.
>>
>>
>> Adriano
>>
>>
>>
>> Firebird-Devel mailing list, web interface at
>> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>>
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] MSVC Backend Updates in Visual Studio 2019 Versions 16.3 and 16.4

[marius adrian popa]

https://devblogs.microsoft.com/cppblog/msvc-backend-updates-in-visual-studio-2019-versions-16-3-and-16-4/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Blogging on github pages : the easy way

[marius adrian popa]

https://www.fast.ai/2020/01/16/fast_template/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Ruby gem to convert html into markdown

[marius adrian popa]

This might help with some documentation that is in html format and to
generate the md version

https://github.com/xijo/reverse_markdown

https://github.com/FirebirdSQL/firebird/blob/master/doc/Using_OO_API.html

  For example Using OO api is public only on ibase.ru in html format

https://www.ibase.ru/files/firebird/fbapi.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] SQL/JSON standard-2016 conformance for PostgreSQL, Oracle, SQL Server and MySQL

[marius adrian popa]

https://obartunov.livejournal.com/200076.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [Firebird-docs] Firebird 3.0 Language Reference (Russian) Translations ?

[marius adrian popa]

I agree i see there is already work started on Firebird 4.0 Language
Reference in Russian Language
https://www.sql.ru/forum/1315752/ann-rukovodstvo-po-yazyku-sql-subd-firebird-4-0

But we still need 3.0 reference in English

On Tue, Dec 17, 2019 at 12:28 PM Simonov Denis via Firebird-docs <
firebird-d...@lists.sourceforge.net> wrote:

> marius adrian popa  wrote Tue, 17 Dec 2019 13:01:47
> +0300:
>
> > There are any translation efforts regarding
> > Firebird 3.0 Language Reference (Russian)
>
> Hi Marius.
> I think we’d better start preparing the translation "Firebird 4.0
> Language
> Reference" immediately after the release of Beta 2.
>
>
> --
> Regards,
> Simonov Denis
>
>
>
> ___
> Firebird-docs mailing list
> firebird-d...@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-docs
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Firebird 3.0 Language Reference (Russian) Translations ?

[marius adrian popa]

There are any translation efforts regarding
Firebird 3.0 Language Reference (Russian)
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Interesting WSL 1 bug related to symlinks on Ubuntu vs Windows

[marius adrian popa]

https://github.com/xdenser/node-firebird-libfbclient/issues/84

also with WSL 1 Firebird package can't be installed something related to
mmap

I will test when WSL 2 becomes available
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Sourcetrail is now free and open-source

[marius adrian popa]

Very useful when you try to study/navigate large C++ codebases like
Firebird/LibreOffice

https://twitter.com/Sourcetrail/status/1196497855764152321
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] interesting test fails with Firebird 3.0

[marius adrian popa]

https://twitter.com/FranckPachot/status/1196415263031414786


update demo set n=n+1;

violation of PRIMARY or UNIQUE KEY constraint "INTEG_2" on table "DEMO"
Problematic key value is ("N" = 2)
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Interesting changes in mysql 8.0.18

[marius adrian popa]

And some benchmarks compared to zlib used in firebird

https://facebook.github.io/zstd/#benchmarks

On Tue, Oct 22, 2019 at 11:19 AM marius adrian popa 
wrote:

>
> https://mysqlserverteam.com/the-mysql-8-0-18-maintenance-release-is-generally-available/
>
> https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html#connection-compression-configuration
>
> I like the zstd for protocol compression
>
> https://github.com/facebook/zstd
>
> https://engineering.fb.com/core-data/smaller-and-faster-data-compression-with-zstandard/
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Interesting changes in mysql 8.0.18

[marius adrian popa]

https://mysqlserverteam.com/the-mysql-8-0-18-maintenance-release-is-generally-available/
https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html#connection-compression-configuration

I like the zstd for protocol compression

https://github.com/facebook/zstd
https://engineering.fb.com/core-data/smaller-and-faster-data-compression-with-zstandard/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Code analysis with clang-tidy in Visual Studio

[marius adrian popa]

https://devblogs.microsoft.com/cppblog/code-analysis-with-clang-tidy-in-visual-studio/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Improved Linker Fundamentals in Visual Studio 2019

[marius adrian popa]

https://devblogs.microsoft.com/cppblog/improved-linker-fundamentals-in-visual-studio-2019/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] This needs to be closed CORE-5099

[marius adrian popa]

http://tracker.firebirdsql.org/browse/CORE-5099

Firebird 4 compiles ok on Ubuntu 18.04
gcc version 7.3.0
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] What type of UUID we use in Firebird ? i guess Version 1

[marius adrian popa]

What type of UUID we use in Firebird ?
I guess Version 1

UUIDs in MySQL are really not random
https://news.ycombinator.com/item?id=19085189
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] How long will a 64 bit Transaction-ID last in PostgreSQL?

[marius adrian popa]

At FOSDEM
 someone
asked how long 64 bit Transaction-IDs will last.


https://andreas.scherbaum.la/blog/archives/970-How-long-will-a-64-bit-Transaction-ID-last-in-PostgreSQL.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Ubuntu Xenial 16.04 is now available on travis

[marius adrian popa]

Ubuntu Xenial 16.04 is now available on travis

https://blog.travis-ci.com/2018-11-08-xenial-release
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[marius adrian popa]

Last updated: 2018-11-06
http://www.sql-workbench.eu/dbms_comparison.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] DBMS migration in LibreOffice

[marius adrian popa]

Posted on TDF blog

https://blog.documentfoundation.org/blog/2018/08/06/dbms-migration-in-libreoffice/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Automatic Windows builds with AppVeyor

[marius adrian popa]

Hello Adriano , could you add also a badge to the readme  ?

https://www.appveyor.com/docs/status-badges/

On Mon, Jul 23, 2018 at 10:26 PM, Adriano dos Santos Fernandes <
adrian...@gmail.com> wrote:

> On 23/07/2018 16:14, Dimitry Sibiryakov wrote:
> >   Nobody cared to add it into project's file, so everyone has to set
> > it globally on every Windows where Firebird is built.
> >
>
> That file should not be added, it will make edit of bat file in Linux a
> problem.
>
> It's better to set core.autocrlf option globally in Windows.
>
> I'm waiting for appveyor build, the git config in the script should work.
>
>
> Adriano
>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Certificate for firebird tracker is insecure

[marius adrian popa]

https://tracker.firebirdsql.org/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird fbudf Module Authenticated Remote Code Execution

[marius adrian popa]

Related debian discussion

https://lists.debian.org/debian-lts/2018/04/msg00090.html

and announcement for debian stable
https://lists.debian.org/debian-lts-announce/2018/05/msg5.html



On Thu, Apr 12, 2018 at 5:28 PM, marius adrian popa 
wrote:

> So the only solution is disabling external UDF libraries from being loaded
> by changing configuration from UdfAccess=Restrict to UdfAccess=None
>
> On Thu, Apr 12, 2018 at 2:34 PM, Alex Peshkoff via Firebird-devel <
> firebird-devel@lists.sourceforge.net> wrote:
>
>> On 04/12/18 10:37, marius adrian popa wrote:
>>
>>> https://www.tenable.com/security/research/tra-2017-36
>>>
>>
>> That's fixed in FB4 - loading UDFs is denied by default configuration,
>> use of them is deprecated, replacement is UDRs which are nt affected by
>> mentioned vulnerability.
>> In FB3 one should be sysdba or granted special right to declare extrernal
>> functions. This does not solve the problem - just makes it a bit less
>> dangerous.
>> We can't do something better with this, therefore no fixes for current
>> releases.
>>
>>
>> 
>> --
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> Firebird-Devel mailing list, web interface at
>> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>>
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird fbudf Module Authenticated Remote Code Execution

[marius adrian popa]

So the only solution is disabling external UDF libraries from being loaded
by changing configuration from UdfAccess=Restrict to UdfAccess=None

On Thu, Apr 12, 2018 at 2:34 PM, Alex Peshkoff via Firebird-devel <
firebird-devel@lists.sourceforge.net> wrote:

> On 04/12/18 10:37, marius adrian popa wrote:
>
>> https://www.tenable.com/security/research/tra-2017-36
>>
>
> That's fixed in FB4 - loading UDFs is denied by default configuration, use
> of them is deprecated, replacement is UDRs which are nt affected by
> mentioned vulnerability.
> In FB3 one should be sysdba or granted special right to declare extrernal
> functions. This does not solve the problem - just makes it a bit less
> dangerous.
> We can't do something better with this, therefore no fixes for current
> releases.
>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Firebird fbudf Module Authenticated Remote Code Execution

[marius adrian popa]

https://www.tenable.com/security/research/tra-2017-36
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Final steps of LibreOffice database migration

[marius adrian popa]

 Bunth Tamás wrote

 about the last step on LibreOffice database migration
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] some issues with sed on macosx firebird master

[marius adrian popa]

Tested with
export DYLD_LIBRARY_PATH=/usr/local/opt/icu4c/lib:$DYLD_LIBRARY_PATH
export DYLD_FALLBACK_LIBRARY_PATH=/usr/local/opt/icu4c/lib

but didn't worked , i will try on a mac first to see the issue

On Fri, Mar 23, 2018 at 11:43 AM, Paul Beach 
wrote:

> > > icu is installed
> > >
> > > ls /usr/local/opt/icu4c/lib
> > >
> > > icu libicuio.59.1.dylib libicutu.59.dylib
> > > libicudata.59.1.dylib libicuio.59.dylib libicutu.a
> > > libicudata.59.dylib libicuio.a libicutu.dylib
> > > libicudata.a libicuio.dylib libicuuc.59.1.dylib
> > > libicudata.dylib libicutest.59.1.dylib libicuuc.59.dylib
> > > libicui18n.59.1.dylib libicutest.59.dylib libicuuc.a
> > > libicui18n.59.dylib libicutest.a libicuuc.dylib
> > > libicui18n.a libicutest.dylib pkgconfig
> > > libicui18n.dylib libicutu.59.1.dylib
> > >
> >
> > Very good. But sooner of all there is no path to it. Please try (first
> > of all)
> > export LD_LIBRARY_PATH=/usr/local/opt/icu4c/lib
> > This is not best way of loading ICU but OK for first attempt.
>
> DYLD_LIBRARY_PATH
>
> Regards
> Paul
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] CORE-2998 can be closed

[marius adrian popa]

Not Firebird Core related
http://tracker.firebirdsql.org/browse/CORE-2998
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] some issues with sed on macosx firebird master

[marius adrian popa]

icu is installed

ls /usr/local/opt/icu4c/lib

icu libicuio.59.1.dylib libicutu.59.dylib
libicudata.59.1.dylib libicuio.59.dylib libicutu.a
libicudata.59.dylib libicuio.a libicutu.dylib
libicudata.a libicuio.dylib libicuuc.59.1.dylib
libicudata.dylib libicutest.59.1.dylib libicuuc.59.dylib
libicui18n.59.1.dylib libicutest.59.dylib libicuuc.a
libicui18n.59.dylib libicutest.a libicuuc.dylib
libicui18n.a libicutest.dylib pkgconfig
libicui18n.dylib libicutu.59.1.dylib


On Thu, Mar 22, 2018 at 5:01 PM, Alex Peshkoff via Firebird-devel <
firebird-devel@lists.sourceforge.net> wrote:

> On 03/22/18 15:52, marius adrian popa wrote:
>
>> It reached somewhere (Could not find acceptable ICU library)
>>
>>
> Is any ICU installed or not on travis build machine?
> If not try to install please.
>
>
>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] 2 Cmake Build Issues fixed

[marius adrian popa]

These two can be closed

http://tracker.firebirdsql.org/browse/CORE-5662
http://tracker.firebirdsql.org/browse/CORE-5661
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] some issues with sed on macosx firebird master

[marius adrian popa]

It reached somewhere (Could not find acceptable ICU library)

https://travis-ci.org/mariuz/firebird/jobs/356852172#L8329

/Users/travis/build/mariuz/firebird/gen/Release/firebird/bin/isql -q
-i /Users/travis/build/mariuz/firebird/src/dbs/metadata.sql
can't format message 17:0 -- message file
/Users/travis/build/mariuz/firebird/gen/Release/firebird/firebird.msg
not found
Could not find acceptable ICU library
can't format message 17:120 -- message file
/Users/travis/build/mariuz/firebird/gen/Release/firebird/firebird.msg
not found
make[3]: *** [metadata.fdb] Error 1
make[2]: *** [master_process] Error 2
make[1]: *** [firebird] Error 2
make: *** [firebird] Error 2



On Thu, Mar 22, 2018 at 2:36 PM, marius adrian popa <map...@gmail.com>
wrote:

> Thanks , merged doing a new build https://travis-ci.org/
> mariuz/firebird/builds/356852171
>
> On Thu, Mar 22, 2018 at 1:58 PM, Vlad Khorsun via Firebird-devel <
> firebird-devel@lists.sourceforge.net> wrote:
>
>> 22.03.2018 13:21, marius adrian popa wrote:
>>
>>> sed part worked :)
>>>
>>> now another one
>>>
>>> https://travis-ci.org/mariuz/firebird/jobs/356795126
>>>
>>> /Users/travis/build/mariuz/firebird/src/remote/../remote/SockAddr.h:101:2:
>>> error: Unknown value of AF_INET6 !
>>> #error Unknown value of AF_INET6 !
>>>
>>
>>   Should be fixed now
>>
>> Regards,
>> Vlad
>>
>> 
>> --
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>> Firebird-Devel mailing list, web interface at
>> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>>
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] some issues with sed on macosx firebird master

[marius adrian popa]

Thanks , merged doing a new build
https://travis-ci.org/mariuz/firebird/builds/356852171

On Thu, Mar 22, 2018 at 1:58 PM, Vlad Khorsun via Firebird-devel <
firebird-devel@lists.sourceforge.net> wrote:

> 22.03.2018 13:21, marius adrian popa wrote:
>
>> sed part worked :)
>>
>> now another one
>>
>> https://travis-ci.org/mariuz/firebird/jobs/356795126
>>
>> /Users/travis/build/mariuz/firebird/src/remote/../remote/SockAddr.h:101:2:
>> error: Unknown value of AF_INET6 !
>> #error Unknown value of AF_INET6 !
>>
>
>   Should be fixed now
>
> Regards,
> Vlad
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] some issues with sed on macosx firebird master

[marius adrian popa]

sed part worked :)

now another one

https://travis-ci.org/mariuz/firebird/jobs/356795126

/Users/travis/build/mariuz/firebird/src/remote/../remote/SockAddr.h:101:2:
error: Unknown value of AF_INET6 !
#error Unknown value of AF_INET6 !



On Thu, Mar 22, 2018 at 11:46 AM, marius adrian popa <map...@gmail.com>
wrote:

> I have made a few changes in my local fork
>
> https://github.com/FirebirdSQL/firebird/pull/148/commits/
> 5bf437e7dc713741a8324d3472083ab2fa932655
>
> Let's see if the build succeeds
>
> On Thu, Mar 22, 2018 at 11:09 AM, marius adrian popa <map...@gmail.com>
> wrote:
>
>> I have some issues with sed on macosx build , normally it should call
>> with INLINE_EDIT_SED
>>
>> https://travis-ci.org/mariuz/firebird/jobs/356389960
>>
>>
>> sed -n -e "s/.*btyacc: \(.*conflicts.*\)/\1/p" 
>> /Users/travis/build/mariuz/firebird/gen/y.txt > 
>> /Users/travis/build/mariuz/firebird/src/dsql/parse-conflicts.txt
>> sed -i 's/#define \([A-Z].*\)/#define TOK_\1/' 
>> /Users/travis/build/mariuz/firebird/gen/y_tab.h
>> sed: 1: "/Users/travis/build/mar ...": undefined label 
>> 'ravis/build/mariuz/firebird/gen/y_tab.h'
>>
>>
>>
>> ps: i tried to force gnu sed but doesn't work either
>>
>> https://travis-ci.org/mariuz/firebird/jobs/356517151
>>
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] some issues with sed on macosx firebird master

[marius adrian popa]

I have made a few changes in my local fork

https://github.com/FirebirdSQL/firebird/pull/148/commits/5bf437e7dc713741a8324d3472083ab2fa932655

Let's see if the build succeeds

On Thu, Mar 22, 2018 at 11:09 AM, marius adrian popa <map...@gmail.com>
wrote:

> I have some issues with sed on macosx build , normally it should call with
> INLINE_EDIT_SED
>
> https://travis-ci.org/mariuz/firebird/jobs/356389960
>
>
> sed -n -e "s/.*btyacc: \(.*conflicts.*\)/\1/p" 
> /Users/travis/build/mariuz/firebird/gen/y.txt > 
> /Users/travis/build/mariuz/firebird/src/dsql/parse-conflicts.txt
> sed -i 's/#define \([A-Z].*\)/#define TOK_\1/' 
> /Users/travis/build/mariuz/firebird/gen/y_tab.h
> sed: 1: "/Users/travis/build/mar ...": undefined label 
> 'ravis/build/mariuz/firebird/gen/y_tab.h'
>
>
>
> ps: i tried to force gnu sed but doesn't work either
>
> https://travis-ci.org/mariuz/firebird/jobs/356517151
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] some issues with sed on macosx firebird master

[marius adrian popa]

I have some issues with sed on macosx build , normally it should call with
INLINE_EDIT_SED

https://travis-ci.org/mariuz/firebird/jobs/356389960


sed -n -e "s/.*btyacc: \(.*conflicts.*\)/\1/p"
/Users/travis/build/mariuz/firebird/gen/y.txt >
/Users/travis/build/mariuz/firebird/src/dsql/parse-conflicts.txt
sed -i 's/#define \([A-Z].*\)/#define TOK_\1/'
/Users/travis/build/mariuz/firebird/gen/y_tab.h
sed: 1: "/Users/travis/build/mar ...": undefined label
'ravis/build/mariuz/firebird/gen/y_tab.h'



ps: i tried to force gnu sed but doesn't work either

https://travis-ci.org/mariuz/firebird/jobs/356517151
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] DBMS migration in LibreOffice: HSQLDB binary import

[marius adrian popa]

DBMS migration in LibreOffice continues with HSQLDB binary import

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] How to use PVS-Studio for Free

[marius adrian popa]

How to use PVS-Studio for Free

https://www.viva64.com/en/b/0457/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] How TDF uses its tendering process to improve LibreOffice

[marius adrian popa]

In 2017, The Document Foundation (TDF) launched four tenders aimed at
improving LibreOffice in several strategic areas, where the tasks are
beyond the capabilities of independent volunteer developers.

https://blog.documentfoundation.org/blog/2018/01/29/tdf-uses-tendering-process-improve-libreoffice-share-knowledge-community/

No 4  is interesting for Firebird community

(4) *Tender to implement HSQLDB binary format import in LibreOffice*
(
https://blog.documentfoundation.org/blog/2017/05/04/tender-implement-hsqldb-binary-format-import-libreoffice-201705-03/
)

Collabora will develop a mechanism to import database files with high
fidelity from the HSQLDB binary file format, which has been used inside
many existing ODB files, by reading the Java serialization code, and
writing a filter to import all data into LibreOffice Base. The objective is
to remove the legacy Java/HSQLDB database and move to Firebird.

TDF will invest € 29,750.00
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Meltdown and Spectre

[marius adrian popa]

Here are a few details on Linux related distros

https://lwn.net/Articles/742999/

Also Intel already prepared microcode patches and they push it trough OS
update channels

https://hothardware.com/news/microsoft-windows-10-pcs-haswell-intel-cpus-significant-slowdowns-post-spectre-patch

On Tue, Jan 9, 2018 at 11:52 AM, Omacht András  wrote:

> Hi!
>
>
>
> Just for the shake of information.
>
>
>
> Our test system running on Debian 9.3.
>
> processor   : 7
> vendor_id   : GenuineIntel
> cpu family  : 6
> model   : 23
> model name  : Intel(R) Xeon(R) CPU   E5420  @ 2.50GHz
> stepping: 6
> microcode   : 0x60b
> cpu MHz : 2500.117
> cache size  : 6144 KB
> …
>
>
>
> We’ve done some test runs with the ’old’ kernel
> (linux-image-4.9.0-4-amd64) and the ’new’ one (linux-image-4.9.0-5-amd64).
>
>
>
> No. of tests: 6014
>
> No. of result checks: 253555   (checking column values, stored procedure
> results, etc.)
>
>
>
> Average running time on 4.9.0-4: 466 secs (7 mins 46 secs)
>
> Average running time on 4.9.0-5: 635 secs (10 mins 35 secs)
>
>
>
> The database file and the tmp directory located on ramdisk.
>
>
>
> András
>
>
> __ Information from ESET Mail Security, version of virus signature
> database 16706 (20180109) __
>
> The message was checked by ESET Mail Security.
> http://www.eset.com
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Code Quality Comparison of Firebird, MySQL, and PostgreSQL

[marius adrian popa]

Code Quality Comparison of Firebird, MySQL, and PostgreSQL

https://www.viva64.com/en/b/0542/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Splitting out sub projects in extern

[marius adrian popa]

Now i see that is used also for node-firebird-native-api generating json
and that is cool

https://github.com/asfernandes/node-firebird-native-api/blob/master/src/generate-files/firebird.cloop.json

Maybe it needs more info on how it used and in what projects is used in the
Readme
eg: node-firebird-native-api , ibx2 

https://www.mwasoftware.co.uk/creating-ibx2

On Fri, Nov 17, 2017 at 11:46 AM, Adriano dos Santos Fernandes <
adrian...@gmail.com> wrote:

> On 16/11/2017 23:54, William L. Thomson Jr. wrote:
> > On Thu, 16 Nov 2017 22:30:25 -0200
> > Adriano dos Santos Fernandes  wrote:
> >
> >> Em 16/11/2017 14:47, William L. Thomson Jr. escreveu:
> >>> I understand for various reasons why there are packages shipped with
> >>> Firebird sources used as part of its build, residing in extern
> >>> folder.
> >> A not good thing, a choice among others not good things. Life is not
> >> perfect.
> > Thanks for replying!
> > You have one of the ones I wanted split out in a repo already. :)
> > https://github.com/asfernandes/cloop
> >
> I think cloop as a standalone project is good and was developed in this
> way really to not be very tied to Firebird source code.
>
> But the project wad no marketing, no documentation, not even a README,
> so it's totally unknown outside Firebird.
>
> Version from Firebird diverges a bit as it's the way Firebird developers
> works. No direct contact with upstream developers to work on the
> original projects, even when the upstream is part of Firebird project. :D
>
>
> Adriano
>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Splitting out sub projects in extern

[marius adrian popa]

I propose that we go with submodules like they do on wxWidgets in the case
of external dependencies (expat ...zlib)

https://github.com/wxWidgets/wxWidgets/tree/master/src

this way we can sync with upstream faster


On Thu, Nov 16, 2017 at 6:47 PM, William L. Thomson Jr. 
wrote:

> I understand for various reasons why there are packages shipped with
> Firebird sources used as part of its build, residing in extern folder.
>
> I would like to request for consideration that those projects be split
> into their own projects within Firebird. It seems Firebird project has
> modified some. A while back I packaged like btyacc on Gentoo from
> upstream sources. It seems upstream is dead. Since then some minor
> changes have been made to the one in extern.
>
> My plan for now is to create packages from those within Firebird. I
> guess using Firebird version for the version of that stuff. I need to
> package and build it on its own and not have it build as part of
> Firebird. Some things I am able to find and package on its own. But for
> other things it seems like Firebird is the upstream.
>
> Like btyacc and cloop. I think there maybe 1 or 2 others, not all. Some
> of the others still have active upstreams and sources in Firebird are
> not heavily modified if at all.
>
> Anyway just something I wanted to bring up for consideration. I
> understand this may cause some additional difficulties in building, for
> development and project binary releases. Though for anyone packaging
> Firebird, Linux distros and others, it may make things easier.
>
> Thank you for your consideration!
>
> --
> William L. Thomson Jr.
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5661) Build fails using CMake under Debian 8/x86_64

[marius adrian popa]

ok recovered my password and added comments to the ticket

On Wed, Nov 15, 2017 at 7:54 PM, marius adrian popa <map...@gmail.com>
wrote:

> This is fixed by https://github.com/FirebirdSQL/firebird/pull/117
>
> ps : I can't login to jira , seems that i forgot my password
>
> On Wed, Nov 15, 2017 at 6:05 PM, Vadim Zeitlin (JIRA) <
> trac...@firebirdsql.org> wrote:
>
>> Build fails using CMake under Debian 8/x86_64
>> -
>>
>>  Key: CORE-5661
>>  URL: http://tracker.firebirdsql.org/browse/CORE-5661
>>  Project: Firebird Core
>>   Issue Type: Bug
>>   Components: Build Issues / Porting
>> Affects Versions: 3.0.2
>>  Environment: Debian 8 (Jessie) x86_64
>> Reporter: Vadim Zeitlin
>> Priority: Minor
>>
>>
>> Trying to build with CMake fails with
>>
>> Building CXX object src/CMakeFiles/common.dir/common/CRC32C.cpp.o
>> In file included from /usr/lib/gcc/x86_64-linux-gnu/
>> 4.9/include/nmmintrin.h:31:0,
>>  from /tmp/firebird/src/common/CRC32C.cpp:34:
>> /usr/lib/gcc/x86_64-linux-gnu/4.9/include/smmintrin.h: In function
>> 'unsigned int CRC32C(unsigned int, const unsigned char*)':
>> /usr/lib/gcc/x86_64-linux-gnu/4.9/include/smmintrin.h:827:1: error:
>> inlining failed in call to always_inline 'unsigned int
>> _mm_crc32_u8(unsigned int, unsigned char)': target specific option mismatch
>>  _mm_crc32_u8 (unsigned int __C, unsigned char __V)
>>  ^
>> /tmp/firebird/src/common/CRC32C.cpp:41:41: error: called from here
>>return _mm_crc32_u8(hash_value, *value);
>>  ^
>> In file included from /usr/lib/gcc/x86_64-linux-gnu/
>> 4.9/include/nmmintrin.h:31:0,
>>  from /tmp/firebird/src/common/CRC32C.cpp:34:
>> /usr/lib/gcc/x86_64-linux-gnu/4.9/include/smmintrin.h:833:1: error:
>> inlining failed in call to always_inline 'unsigned int
>> _mm_crc32_u16(unsigned int, short unsigned int)': target specific option
>> mismatch
>>  _mm_crc32_u16 (unsigned int __C, unsigned short __V)
>>  ^
>> /tmp/firebird/src/common/CRC32C.cpp:44:60: error: called from here
>>return _mm_crc32_u16(hash_value, *(unsigned short*) value);
>> ^
>> In file included from /usr/lib/gcc/x86_64-linux-gnu/
>> 4.9/include/nmmintrin.h:31:0,
>>  from /tmp/firebird/src/common/CRC32C.cpp:34:
>> /usr/lib/gcc/x86_64-linux-gnu/4.9/include/smmintrin.h:839:1: error:
>> inlining failed in call to always_inline 'unsigned int
>> _mm_crc32_u32(unsigned int, unsigned int)': target specific option mismatch
>>  _mm_crc32_u32 (unsigned int __C, unsigned int __V)
>>  ^
>> /tmp/firebird/src/common/CRC32C.cpp:48:65: error: called from here
>>hash_value = _mm_crc32_u32(hash_value, *(unsigned int*) value);
>>  ^
>> In file included from /usr/lib/gcc/x86_64-linux-gnu/
>> 4.9/include/nmmintrin.h:31:0,
>>  from /tmp/firebird/src/common/CRC32C.cpp:34:
>> /usr/lib/gcc/x86_64-linux-gnu/4.9/include/smmintrin.h:833:1: error:
>> inlining failed in call to always_inline 'unsigned int
>> _mm_crc32_u16(unsigned int, short unsigned int)': target specific option
>> mismatch
>>  _mm_crc32_u16 (unsigned int __C, unsigned short __V)
>>  ^
>> /tmp/firebird/src/common/CRC32C.cpp:55:67: error: called from here
>>hash_value = _mm_crc32_u16(hash_value, *(unsigned short*) value);
>>^
>> In file included from /usr/lib/gcc/x86_64-linux-gnu/
>> 4.9/include/nmmintrin.h:31:0,
>>  from /tmp/firebird/src/common/CRC32C.cpp:34:
>> /usr/lib/gcc/x86_64-linux-gnu/4.9/include/smmintrin.h:827:1: error:
>> inlining failed in call to always_inline 'unsigned int
>> _mm_crc32_u8(unsigned int, unsigned char)': target specific option mismatch
>>  _mm_crc32_u8 (unsigned int __C, unsigned char __V)
>>  ^
>> /tmp/firebird/src/common/CRC32C.cpp:62:48: error: called from here
>>hash_value = _mm_crc32_u8(hash_value, *value);
>> ^
>> src/CMakeFiles/common.dir/build.make:537: recipe for target
>> 'src/CMakeFiles/common.dir/common/CRC32C.cpp.o' failed
>> make: *** [src/CMakeFiles/common.dir/common/CRC32C.cpp.o] Error 1
>>
>> This happens because CMake compiles this file without -msse4 option used
>>

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5661) Build fails using CMake under Debian 8/x86_64

[marius adrian popa]

This is fixed by https://github.com/FirebirdSQL/firebird/pull/117

ps : I can't login to jira , seems that i forgot my password

On Wed, Nov 15, 2017 at 6:05 PM, Vadim Zeitlin (JIRA) <
trac...@firebirdsql.org> wrote:

> Build fails using CMake under Debian 8/x86_64
> -
>
>  Key: CORE-5661
>  URL: http://tracker.firebirdsql.org/browse/CORE-5661
>  Project: Firebird Core
>   Issue Type: Bug
>   Components: Build Issues / Porting
> Affects Versions: 3.0.2
>  Environment: Debian 8 (Jessie) x86_64
> Reporter: Vadim Zeitlin
> Priority: Minor
>
>
> Trying to build with CMake fails with
>
> Building CXX object src/CMakeFiles/common.dir/common/CRC32C.cpp.o
> In file included from /usr/lib/gcc/x86_64-linux-gnu/
> 4.9/include/nmmintrin.h:31:0,
>  from /tmp/firebird/src/common/CRC32C.cpp:34:
> /usr/lib/gcc/x86_64-linux-gnu/4.9/include/smmintrin.h: In function
> 'unsigned int CRC32C(unsigned int, const unsigned char*)':
> /usr/lib/gcc/x86_64-linux-gnu/4.9/include/smmintrin.h:827:1: error:
> inlining failed in call to always_inline 'unsigned int
> _mm_crc32_u8(unsigned int, unsigned char)': target specific option mismatch
>  _mm_crc32_u8 (unsigned int __C, unsigned char __V)
>  ^
> /tmp/firebird/src/common/CRC32C.cpp:41:41: error: called from here
>return _mm_crc32_u8(hash_value, *value);
>  ^
> In file included from /usr/lib/gcc/x86_64-linux-gnu/
> 4.9/include/nmmintrin.h:31:0,
>  from /tmp/firebird/src/common/CRC32C.cpp:34:
> /usr/lib/gcc/x86_64-linux-gnu/4.9/include/smmintrin.h:833:1: error:
> inlining failed in call to always_inline 'unsigned int
> _mm_crc32_u16(unsigned int, short unsigned int)': target specific option
> mismatch
>  _mm_crc32_u16 (unsigned int __C, unsigned short __V)
>  ^
> /tmp/firebird/src/common/CRC32C.cpp:44:60: error: called from here
>return _mm_crc32_u16(hash_value, *(unsigned short*) value);
> ^
> In file included from /usr/lib/gcc/x86_64-linux-gnu/
> 4.9/include/nmmintrin.h:31:0,
>  from /tmp/firebird/src/common/CRC32C.cpp:34:
> /usr/lib/gcc/x86_64-linux-gnu/4.9/include/smmintrin.h:839:1: error:
> inlining failed in call to always_inline 'unsigned int
> _mm_crc32_u32(unsigned int, unsigned int)': target specific option mismatch
>  _mm_crc32_u32 (unsigned int __C, unsigned int __V)
>  ^
> /tmp/firebird/src/common/CRC32C.cpp:48:65: error: called from here
>hash_value = _mm_crc32_u32(hash_value, *(unsigned int*) value);
>  ^
> In file included from /usr/lib/gcc/x86_64-linux-gnu/
> 4.9/include/nmmintrin.h:31:0,
>  from /tmp/firebird/src/common/CRC32C.cpp:34:
> /usr/lib/gcc/x86_64-linux-gnu/4.9/include/smmintrin.h:833:1: error:
> inlining failed in call to always_inline 'unsigned int
> _mm_crc32_u16(unsigned int, short unsigned int)': target specific option
> mismatch
>  _mm_crc32_u16 (unsigned int __C, unsigned short __V)
>  ^
> /tmp/firebird/src/common/CRC32C.cpp:55:67: error: called from here
>hash_value = _mm_crc32_u16(hash_value, *(unsigned short*) value);
>^
> In file included from /usr/lib/gcc/x86_64-linux-gnu/
> 4.9/include/nmmintrin.h:31:0,
>  from /tmp/firebird/src/common/CRC32C.cpp:34:
> /usr/lib/gcc/x86_64-linux-gnu/4.9/include/smmintrin.h:827:1: error:
> inlining failed in call to always_inline 'unsigned int
> _mm_crc32_u8(unsigned int, unsigned char)': target specific option mismatch
>  _mm_crc32_u8 (unsigned int __C, unsigned char __V)
>  ^
> /tmp/firebird/src/common/CRC32C.cpp:62:48: error: called from here
>hash_value = _mm_crc32_u8(hash_value, *value);
> ^
> src/CMakeFiles/common.dir/build.make:537: recipe for target
> 'src/CMakeFiles/common.dir/common/CRC32C.cpp.o' failed
> make: *** [src/CMakeFiles/common.dir/common/CRC32C.cpp.o] Error 1
>
> This happens because CMake compiles this file without -msse4 option used
> by autoconf-based build system. I don't know how to add this option for
> just this file using CMake, but adding it globally would at least fix the
> build for now.
>
> BTW, I'd gladly avoid using CMake in the first place if only autoconf
> supported building out of the source directory, which it currently doesn't,
> unfortunately...
>
> --
> 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
>
>
>
> 
> --
> Check out the vibrant tech community on one of the world's 

Re: [Firebird-devel] libtool used for libtomcrypt is not using the defined LIBTOOL

[marius adrian popa]

Ok i installed libtomcrypt from source , i will create a pull request with
new version of it for firebird
git clone https://github.com/libtom/libtomcrypt.git
cd libtomcrypt
git checkout tags/1.18
make
make install
cd ..

https://travis-ci.org/mariuz/firebird/jobs/297987922
And got the next error
error: use of undeclared identifier 'nullptr'





On Sat, Nov 4, 2017 at 5:25 PM, marius adrian popa <map...@gmail.com> wrote:

> I created an alias from libtool to glibtool
>
> then i got the next error https://travis-ci.org/
> mariuz/firebird/jobs/296857861
>
> ./src/headers/tomcrypt_macros.h:269:24: error: constraint 'I' expects an 
> integer constant expression
>
>   :"0" (word),"I" (i));
>
>
> On Fri, Nov 3, 2017 at 5:11 PM, marius adrian popa <map...@gmail.com>
> wrote:
>
>> I try to create a travis script for mac and i'm blocked on this one
>>
>> libtomcrypt is not using the defined LIBTOOL also is using gcc instead
>> of clang
>>
>> Here is travis.yml configuration
>>
>> https://github.com/mariuz/firebird/blob/master/.travis.yml
>>
>> and here is the build log
>>
>> https://travis-ci.org/mariuz/firebird/jobs/296806230
>>
>>
>>
>> CFLAGS="-D_THREAD_SAFE " 
>> /Applications/Xcode.app/Contents/Developer/usr/bin/make -C 
>> /Users/travis/build/mariuz/firebird/extern/libtomcrypt -f makefile.shared 
>> GCC=gcc
>>
>> libtool --mode=compile --tag=CC gcc  -D_THREAD_SAFE  -c -I./src/headers/ 
>> -Wall -Wsign-compare -W -Wshadow -DLTC_SOURCE -O3 -funroll-loops 
>> -fomit-frame-pointer -DENCRYPT_ONLY -c src/ciphers/aes/aes.c -o 
>> src/ciphers/aes/aes_enc.o
>>
>> error: 
>> /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/libtool:
>>  unknown option character `-' in: --mode=compile
>>
>>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] libtool used for libtomcrypt is not using the defined LIBTOOL

[marius adrian popa]

I created an alias from libtool to glibtool

then i got the next error
https://travis-ci.org/mariuz/firebird/jobs/296857861

./src/headers/tomcrypt_macros.h:269:24: error: constraint 'I' expects
an integer constant expression

  :"0" (word),"I" (i));


On Fri, Nov 3, 2017 at 5:11 PM, marius adrian popa <map...@gmail.com> wrote:

> I try to create a travis script for mac and i'm blocked on this one
>
> libtomcrypt is not using the defined LIBTOOL also is using gcc instead of
> clang
>
> Here is travis.yml configuration
>
> https://github.com/mariuz/firebird/blob/master/.travis.yml
>
> and here is the build log
>
> https://travis-ci.org/mariuz/firebird/jobs/296806230
>
>
>
> CFLAGS="-D_THREAD_SAFE " 
> /Applications/Xcode.app/Contents/Developer/usr/bin/make -C 
> /Users/travis/build/mariuz/firebird/extern/libtomcrypt -f makefile.shared 
> GCC=gcc
>
> libtool --mode=compile --tag=CC gcc  -D_THREAD_SAFE  -c -I./src/headers/ 
> -Wall -Wsign-compare -W -Wshadow -DLTC_SOURCE -O3 -funroll-loops 
> -fomit-frame-pointer -DENCRYPT_ONLY -c src/ciphers/aes/aes.c -o 
> src/ciphers/aes/aes_enc.o
>
> error: 
> /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/libtool:
>  unknown option character `-' in: --mode=compile
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] libtool used for libtomcrypt is not using the defined LIBTOOL

[marius adrian popa]

I try to create a travis script for mac and i'm blocked on this one

libtomcrypt is not using the defined LIBTOOL also is using gcc instead of
clang

Here is travis.yml configuration

https://github.com/mariuz/firebird/blob/master/.travis.yml

and here is the build log

https://travis-ci.org/mariuz/firebird/jobs/296806230



CFLAGS="-D_THREAD_SAFE "
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C
/Users/travis/build/mariuz/firebird/extern/libtomcrypt -f
makefile.shared GCC=gcc

libtool --mode=compile --tag=CC gcc  -D_THREAD_SAFE  -c
-I./src/headers/ -Wall -Wsign-compare -W -Wshadow -DLTC_SOURCE -O3
-funroll-loops -fomit-frame-pointer -DENCRYPT_ONLY -c
src/ciphers/aes/aes.c -o src/ciphers/aes/aes_enc.o

error: 
/Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/libtool:
unknown option character `-' in: --mode=compile
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Fwd: [pkg-firebird-general] Bug#879972: firebird3.0: FTBFS with icu59, simple workaround/patch attached

[marius adrian popa]

Thanks for the input

here is also the libreoffice approach for new icu

https://github.com/LibreOffice/core/commit/fabad007c60958f2ff87e8f636ff6a798ad1f963#diff-5cdae6d283d6fdef5700f98b098748cc

I guess the new icu will work on new distros with firebird 3.0

2.5 is already removed in debian testing / next ubuntu versions

On Tue, Oct 31, 2017 at 9:52 AM, Michal Kubecek <m...@mk-sys.cz> wrote:

> On Mon, Oct 30, 2017 at 05:04:25PM +0200, marius adrian popa wrote:
> > Firebird 3.0 icu59 ubuntu related patch
> >
> > -- Forwarded message --
> > From: Adam Conrad <adcon...@debian.org>
> > Date: Fri, Oct 27, 2017 at 10:03 PM
> > Subject: [pkg-firebird-general] Bug#879972: firebird3.0: FTBFS with
> icu59,
> > simple workaround/patch attached
> > To: Debian Bug Tracking System <sub...@bugs.debian.org>
> >
> >
> > Package: firebird3.0
> > Version: 3.0.2.32703.ds4-11
> > Severity: important
> > Tags: patch
> > User: ubuntu-de...@lists.ubuntu.com
> > Usertags: origin-ubuntu bionic ubuntu-patch
> >
> >
> >
> > In Ubuntu, the attached patch was applied to achieve the following:
> >
> >   * Define UCHAR_TYPE=uint16_t to avoid C++11 and fix FTBFS with icu59.
> >
> > So, here's what's happening.  In icu59, UChar is defined as char16_t if
> > you're compiling a C++ project (ie: ifdef __cplusplus), but char16_t is
> > a C++11 type.  One could argue this is an ICU bug for forcing rdeps to
> > conform to a newer C++ standard (and one could even win that argument,
> > I imagine), but I figured working around it in firebird was the path of
> > least resistance.
> >
> > My first attempt was to change the firebird build from std=gnu++98 to
> > std=gnu++11.  Don't do that.  I mean, try if you want, but it does not
> > end well.
> >
> > This patch just tells icu to use the same type for UChar that it used to
> > and it seems to do the trick here.  So, enjoy.
>
> This will probably work around the immediate build problem but as
> I pointed out some time ago in
>
>   http://firebird.1100200.n4.nabble.com/heads-up-ICU-59-1-
> requires-C-11-td4645984.html
>
> the real problem is that starting with version 59.1, ICU officially
> requires C++11 so that there may be other, more subtle, issues with it
> and even if not, more can be expected to come with newer versions.
>
> On the other hand, making 2.5 code fully conform to C++11 might bring
> other problems so addressing ICU compatibility problems one by one is
> probably the only viable option (except just claiming that users of
> distributions that new should use 3.0).
>
>Michal Kubecek
>
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Fwd: [pkg-firebird-general] Bug#879972: firebird3.0: FTBFS with icu59, simple workaround/patch attached

[marius adrian popa]

Firebird 3.0 icu59 ubuntu related patch

-- Forwarded message --
From: Adam Conrad 
Date: Fri, Oct 27, 2017 at 10:03 PM
Subject: [pkg-firebird-general] Bug#879972: firebird3.0: FTBFS with icu59,
simple workaround/patch attached
To: Debian Bug Tracking System 


Package: firebird3.0
Version: 3.0.2.32703.ds4-11
Severity: important
Tags: patch
User: ubuntu-de...@lists.ubuntu.com
Usertags: origin-ubuntu bionic ubuntu-patch



In Ubuntu, the attached patch was applied to achieve the following:

  * Define UCHAR_TYPE=uint16_t to avoid C++11 and fix FTBFS with icu59.

So, here's what's happening.  In icu59, UChar is defined as char16_t if
you're compiling a C++ project (ie: ifdef __cplusplus), but char16_t is
a C++11 type.  One could argue this is an ICU bug for forcing rdeps to
conform to a newer C++ standard (and one could even win that argument,
I imagine), but I figured working around it in firebird was the path of
least resistance.

My first attempt was to change the firebird build from std=gnu++98 to
std=gnu++11.  Don't do that.  I mean, try if you want, but it does not
end well.

This patch just tells icu to use the same type for UChar that it used to
and it seems to do the trick here.  So, enjoy.

... Adam


-- System Information:
Debian Release: buster/sid
  APT prefers bionic
  APT policy: (500, 'bionic')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 4.13.0-16-lowlatency (SMP w/4 CPU cores; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8),
LANGUAGE=en_CA:en (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

___
pkg-firebird-general mailing list
pkg-firebird-gene...@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-firebird-general
diff -Nru firebird3.0-3.0.2.32703.ds4/debian/rules 
firebird3.0-3.0.2.32703.ds4/debian/rules
--- firebird3.0-3.0.2.32703.ds4/debian/rules2017-09-07 01:35:34.0 
-0600
+++ firebird3.0-3.0.2.32703.ds4/debian/rules2017-10-27 12:39:22.0 
-0600
@@ -65,7 +65,7 @@
 RUN := /run/firebird${FB_VER}
 
 export DEB_BUILD_MAINT_OPTIONS := hardening=+bindnow
-export DEB_CXXFLAGS_MAINT_APPEND := -std=gnu++98 -fno-lifetime-dse 
-fno-delete-null-pointer-checks -fno-strict-aliasing
+export DEB_CXXFLAGS_MAINT_APPEND := -std=gnu++98 -DUCHAR_TYPE=uint16_t 
-fno-lifetime-dse -fno-delete-null-pointer-checks -fno-strict-aliasing
 export DEB_CFLAGS_MAINT_APPEND := -fno-strict-aliasing
 
 DPKG_EXPORT_BUILDFLAGS := 1
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] rpmbuild is still used in 2.5 branch

[marius adrian popa]

I have added a  new pull request for 2.5 branch
in .travis.yml i have commented the make dist (doesn't make sense to
install it if we don't run tests on it , and rpmbuild is broken on ubuntu
distros )

https://github.com/FirebirdSQL/firebird/pull/124

On Thu, Oct 26, 2017 at 9:08 PM, Alex Peshkoff via Firebird-devel <
firebird-devel@lists.sourceforge.net> wrote:

> On 10/26/17 18:13, marius adrian popa wrote:
>
>> rpm build failed on travis when doing make dist
>>
>> so I will redo the pull request
>>
>>
> Marius, just please do not try to place a cart in front of a horse.
> Changing FB built order, specially for version that people use for many
> years, is not good idea. Certainly if you add PR changing travis-only build
> (a kind of pre-travis patch removing rpm for travis build only) I see no
> problems. If it's hard to achieve add new target into makefile that will do
> all what you need (build dist w/o rpmfile) but please don't change behavior
> of existing rules.
>
>
>
>
> 
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Sourcetrail is now free for non comercial use

[marius adrian popa]

Sourcetrail is now free for non comercial use : It's very good for large
projects c++ source code study

like firebird

https://www.sourcetrail.com/blog/release_2017_4/
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel