Boolean datatype implemented in FB 3

The support for a BOOLEAN datatype was the third most voted feature in the Firebird tracker. The deal with it was about make it right and complete, having booleans expressions allowed where values are expected, and vice versa. Oracle did it wrong and they BOOLEAN is crap.

Yesterday I finished and committed this support for Firebird 3. You can use them like any other type. You can index it, aggregate by it and sort by it. If you have an index on a boolean field, you can also do indexed searches by its negated form (NOT field).

Read full post in Adriano’s blog.

Firebird Case Studies

Hello All Firebirders!

Today we start very important activity  – building Firebird Case Studies catalog.

WHAT IS CASE STUDY?

Case study is an example of real-world implementation of certain product.
Case study should be very specific and describe:

  1. Technical details (database size, # of users, transactions load),
  2. Type of business (ERP, hospital automations, CD catalogs, web-sites examples, etc) and
  3. Business value – license costs economy, performance increasing, etc.

WHY FIREBIRD PROJECT NEEDS YOUR CASE STUDIES?

Can Firebird gain against MySQL?

From Marco Cantu’s blog:

Now, this could be a very good opportunity for all of the other open source database servers (and also some of paid ones!), particularly the most popular ones like Firebird and PostgreSQL. I’m particularly fond of Firebird (the InterBase offspring) and use it in many projects and did a lot of consulting to Delphi developers using it. Can this be the rise of Firebird? MySQL with its huge popularity has certainly obscured it, so it could be a good time to act.

Morfik 3 released – now free to everyone

Morfik is used to easily develop rich Internet applications that can be run also in devices, like the iPhone. They just released the version 3 of the product, with some interesting news:

NO MORE PAY TO PLAY

With this release, we have changed the game, significantly. Now you don’t have to pay to play the game! That’s right,  Morfik 3 AppsBuilder is no longer licensed. It is accessible to everyone – at no cost.

Download Morfik 3 now!

There is no catch. We are serious about enabling developers to take full advantage of the power of the Web. This is about making it as easy as possible for all to discover, use and be successful with Morfik. We want to build the community of active users, which will ultimately help you get the most out of your Morfik development environment.

I remember Morfik having a “free” version in the past, and after some time, they changed their minds and started to offer only paid/licensed versions. I hope this time they are serious about the “there is no catch” thing.

Morfik uses Firebird as its default database.

Procedure to rebuild all indexes

After reading news about rebuilding Firebird indexes, I wrote a procedure for Windows, which allows fully automatic rebuild all indexes in the Firebird database. The procedure is described on my website http://gskoczylas.rekord.pl/Firebird/AutoReindexAll.php (in Polish). Automatic translation into English is here: http://goo.gl/9Uu96.

At the end of the web page there is a link which allows to download the complete procedure. Procedure has been tested on Windows Vista with Firebird 2.5.


Regards,

Grzegorz Skoczylas
gskoczylas@gmail.com

1 28 29 30 31 32 100