Poor man’s full-text search using PSQL only on Firebird

Article by Jiří {x2} Činčura:

I was presenting this idea on this year’s Firebird Conference. It’s an idea, working with some constraints of Firebird, but one can take it as an inspiration and maybe extend it to another usage on another platform. We had quite a productive discussion about possible improvements (I’ll describe mines at the end), but unless the people will provide the ideas in comments here too, you’ll have to use your own brain (you should’ve been there ;)).

I’ll show you the initial idea with some simple speed improvement of PSQL code itself. And then describe options in how to store it better, mostly because it’s very specific to needs and you’ll need to tune it for your scenario.

Read more

Firebird Perl extension DBD-Firebird version 1.24 is released

Perl extension DBD::Firebird version 1.24 is released with a few Firebird3/Debian related changes :
* Fix 81-event-fork.t to not fail when FirebirdEmbedded is not available
* Avoid compiler warning about implicit declaration of dbd_st_finish_internal
* Add support for building/testing with Firebird 3
* Fix a couple of typos, thanks to Nick Morrott of Debian Perl Group
* Explicitly undef the statement handle in dbi-primary-key-info.t, avoiding an error during global destruction

Firebird 3.0.1 is available

Firebird Project is happy to announce general availability of Firebird 3.0.1 — the first 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 and Linux on both 32-bit and 64-bit platforms are immediately available for download.

Do you plan to move to Firebird 3? Wanna avoid unnecessary headaches? Check out the Migration Guide to Firebird 3 right now!

ANN: Firebird PHP Generator 16.9 released

Firebird PHP Generator SQL Maestro Group announces the release of Firebird PHP Generator 16.9, a frontend to generate feature-rich CRUD web applications for your Firebird database.

New version comes with 30+ new features including column filtering, custom form layouts, enhanced master-detail views, multi-row column headers, record comparison, brand new inline forms, quick edit, breadcrumb navigation, geo charts, index page generation, a number of GUI improvements, and much more. There are also versions for other DBMS (MySQL, PostgreSQL, SQLite, Oracle, etc).

Most of software features can be seen in action in Feature Demo and NBA Demo applications.

Read full press-release.

1 3 4 5 6 7 15