Category: General news

Firebird related news

4 key distinctions of the new IBProvider v3.4 that make your applications faster

Leave a comment

4 key distinctions of the new IBProvider v3.4 that make your applications faster:

Firebird driver become faster
  1. Possibility to abort lengthy loading of resulting rowsets in SQL scripts.
  2. Control and adjustment at your own discretion of deferred data loading.
  3. Accelerated work with BLOB fields and arrays in updatable rowsets.
  4. Background garbage collector became multithreaded.

Please read details here: Firebird driver become faster

Firebirdsql website down – do not panic

Leave a comment

Please do not panic , the line upgrade went wrong so it will be soon fixed

Message from Helen :

>I will put SQL script into rabbit hole tomorrow (provided WEB server
>will be alife). Currently non of new/old IPs do not ping.

Message from Sean indicates things went wrong with the migration to the new subnet of the hosting provider. The current situation is that the Tracker is up, while the webserver is not serving pages. Can’t give more info at present as Sean is not at his desk today.

Learning from bugs using together : list,distinct,case,extract weekday

Leave a comment

Seems that the bug CORE-3302 is triggered when there are millions of rows and only in firebird 2.5 and 3.0 (Bug is already fixed in svn)
What you can learn from the bug is the usage of list,distinct,case,extract weekday in the same query

First i have created the query to extract the day in string format from current date
select
list(case extract(weekday from CURRENT_DATE) when 0 then 'Sun' when 1 then 'Mon' when 2 then 'Tue' when 3 then 'Wed' when 4 then 'Thu' when 5 then 'Fri' when 6 then 'Sat' end)
from RDB$DATABASE
In my case the result was Fri.
Then you can create a table with different dates:

CREATE table tasks
(
DATE_OF_TASK DATE
);

Populate the table

INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-07');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-07');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-07');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-06');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-06');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-06');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-08');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-08');
INSERT INTO TASKS (DATE_OF_TASK) VALUES ('2011-01-08');

Then start to run the query

select
list(distinct case extract(weekday from date_of_task) when 0 then 'Sun' when 1 then 'Mon' when 2 then 'Tue' when 3 then 'Wed' when 4 then 'Thu' when 5 then 'Fri' when 6 then 'Sat' end)
from tasks

Result should be: 

Fri,Sat,Thu

Firebird SQL linkedin Community is now an open group

Leave a comment

I am pleased to announce that, as the owner of this group, I have just switched us to an open discussion group. All future discussions will be fully visible, searchable, and shareable on the Web. All past discussions are now closed in a members-only archive. I look forward to our future discussions now joining the broader conversation of the wider Web.

Posted By Dumitru Condrea
Go to the complete announcement

Testing identity columns in Firebird 3.0

Leave a comment

Someone on support list asked about identity column in Firebird and how it can be managed easier and i remembered that identity is already supported firebird 3.0 so i fired up flamerobin and created a table with new identity column type similar to MSSQL “identity”, MySQL “auto_increment” or PostgreSQL “serial”
All worked as in documentation 🙂 inserting and selecting from the table no generators/triggers were needed to be created by hand

ibphoenix.com relaunched with new interface

Leave a comment

I like the new style for ibphoenix , minor glitch is the firebird image in corner is quite blurry and should be replaced with higher quality image
also on my monitor is too small 1920×1080 and i have to do 3xCTRL+ to fit the screen, maybe a liquid layout should be applied (i will send the bug and the fix) . In rest is great maybe is too much white in background and the stripped green background should be a added back ?

1 … 137 138 139 140 141 … 207