Month: July 2009

Trees in the database: Advanced data structures

Leave a comment

Lorenzo Alberton wrote in his blog about his paper presented at PHP conference

Storing tree structures in a bi-dimensional table has always been problematic. The simplest tree models are usually quite inefficient, while more complex ones aren’t necessarily better. In this talk I briefly go through the most used models (adjacency list, materialized path, nested sets) and introduce some more advanced ones belonging to the nested intervals family

ED: some of the principles can be applied to Firebird with CTE

A new release of the Firebird Eclipse plugin is available

Leave a comment

A new release of the Firebird Eclipse plugin is available on
http://www.lawinegevaar.nl/firebird

Version 1.0.1.200907101543

Bugfix and ‘less-is-more’ release

Changes:
* Code cleanup
* More delegation to standard DTP implementation
* Sourcecode added to distribution

What roles is user able to use?

Leave a comment

About a month ago there was a question in Firebird (CZ) group how to find whether the user is able to use particular role or to get all roles for user.

As you probably know, a lot of stuff (almost everything) is in system catalog (system tables). The only problem is to figure out what’s the right set of parameters to use. To get all roles with users able to use it, you can use …

FB/Java plugin Milestone 1 (Firebird External engine )

Leave a comment

I’m pleased to announce availability of the first test version of
FB/Java plugin.

FB/Java is a plugin for FB external engines feature, to be presented in
v3.0, that allows execution of Java code at the server side. The plugin
allows classes/resources in the file system or stored in the database.
File system classes/resources are global and the code run with all
permissions. Database classes/resources are per-database and code runs
accordingly with per-engine configured security policy.

Also it seems that is quite fast from Adriano’s tweets

Usage of BOOLEAN and GUID types in Firebird and Interbase now available with IBProvider

Leave a comment

 
GUID type is currently not supported by any Firebird and Interbase server, but it is frequently used by different clients (for example, in ADO Entity Framework).

Boolean type is supported by Interbase starting from 7th version and is not supported by Firebird server. IBProvider can work with this type, but it lacks support from other servers.

New release of IBProvider 3.0.0.7446 supports Guid and Boolean types at driver level, and now you can freely use these types in your applications irrespective of Interbase and Firebird server versions.

Absolutely fresh article of how to with types via IBProvider:
Usage of BOOLEAN and GUID types in Firebird and Interbase.

1 2 3