Migration Guide to FB 4, in English?

I’m happy to announce that the English version of my newest book, Migration Guide to Firebird 4, will be released in the upcoming weeks. The eBook is already being proofread!

As it already happens with the Migration Guide to FB 3, people will be able to buy the eBook here at FirebirdNews.org and the paper version at Amazon.

Stay tuned to FirebirdNews to be informed when the book is out.

Migration Guide to Firebird 4

I’m proud to announce that my new eBook, Migration Guide to Firebird 4, will be released in 23, August. The eBook has 219 pages, and it is written in Portuguese. I’m still not sure if I’ll make an English version this time… mostly depends on the number of requests that I may receive (feel free to use the comments in this post).

Once again, this is a “solo” project, as I’m the author, editor and publisher. This work was made possible thanks to the 300+ people who contributed in the Brazilian crowdfunding campaign: Thank you all!

The Guide is devoted to developers using any version of Firebird who wants to move to Firebird 4 in the most straight and peaceful way. It probably can save hours of work!

The eBook will start selling to the public starting at August, 30, in the FireBase on-line store.

Firebird 4 is released

Firebird Project is happy to announce general availability of Firebird 4.0 — the latest major release of the Firebird relational database.

Firebird 4.0 introduces new data types and many improvements without radical changes in architecture or operation, the most important are:

  • Built-in logical replication;
  • Extended length of metadata identifiers (up to 63 characters);
  • New INT128 and DECFLOAT data types, longer precision for NUMERIC/DECIMAL data types;
  • Support for international time zones;
  • Configurable time-outs for connections and statements;
  • Pooling of external connections;
  • Batch operations in the API;
  • Built-in cryptographic functions;
  • New ODS (version 13) with new system and monitoring tables;
  • Maximum page size increased to 32KB.

Please refer to the Release Notes for the full list of changes. The complete Language Reference is also available.

Binary kits for Windows, Linux and Android platforms (both 32-bit and 64-bit) are immediately available for download.

Firebird Yahoogroups archive

Mark Rotteveel posted on twitter:

In case anyone is interested in the archive of Firebird mailing lists that were hosted on Yahoo Groups: …http://fb-list-archive.s3-website-eu-west-1.amazonaws.com (up to the 14th of December 2019)

I’m considering the idea to also add messages after the 14th of December 2019 (when the Yahoo Groups archive closed down) and the final shutdown of Yahoo Groups at the end of 2020.

Mark Roteveel on twitter

Tutorial to use Firebird on Android

Jan Baumgarten wrote a tutorial on how to create a simple application using Delphi + ZeosLib and Firebird 4RC1 on Android devices.

Firebird binaries for Android are around for quite some time as “test” releases, but there is a lack of information about how to use it in Delphi applications. Well, seems that no more 😉

Firebird 3 Language Reference

The Firebird Documentation Team is proud to announce the first release of the English Firebird 3.0 Language Reference (HTMLPDF). You can also find it on the Documentation page. This new Language Reference covers all SQL syntax of Firebird 3.0.

The new English Firebird 3.0 Language Reference is based in part on the Russian Firebird 3.0 Language Reference, but is not a direct translation (though we thankfully copied parts of it). Work has also been started on the Firebird 4.0 Language Reference.

Developer’s Pub presents Ann Harrison

The second episode of the Developer’s Pub series is now online, and the interviewed is no one less than Ann Harrison, the “mother of InterBase/Firebird”, telling us great histories of her life and the time spent with InterBase and Firebird… and Jim, of course! Enjoy watching, and don’t forget to give your like!

Firebird 4 RC1

Firebird Project announces the first Release Candidate of Firebird 4.0, the next major version of the Firebird relational database, which is now available for testing on Windows and Linux platforms.

This Release Candidate demonstrates the complete set of features and improvements developed for the new release. Release Candidates are generally considered stable enough and may be recommended for testing in “almost-production” environments. 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.

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

Firebird automated testing site

Alexey Kovyazin recently shared some interesting news:

Hi All,

FYI – http://firebirdtest.com
This website is a frontend of FBT + OLTP+automated scripts, supported by Pavel Zotov and some IBSurgeon employees.

It is running FBT tests on Windows server (8Gb, 4cores) for SuperServer and Classic for 3.0 and 4.0, and OLTP-EMUL for SuperServer 3.0/4.0.

Tests are triggered automatically, when new build appear at
http://web.firebirdsql.org/download/snapshot_builds/win/3.0/
http://web.firebirdsql.org/download/snapshot_builds/win/4.0/

As a result of test run, the report is generated.
Description
P – passed (ok)
Failed test due to failed assert is marked as F (failed), pink
Failed due to runtime marked as E (error), yellow.
Failed due to Firebird crash – F red/violet

For each error there is a hint (mouseover) with details of the error.

After click on the cell, the new page will be opened with more details and history of runs.

Detailed links:

  1. Total results for each kind of outcome and server mode
  2. ERRORS MAP: distribution of Firebird errors which occured during runs
  3. FRESH FAILS: tests which failed for LAST execution only
  4. FRESH ERRORS: tests which raised run-time error for LAST execution only
  5. STILL FAILS: tests which fail for at least two last runs
  6. Has fails: tests with at least one fail for previous runs
  7. Has runtime errors: tests with at least one runtime error for previous runs
  8. FRESH PASSED: successful tests with previous outcome = FAIL/ERROR/SKIPPED or absent
  9. All tests: outcomes – all results for last 30 runs
  10. All tests: A. Skipped: tests which was intentionally excluded from execution

Firebird OLTP Emul results
OLTP Emul simulates high load OLTP aplication, and uses many
sophisticated SQLs in multi-thread environment.

Our plan for the future:
1) Publish sources of automated scripts to GitHub (need to clean them a bit)
2) Perform Linux tests and include report results to the frontend
3) improve web representation – https certificate, design, etc
4) Migrate to the new FBT test framework when its adoption will be completed

We invite all interested to join the effort.
Pavel Zotov is a coordinator of the project – pz@ibase.ru.

Regards,
Alexey Kovyazin
IBSurgeon

17th FDD – record of donations!

The 17th FDD in Brazil, organised by Carlos Cantu, were a huge success! It was convened online for the first time, due to Covid-19. There were 720 attendees, and the traditional collection of donations netted a record R$ 8.163,35 after tax, for Firebird development.

The list of donors and their donations is at https://www.firebirddevelopersday.com.br/fdd/17fdd_donors.html.

Source: firebirdsql.org/en/news/firebird-developer-days-convened-online-in-2020

1 4 5 6 7 8 101