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 Branch for C++11 support

Adriano dos Santos Fernandes wrote on Firebird-Devel

Hi!

I created a branch for the C++11 usage proposal.

The branch is not for active development, it’s just so others can play,
test and discuss.

The features are described here:
https://github.com/FirebirdSQL/firebird/blob/work/c%2B%2B11/doc/README.modern_cpp.md

I didn’t found explicit mentioning support of the function features per
compiler, but seems very basic feature for lambdas so I put it there.

I tested in clang++ 3.8.0, g++ 5.4.0 and MSVC 14.

Database .NET 19.4 and dbMigration .NET 3.6 released!

Database .NET 19.4 is an innovative, powerful and intuitive multiple database management tool. You can browse/grant objects, design tables, edit rows, run queries, generate scripts, analyze/monitor SQL and import/export/migrate/sync data with a consistent interface. (Full support for Firebird 1.5~3.0+)

For more information please visit http://fishcodelib.com/Database.htm
Free, All-In-One, Portable, Single executable file and Multi-language.


dbMigration .NET 3.6 is a simple, easy and intuitive multiple database migration and data synchronization tool, With it you can easily migrate schema and data between different databases without complicated procedures.

Supported databases: Firebird 1.5~3.0+, PostgreSQL, SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, HP Vertica, NuoDB, Teradata, Sybase ASE, SQLite, SQLCe, Access, dBase, FoxPro, Excel, ODBC, OLEDB, Text…etc.

For more information please visit http://fishcodelib.com/DBMigration.htm
Free, All-In-One, Portable, and Single executable file.

1 59 60 61 62 63 200