Full Text Search UDR for Firebird 3 and 4 based on Lucene++

To enhance the Firebird functionality, IBSurgeon has sponsored the development and now released for public use the free open source “IBSurgeon Full Text Search UDR” to perform full text search queries within SQL and PSQL. UDR works with Firebird 3 and 4, for Windows there are ready-to-use binaries, for Linux it is necessary to build the UDR.

The UDR is based on Lucene++ engine, with all the powerful features required for full text search and with very fast performance (build as native C++ library).

The binaries of IBSurgeon Full Text Search UDR, its sources, and documentation are available on GitHub https://github.com/IBSurgeon/lucene_udr

Please download, read documentation, use, provide feedback (via GitHub Issues) and join to its group in Telegram (support and development).

And don’t forget to mark it with star on GitHub!

Going to 2K views

The interview I did with Ann Harrison, the mother of Firebird, is about to reach 2.000 views on Youtube! If you didn’t see it yet, watch it now, hit the “like” button and subscribe to the channel! Ann is married to Jim Starkey, the creator of InterBase. She have shared a lot of her memories from the time IB got open sourced and Firebird was born! A must see! The audio is in English with Portuguese subtitles.

Source Code Of IBProvider Client For Firebird

Hello Everyone.

Recently we published the source code of IBProvider built-in client for work with Firebird without fbclient.dll.

https://github.com/ibprovider/TechDemo-IBProvider.FirebirdClient-v01

It supports Firebird from v0.9.4 till v3.0.

It’s a stable and completely tested thing which has worked since 2017.

If you are interested in such things – you are welcome.

Source code of the test system is available, too.

License: MIT.

Regards, IBProvider team.

Firebird 3.0.10 was released

Firebird Project is happy to announce general availability of Firebird 3.0.10 — the latest 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, packages for Mac OS will follow shortly.

The Firebird Project

New version of RedExpert 2022.05 is available

Added:

  1. Support for Firebird/RedDatabase 4 type
  2. Tablespaces support
  3. Explained plan support for Firebird/RedDatabase 3.0 and higher
  4. Table related triggers tab and navigation
  5. Editing objects in the database browser
  6. Execution of procedures and functions when viewing and editing them
  7. Ability to place the editor vertically or horizontally
  8. Search by text in any SQL-field

Fixed:

  1. Calculating trigger type using bitwise operations
  2. Reloading of system objects after creating a table via GUI
  3. Continue data generation when data mismatch error occurs
  4. Generating SQL for a procedure without parameters
  5. Reloading the object tree during CREATE OR ALTER and RECREATE operations
  6. Autocomplete freeze
  7. Commenting/uncommenting using “CTRL + /”
  8. Generate name for new connection
  9. Display in the center of the primary monitor when there are two monitors in Linux systems
  10. Show connection page without scrollbar
  11. Generate INSERT queries for DEFAULT fields

Download and install the new version

1 4 5 6 7 8