Xubuntu 19.04: The Exhaustive Update

Xubuntu 19.04: The Exhaustive Update #Xubuntu #Xfce #DiscoDingo https://bluesabre.org/2019/04/18/xubuntu-19-04-the-exhaustive-update/

Firebird 4.0 Beta 1 release is available for testing

Firebird Project announces the first Beta release of Firebird 4.0, the next major version of the Firebird relational database, which is now available for testing.

This Beta release arrives with features and improvements already implemented by the Firebird development team, as well as with countless bugfixes. Our users are appreciated giving it a try and providing feedback to the development mailing list. Apparent bugs can be reported directly to the bugtracker.

Beta releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release.

Please read the Release Notes carefully before installing and testing this Beta release.

Pure Elixir database driver for Firebird

Pure Elixir database driver for Firebird

https://github.com/nakagami/firebirdex

Firebird 4.0 Built-in logical replication

Firebird 4.0 implemented Built-in logical replication is now merged

Here is the pull request

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


We know that is a long standing feature request

Wow! @firebirdsql team implemented a feature that I asked 10+ years ago!https://t.co/tRrg9YvkWW
"Built-in logical replication"
Thank you guys.

— Daniele Teti (@danieleteti) January 25, 2019

Firebird 4.0 Changed travis distribution used to Ubuntu xenial.

Firebird 4.0 is using Ubuntu xenial on travis .
https://travis-ci.org/FirebirdSQL/firebird

.travis.yml looks a lot simpler after this change.

 

ps: Here is official Travis CI announcement: Ubuntu Xenial 16.04 is available

Max Transaction ID in Firebird

Firebird 3.0.x introduced 48-bit internal transaction IDs that are publicly (via API and MON$ tables) represented as 64-bit numbers. This makes the new limit roughly equal to 2.8*10^14 transactions, later it could be extended up to the 2^63 limit.


Related notice in Firebird 3.0.x release notes.
Related article about Posgtresql : How long will a 64 bit Transaction-ID last in PostgreSQL?

Understanding Debian: The Universal Operating System

"And my final test as to whether or not Debian succeeded was: could the founder step away from the project and could the project keep going because that is the only point at which you know that the project has basically taken a life of its own." ~ Ian Murdock

Compiz: Ubuntu Desktop's little known best friend

What i love in Ubuntu : woobly windows via compiz





https://code.mradford.com/post/the-ubuntu-compiz-desktop/

Firebird 3.0.4 sub-release is available

Firebird Project is happy to announce general availability of Firebird 3.0.4 — the 4th point release in the Firebird 3.0 series.

This sub-release offers many bug fixes and also adds a few improvements, please refer to the Release Notes for the full list of changes. Binary kits for Windows, Linux and Android platforms are immediately available for download, Mac OS kits will follow shortly.

Firebird Visual Studio 2017 builds are added to AppVeyor

Firebird Visual Studio 2017 builds are added to AppVeyor for x64 and x86 Platforms

Firebird has now automatic Windows builds with AppVeyor

Firebird has now AppVeyor CI builds, like we have them with travis, but

AppVeyor is for Windows related compilers (Visual Studio)


https://ci.appveyor.com/project/FirebirdSQL/firebird

Firebird 4.0: Time Zone feature documentation

Via Firebird-devel : Here is the first README version for the Time Zone feature in Firebird 4.0

https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.time_zone.md

LibreOffice is now available for Haiku

LibreOffice is working and already can be installed via HaikuDepot.

Here is the full announcement

https://discuss.haiku-os.org/t/libreoffice-is-now-available-for-haiku/6917

C++ the Newest Old Language : presentation by Matt Godbolt (GOTO Chicago 2018)

This presentation was recorded at GOTO Chicago 2018 C++ is an old language only used by the unfortunate few that absolutely have to, right? Wrong! C++ is not the language it used to be: clunky, error-prone and lacking in tooling. A lot has changed in the last decade: three new language revisions, new compilers and all-new: [...] Download slides and read the full abstract here: https://gotochgo.com/2018/sessions/359

Vote for Firebird as Sourceforge Project of the month (May 2018)

Sourceforge is running a poll to elect its May’s Project of the Month, and Firebird is among the candidates.


To vote, you need to have an account (it is free to register) at sourceforge.net and go to this URL, and comment with the following line:

VOTE: firebird

Some of the few advantages of using Firebird 3.0.x is that performance was greatly improved vs 2.5.x

Here are a few related performance/tunning articles

In the first article Vlad does quite a few benchmarks between Firebird 2.5/3.0.0/3.0.2 releases . It's very nice that minor releases brings free speedups. He also shows Firebird 3.0.3 performance related changes and fixes and the future ones that are already in Firebird 4
 
 Firebird Performance, by Vlad Khorsun, Firebird Project
 Tuning Linux, Windows, and Firebird for heavy workload by Alex Kovyazin, IBSurgeon.
 Firebird 3: New in Database Statistics and New SQL execution plans, by Dmitry Kuzmenko, IBSurgeon
 Advanced Firebird Trace API, by Vlad Horsun, Firebird Project

Firebird 3.0.3 Binary kits for macOS on both 32-bit and 64-bit platforms are immediately available for download

Firebird 3.0.3 Binary kits for macOS on both 32-bit and 64-bit platforms are immediately available for download

Firebird 3.0.3 sub-release is available

Firebird Project is happy to announce general availability of Firebird 3.0.3 — the third point release in the Firebird 3.0 series.

This sub-release offers many bug fixes (including fix for a recently reported security vulnerability) and also adds a few minor features and improvements, please refer to the Release Notes for the full list of changes. Binary kits for Windows and Linux on both 32-bit and 64-bit platforms are immediately available for download.

ps: Mac OS builds are coming soon

In 2017, The Document Foundation (TDF) launched four tenders aimed at improving LibreOffice. Tender four is of interest to the Firebird community

In 2017, The Document Foundation (TDF) launched four tenders aimed at improving LibreOffice. Tender four is of interest to the 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

LibreOffice Firebird driver related changes

There were quite a few bugs fixed in the last two months related to Firebird driver in LibreOffice also interesting commits

Tamas Bunth commited : Add HSQLDB schema import.
He also fixed Bug 104734 - FIREBIRD: Add those field types that are not available with FB while they are available with Hsqldb.
Lionel Elie Mamane fixed Bug 104986 - Firebird: Function EXTRACT doesn't work with WEEKDAY, YEARDAY, MILLISECOND.

Tor Lillqvist fixed Bug 71007 - EDITING: Embedded Firebird - Impossible to set milliseconds in a timefield with GUI

Tamas Bunth fixed Bug 70425 - EDITING: Embedded Firebird - Copying integer values from Calc to Base impossible